Sigh, why did I get involved in this case. Now I'm writing about it ... Well, at least it is a good recap of knowledge for myself, and hopefully someone...

It does the same, but personally I prefer:

select top (0) * into NewTbl from existingTbl

Even the execution...

In my humble opinion, the problems with the third party tools is that the users often distance themselves from the knowledge needed to successfully administer the servers. Of course, if...

For this kind of analysis, you either have to look closely on the execution plan, or have a relevant amount of test data. If you look at the execution plan,...

No, you can't do that. What you can do however, is using dynamic SQL. Some DBAs are very much against dynamic SQL, others use it all the time. What I...

You're a bit wrong here salum, the following code works just fine, and as expected:

create schema test1;

go

create procedure test1.test as

begin

print 'Schema test1';

end;

go

create procedure dbo.test as

begin

print...

Using PIVOT and UNPIVOT

In theory there is not difference between theory and practice, in practice there is. No offence intended, but Celco presents nice and valid theory, in practice it's not always the...

Just a little additional word. I do from time to time see configurations where Windows Integrated security is being used, but the applications are using connection pooling and access the...

Oh, I just love that MAXDOP. I have a customer, with a hosting partner who insists on disabling parallelism on the servers, only to avoid CXPACKET wait. That queries takes...

If so, it would be a good starting point for you to present a code sample, and tell us what you don't understand.

Ooh, I have some partial code on this somewhere. What you need is in sys.indexes, sys.index_columns, sys.columns, sys.objects, sys.data_spaces and sys.partition*. How easy it seems, there are a LOT of...

I think this will work for SQL Server 2005 as well, but I am not 100% sure: How to: Install SQL Server 2008 SP1 from the Command Prompt.

Grant permissions to run an SQL server job.

Unfortunately, I don't think this approach will do when it comes to view job history, for that I think you have to stick...

Thanks for the tip Gail, adding it to my checklist 🙂