Vedran Kesegic (12/29/2010)

---

I would do something like this:

declare @comment1 varchar(100), @comment2 varchar(100)

if exists(select 1 from inserted)

if exists(select 1 from deleted) select @comment1 = 'updated - new', @comment2 =...

One additional comment here: that is a VERY inefficient string splitting function. Search the SSC forums for a marvelous string splitting thread with incredible code samples and even...

Please go away Joe. Your rants and caustic attitude were never welcome on the forums and they are not welcome here either. And you obviously failed to see...

As usual I am with Jeff. We need table definitions and actual query plans. And those functions around columns in the WHERE clause simply HAVE to go. ...

There is one VERY important point you are missing about table partitioning: it is NOT primarily about performance, but rather for MAINTENANCE/MANAGEMENT. If it also happens to allow...

Steve Jones - SSC Editor (12/27/2010)

---

Be aware that when logs are restored, all connections to the database need to be broken, so you might want to adjust your restore schedule...

Seems the OP is focused for some reason on developing a faster primes finder that is NOT one of the known "... Sieves" methods. OP, may I ask WHY...

Don't feel bad - this is such a common misconception that I have it as a slide in a "Common TSQL Mistakes" presentation I have given at many SQL Saturday...

1) counting records can be VERY inefficient! all you care about in your logic really is if there is ANY row. think of if a batch updated 1M...

romulocpd (12/22/2010)

---

Hello.

Since last 6 months I've got several problems with performance in my SQL Server. My server is a Core i7 with 8 GB RAM and disk SATA 500...

Try OPTION (RECOMPILE) perhaps?

1) I would like to see the query plans for the 10 row IN delete and also one of the single documentid deletes.

2) are there any foreign keys present? ...

Good stuff as always Paul! Bummer is that the optimal index is essentially another copy of the table, which could be large given that it is a DW fact...

"... many factors may play a role ..."

That may qualify as the understatement of the year. You could have a 10MB database that could swamp a quad-quad server or...

Brian Carlson (12/22/2010)

---

Our SAN is a Dell Equilogic. We don't have a SAN administrator, but the SA that takes care of it says that it's an old SAN and nothing...