Dear Dave62, WayneS,

Thank you both for drawing attention to this option, and for describing how to use it.

Hencefort, I promise to use a horrible pink color for all production servers,...

In order to get round the divide by zero error, I generally do this:

PF1 AS QF1 / nullif((QF1 + QF2),0),

instead of

PF1 AS QF1 / (QF1 + QF2),

I.e. set the divisor...

My 2 cents:

For index rebuilds, I recommend Ola Hallengrens homepage[/url]

Best regards,

Henrik Staun Poulsen

http://www.stovi.com

Sushant,

I've seen the network error as well.

We are using a SAN, and that was causing problems.

Upgrading SAN drivers helped, and we now restore 1 TB databases onto a...

I'm glad it helped, even if this thread is getting a bit old 🙂

Srini,

Have you seen http://www.sqlservercentral.com/Forums/Topic442391-146-1.aspx

?

This will also work on foreign keys etc.

Best regards,

Henrik

Vrosenberg,

Thank you very much for those suggestions.

Best regards,

Henrik

thank you very much for this post.

Best regards,

Henrik Staun Poulsen

http://www.stovi.com

I'm looking for an explanation for some of the abreviations.

pk is Primary Key

ak is Unique Constraints ??

udx is Unique Index

idx is non unique index

"+" means that the field is an...

We also use snapshot isolation level locking. It works nicely, but...

There is always a but:

a) It will take up 14 bytes on each row on each table in the database.

b)...

Lawrence,

Itzik Ben-Gan has an article in the latest edition (June 2010) of SQL Server Maganzine that is about indexing for Row_number/Over/Partition by

So he thinks that “indexing guidelines are to have...

mark,

Is this not because you have a foreign key that you must disable first, before you can change the collation?

Then enable the FK afterwards, when the new collation is in...

Thank you very much for sharing this observation.

Best regards,

Henrik

Dear all,

According to j.summers in http://www.sqlservercentral.com/Forums/Topic618362-32-1.aspx#bm841385

Books OnLine for 2008:

Tables per SELECT statement : Limited only by available resources

More details on "Maximum Capacity Specifications for SQL Server"...

Hi Charles Pockert,

<< Search for

<< {()}

<< Replace with '\1',

with the later comment

<< Search for

<< ^(.+)$

<< Replace with '\0',

Thank you for...