Sysmessage is the way of the warrior...

declare @err int

select 1/0 from syscolumns

select @err = @@error

select * from master..sysmessages where error = @err

There a lot of reasons to have multiple filegroups, but I will make it short and sweet.  If you have a lot of data in a single table, you can...

You can most likely make this more efficient, but here is a first draft.

Enjoy,

Charaka

select

Whenever I am performance testing query changes, I always use both FREEPROCCACHE and DROPCLEANBUFFERS (sp?) Otherwise, you end up getting data from memory, which will not reflect the true...