brian118 (12/29/2010)

---

PaulB-TheOneAndOnly (12/28/2010)

---

I'll take #2

Assuming SAN/Network are working properly chances are you are facing some hot spots. A single file Tempdb sounds like a possible cause but I'll suggest to...

I would imagine someone has blogged about perf hits for each type of encryption by now. Simple web search should get you some numbers. However, it should be...

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...