Hi There

Cool article but here is what I have found with newid().

Doing a order by newid() is a performance killer. Let me explain. We have a table of 36 million...

HI There

Have you found a way to fix this yet? I am trying the same thing and running into a wall.Seems like you cannot a linkedserver via a trigger.

ANyone had...

I had a similair problem a while ago. Some background first. We had a stored proc that joined two tables. One table on the local server another table on the...

You forgot to mention the jacuzzi and sauna.... :hehe:

Hi There

Did you backup and restore the log files as well? Normally a DB will go suspect when the log file or data file is corrupt. From the description of...

Hi

From what I understand you wish to create a table for per month of a year. In otherwords you would like to partition the data into smaller tables to...