• 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...

    ITKE352,420 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?

    ITKE352,420 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"?

    ITKE352,420 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...

    ITKE352,420 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...

    ITKE352,420 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...

    ITKE352,420 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!

    ITKE352,420 pointsBadges:
  • Having problems connecting to SQL Server 2008 remotely

    I am trying to connect to my database in Visual Studio 2010 using the named instance by 123.123.123.123/instanceNameBut, I get the following error message: error provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server I have the following aspects enabled: open Port...

    ITKE352,420 pointsBadges:
  • Stored Procedure code in SQL Management Studio

    I'm trying to find a way to step into a stored procedure code in SQL Management Studio (in SQL Server 2008). I've heard its possible with Visual Studio but I'm looking for a debugging solution for Management Studio.

    ITKE352,420 pointsBadges:
  • SQL Server 2008: Query for names

    Now in SQL Server 2008, is there a way that I can query for names in all tables that contain the column with name. Something along these lines:%myName%

    ITKE352,420 pointsBadges:
  • How to calculate previous row value?

    Here is the model I am using: Data: Date Hours Worked FullDay 9/4/2013 7:13:00 No 9/6/2013 10:52:00 Yes 9/7/2013 6:43:00 No 9/10/2013 9:26:00 Yes FullDay column to be updated as 'Yes' if previous day worked hours is at least 8 hours. How can I calculate whether or not the previous row value is...

    ITKE352,420 pointsBadges:
  • Administrator privileges in SQL Server 2008

    I recently installed SQL Server 2008 R2 onto my local machine. However, I can't create a new database because I'm getting the following message:CREATE DATABASE PERMISSION DENIEDAfter I saw that message, I tried to switch my administrator privileges but I received this:"User does not have permission...

    ITKE352,420 pointsBadges:
  • Windows Forms and SQL Server 2008 database

    Now, I have created two different things: A local database and a Windows form. With the Windows form (In Server Explorer), I added the database's connection. How can I begin querying it using LING-to-SQL? Thanks!

    ITKE352,420 pointsBadges:
  • How to store TOP 2 variables in SQL Server 2008?

    How can I make it so that I can store the top 2 results in 2 variables?create table t(id int); insert into t (id) values (1),(2),(3),(4); declare @id1 int declare @id2 int select top 2 @id1 = first id, @id2 = next id from tIs there a way to make this happen in one query without using a loop?

    ITKE352,420 pointsBadges:
  • T-SQL: Split function

    I'm trying to split "1, 2, 3, 4, 5, 6, 7, 8, 9, 10" into a table or table variable. Is there a function that returns each number in a row?

    ITKE352,420 pointsBadges:
  • I keep receiving an error in SQL Management Studio

    When I'm trying to create several users in SQL Management Studio, I first create them under the server name, followed by the database. However, when I'm trying to log on, I keep getting this error message: A connection was successfully established with the server, but then an error occurred during...

    ITKE352,420 pointsBadges:
  • Logging and finding queries in SQL Server 2008

    In SQL Server 2008's activity monitor, I can see the most expensive queries. But my question is if I can actually log this info via Query Analyser? Thanks!

    ITKE352,420 pointsBadges:
  • iDB2 connection String permenant solution

    I have a DB2 connection string to our i-Series that works. "DataSource=10.10.10.10;userid=LIVEXML;password=LIVE1;DefaultCollection=DATALIB031;" We have been developing a lot of apps and web services that use this type of connection. My problem is when our i-Series software is upgraded (about every...

    ToddN200015,605 pointsBadges:
  • SQL Server configuration

    How would I configure SQL Server 2008 R2 to handle 1 million connections?

    ETCGMan40 pointsBadges:
  • How to query a SQL Server 2008 database from Outlook

    The purpose of this module is to monitor the activity of Outlook and grab the attachment (. Zip file) for a specific email address and subject line and place it on the server (and create the Server Folder(s) Structure: CompanyName->weekNo.->zip file(s)) I have to mention that we are going to...

    SoftwareQuestions5 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