Thanks for the tip on that white paper. I had browsed MSDN looking for help but didn't come across that document. After a quick look through the profiling...

That script modification solves the problem. Thank you.

17 of the 23 rows in the table get the default value. The other 6 rows get updated with 6 distinct values.

Here's the relevant parts of the...

All our tables of this nature have ModifiedOn, ModifiedBy, and RowCheckSum fields as the last three fields in the table. So the new field had to be inserted before...

Unfortunately, my column insert is not performed with an ALTER statement. I first create a temp table where the new column is 5th out of 8 columns. 2)Insert original...

I was recruited to be a db developer full time after dabbling in SQL and stored procedures for several years in the BI world. I had always tested my...

I'd hire a individual who fits in and is anxious to learn something new before an argumentative know-it-all. The former will interact positively with the rest of the team,...

In addition to the other suggestions. why not ask the business owner of the data for their thoughts? Some of them are intelligent enough to know what a primary...

Before joining the DBA world I was an accountant, and was asked multiple times at different companies to falsify records to make these companies look better. I'm proud to...

I'm just guessing, but your BULK INSERT statement looks something like this - -

BULK INSERT

FROM 'filelocation\filename.txt'

WITH (FIELDTERMINATOR = ',') --if commas separate your values--

You said you...

I did this recently to determine if a row needed to be updated. I put a checksum column in the table using the values that could possibly be updated....

You're right, my response was somewhat whiny given that the original post was most likely a keyboard error, not a logic error. I'll save my criticisms for when I've accumulated...

I don't look at these challenges much. Today's item doesn't encourage me to do so in the future.

I'm not looking to change the location that Integration Services gets installed to, I'm looking to change the default folder a given SSIS package gets deployed to. In theory...

The command in question looks like this -

EXEC MASTER..xp_cmdshell 'BCP "EXEC GfmReplication.dbo.zz_ExportXml" queryout c:\Org.xml -S(local) -T -c'

The problem is that my script, being part of a unit test, was...