• Loading flat file into a database table with SSIS

    Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process: Get file from local or FTP Delete the old file which doesn't exist anymore in the database Insert only new records in the database Automated Don't overheat SQL...

    ITKE346,360 pointsBadges:
  • SQL Server 2012 CONCAT producing strange characters.

    Not sure what's going on here. I created the following query to produce quantity results by month: SELECT CONCAT( MONTHNAME(published) , ' ' , YEAR(published)) AS monthyear, COUNT(*) AS total FROM blog_articles WHERE status = 'Online' AND Year(published) = 2013 GROUP BY CONCAT( MONTHNAME(published)...

    ITKE346,360 pointsBadges:
  • Intellisense isn’t working in SQL Server 2008 R2

    We just got a new machine but everything was already installed on it, including SQL Server 2008 R2 and Visual Studio 2010 SP1. However, I don't have any intellisense in SQL Server Management Studio (aka it's not working). What should I do?

    ITKE346,360 pointsBadges:
  • Remote Call issues in SQL Server 2008 R2

    I’m having problems connecting to my database remotely in SQL Server 2008 R2. I get the following error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct...

    ITKE346,360 pointsBadges:
  • Controlling VPN access

    Here's my scenario. I fall under guidelines of HIPAA. I have mobile users using laptops and tablets loaded with Cisco VPN CLient connecting to my Cisco 2811 ISR which functions as my router/firewall/VPN. I am using Micorosoft AD in my domain. To authenticate users to the domain. Is there an easy...

    Gforsythe75 pointsBadges:
  • Store and date times in SQL Server 2008

    Which is the proper way to store and date times in SQL Server 2008?datetimedatetime2I know the majority of differences between the two but should we just use datetime2 only?

    ITKE346,360 pointsBadges:
  • How to create a table variable in SQL Server 2008 R2?

    How can I create a table variable (virtual in-memory table) with columns that match the stored procedure resultset? I tried to execute the procedure using column names I specified. Does the data type of the columns need to be the same as the stored procedure? Here is what I tried:DECLARE @Table...

    ITKE346,360 pointsBadges:
  • How to clone a table in SQL Server Express 2012?

    I’ve built a SQL Server table with several columns with an index starting from 1 as the primary key. I need to clone this table but without the data and with a different index starting from 100. I don’t know how to do this. I am using SQL Server 2012 Express that came with Visual Studio 2012.

    ITKE346,360 pointsBadges:
  • Creating a trigger in SQL Server 2008 R2

    I have three tables in SQL Server 2008 and they all have the PK-FK-FK-relationship. 1st table: I have a column name with the name as "STATUS" that contains the value "active" or "inactive". 2nd table: I have the column with the name FKNEWLoanReviewfieldid, which has multiple values 3rd table: The...

    ITKE346,360 pointsBadges:
  • Best way to manage tables in SQL Server 2012?

    I have a table that captures about 100,000 records per day. As you can imagine, the size and performance of such a table would degrade as it quickly went well over 50 million records. I want to try something different, and that is the creation of a new table every day, so that the number of records...

    ITKE346,360 pointsBadges:
  • Incompatibility issues between SQL Server 2012 and Visual Studio 2012

    I am hitting a strange error while trying to create an SQL Database project in Visual Studio 2012. Unable to open Database Project This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer. I am using SQL Server 2012 Developers Edition...

    ITKE346,360 pointsBadges:
  • Using bulk delete on SQL Server 2008

    Looking for a way to "Bulk delete" in SQL Server 2008. Since I want to use WHERE for limiting the rows in action, I know I can't use TRUNCATE. Should I use something like "batch deletes" or "bulk copy"?

    ITKE346,360 pointsBadges:
  • Rolling back updates in SQL Server 2014

    Is there anything that will allow to rollback and UPDATE query in SQL Server 2014 that was not available in previous versions? I’m referring to committed commands – I know you can rollback if query is inside transaction. We have full, differential and transaction log backups in place but we’d...

    ITKE346,360 pointsBadges:
  • Merging columns in SQL Server database

    Hi everyone! In my SQL Server database, I'm trying to merge the following: [TicketID], [Person] T0001 Alice T0001 Bob T0002 Catherine T0002 Doug T0003 Elaine Into this: [TicketID], [People] T0001 Alice, Bob T0002 Catherine, Doug T0003 Elaine Now, I know there's the function "GROUP_CONCAT" for MySQL...

    ITKE346,360 pointsBadges:
  • Remote connection error using SQL Server Express 2012

    Now, I've recently added SQL Server Express 2012 to my home server. I'm trying to connect to it from Visual Studio 2012 from my machine but I keep getting this error:A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was...

    ITKE346,360 pointsBadges:
  • Email Trigger failing in SQL Server 2012

    I'm having trouble getting a trigger to work.No errors are being thrown, but nothing is being email either. Is it my nested select? Use ABCTRAINING SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO alter TRIGGER TAXPERCENT ON [dbo].[AP101_VOUCHER_DISTR] AFTER update AS declare @VAT numeric(15,2),...

    ITKE346,360 pointsBadges:
  • Does SQL Server 2008 lack “datetime”?

    Does SQL Server 2008 allow for the datatype “datetime”? I’ve primarily worked on SQL Server 2005. I found out about the gap when I built an entity framework model while using a 2008 database. When I tried to update the entity on a 2005 database I got the following error: The version of SQL...

    ITKE346,360 pointsBadges:
  • Cannot find server name

    I’ve just started learning ASP.net and I installed Visual Studio 2010 and Microsoft SQL Server 2008. When I connected SQL server management studio to the server message box and tried to enter a server name, the connection failed. How can I find the name of the server? Is there something else I...

    ITKE346,360 pointsBadges:
  • Upgrading to SQL Server 2008 R2

    This might be a simple question but I have SQL Server 2008 in my machine and I'm looking to upgrade to SQL Server 2008 R2. What's the easiest way possible to do it? Any documentation would be great.Thank you!

    ITKE346,360 pointsBadges:
  • SSIS on SQL Server 2012

    We're in the middle of upgrading from SQL Server 2005 to SQL Server 2012. However, there's a good amount of SSIS running on this server. Can we re-deploy these packages on the new SQL instance? Will we have to go through Visual Studio upgrade for each? Thanks!

    ITKE346,360 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following