There are times that I give really short answers that basically amount to "here's the keyword you need to search online/in BOL". Even in those cases, I make it...

I just tried this and got the right results:

create table #T (

ID int identity primary key,

Dim int,

Val int);

insert into #T (Dim, Val)

select 1, 1 union all

select 1, 2 union all

select...

There isn't a single statement for it, but you could write a script that would do it all at once.

Would look something like this:

select

'alter table ' +

(select name

from...

The more you know, the harder it is to judge nuanced issues, but the more likely you are to judge correctly when you do get around to it.

Some things are...

There's a human tendency to see patterns in chaos. Sometimes we see real patterns, other times we just dub stuff in because we're wired to do so. Can't...

"Trust but verify"

If your database is in Full recovery mode, you can get who/what/when on updates and such by using a log parser. ApexSQL has a good one, and I think...

These two articles and their discussions cover the subject pretty thoroughly. If you haven't already, you might take a look at them:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

Deletes don't cause page splits. Inserts and updates that are out-of-clustered-sequence do.

If page splits and fragmentation are the problem you're working on, focus on inserts and updates that affect...

Jack Corbett (9/18/2009)

---

You could also take the OR's and do a union instead.

Select

From

table

Where

column between a and b AND

...

I may be misreading this, but if I understand you correctly, that's not precisely how fill factor works.

Data is stored in 8k pages. If you have small rows, like...

Insofar as multiple instances running on the same binaries, I have to ask "why bother?"

The only reason I can think of to have multiple instances of SQL Server on the...

It's a baseball reference.

Check this http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx for further discussion on the levels.

The linked article seemed more than a little self-serving and biased to me.

I've worked with a lot of IT people, and a lot of non-IT people, and the thing I...

Silverfox (9/23/2009)

---

Has...