For one, worker threads shouldn't be set to the max. The default of 255 will handle 1000 sessions.

Second, as Colin asked, what else have you changed?

reboot.

Something's wrong. I've seen this at times and the only thing that will clear it is a restart of SQL Server. The rollback will likely completely quickly when it restarts.

select * from information_schema.columns where table_name = 'Customers'

will give you the max length of the values, but the issue is that each row can have different data. What exactly are...

While I agree with the two responses above, why do you want to do this? I'd be curious to know what you're trying to achieve.

I tend to agree with Colin and Grant, but which is which in the batch %? You have Query One twice.

Server and PC have no meaning. They're both computers. The install differentiates between which version of the operating system you have. Some SQL Server versions will only install on a...

You can't do this directly. The FROM clause requires resolution at compile time, so it can't take a variable.

You can run something like this:

declare @cmd varchar(200)

,...

I think you're confused, or at least one of us is. Your code only contains a single value, but you're muddying the issues here.

You have 3 columns, a month, and...

I think Grant has given a good explanation of why #2 works. It's easier for the next person (developer or user) to understand as well. It makes client development slightly...

Interesting idea, Bryant, of a shifting or sliding warehouse.

From what I understand, which might be little, is that the warehouse should be the central source where you've consolidated the...

Typically you run defragment on only certain databases, like user databases, so you'd want to run a loop or use a list. That way you aren't messing with system databases.

I'd...

The PIX won't pass 1433 by default.

You'll usually find people split on this issue. I tend to agree with Jeff, but lots of people like having the images/BLOBs in SQL Server. Everything is then in once...

Ah, that stinks. Perhaps you can uninstall the SQL Native Client only? Not sure if that's separate with Express.

Which article?

I see at least one that's broken and I'll have someone look at it tomorrow.

Steve