If those rows are actual unique, collected data (as opposed to generated data, which Jeff Moden is addressing), then you might also consider something like BULK INSERT instead of parameter...

Do you have the same amount of data in test as in production? If not, your testing isn't going to find volume based performance issues, nor will you be...

In job step advanced properties, set the output file, and try again. Then use the output file to determine what's going on; the job step history is limited to...

In other words - it only matter what the ANSI_PADDING setting was when you created the tables or added the columns. If the server default was changed after the column...

For minor possible changes, you can look at adding the options:

BLOCKSIZE = 65536

BUFFERCOUNT = <something appropriate - maybe try 12 for 4GB RAM or any 32-bit, 128 for 64GB RAM>

MAXTRANSFERSIZE...

I actually have to keep asking developers "Why do you want to put that in SQL Server? What value does SQL Server and a relational model add to that...

In my area, there are few SQL developers; lots of SSRS/SSIS developers, but few with solid pure SQL skills. Not many good administrative DBA's, either. Note that both...

I'd have to rate the particular example selected as "Implement all the requirements to get system table updates to act as expected."

In this case, the failure wasn't in updating system...

If your only currently known symptom is "some SQL statements are slow", then you need to start with the usual analysis steps even before you get to troubleshooting.

1) What is...

My set of three rules is somewhat different - I say

0) Develop on a full size set of data that is as similar to production as possible. In...

Attempting to change a variety of SET options has no effect. SQL 2008 acts like SQL 2012.

The RESTORE VERIFYONLY on a file that exists returns two errors; SQL 2005...

Further information to date - on both 2005 and 2012 servers, the usual divide by zero example is caught without showing any errors at all.

BEGIN TRY

...

It depends; smaller shops often need more generalists. Larger shops often only want a triangular pegs for triangular holes.

There's also a large amount of personal preference involved; some people...

Eric M Russell (9/7/2012)

---

The sysadmin can always reset the password for a user for service account; why would one user ever need to "crack" another user's SQL Server account password...

Eric M Russell (9/7/2012)

---

If cracking encypted data is what one does for a living, then I could see a need for a high end graphics card. However, most employees, even...