mar10br0 (8/1/2011)

---

It's when in a badly designed table without a primary key and true duplicates occur (every column having the same value), it is technically impossible to delete one and...

Steve Jones - SSC Editor (8/1/2011)

---

I certainly wouldn't want to unexpectedly make the switch with a chaos monkey, but I might schedule a few outages during the year and really...

I really like the chaos monkey idea but I don't think it makes senses to do it everywhere. The benefit that Netflix has is that everything is supposed to...

Stored procedures can have parallel plans. Chances are the plans were compiled with...

Since SQL identifiers have to start with a letter SQL knows that the "1" can't be the start of a column name and as such has to be a number....

Ninja's_RGR'us (7/29/2011)

---

There's not much to discuss here. Converting to char takes hours while int takes seconds. The server has already answered your question.

The difference is that one uses...

One option is to create a temp table with the proper collation and use that to sort. Another option is to cast the column as the appropriate collation. ...

Is there a particular reason you need it as a char(4)? If there's a reason providing DDL and the execution plan will help us figure out the best...

Eric M Russell (7/27/2011)

---

When a table is edited in SSMS, say to add a column or alter it's datatype, the operation will often times be scripted out in the form...

I don't...

I could have sworn that there was a function you could run to see if any enterprise features are being used but I can't track it down. If you...

I don't know off hand which account SQL will use to access the file, probably the SQL service account, but it may not hurt to make sure account B has...

You have a few different options. You can write a VBScript or powershell script to move it, use the move DOS command, or put a third part utility like...

I don't know of any memory difference for local versus global temp tables. I wouldn't be surprised if global ones took more resources because they need to be more...

The select into could be done outside the dynamic SQL and it should function the same. I hope they know the consequences of not thinking out the table definition....