Agreed Perry.

Personally with that config I would go with 2-disk RAID1 for C...

Sean Lange (6/22/2012)

---

TheSQLGuru (6/22/2012)

---

Eugene Elutin (6/21/2012)

---

I cannot understand why would you need dynamic sql for statements there.

Why not to have the same stored procedures in every database and call them...

seems kinda unusual to me to have a large "fact table" used so heavily for "singleton lookups", but as others have suggested proper indexing is what is needed here. ...

Eugene Elutin (6/21/2012)

---

I cannot understand why would you need dynamic sql for statements there.

Why not to have the same stored procedures in every database and call them dynamic sql. For...

DLathrop (6/20/2012)

---

Unfortunately, triggers won't work in this case; SQL Server doesn't have a "commit trigger" that would wait until a COMMIT to check the table for valid structure. Consider the...

Seems many of the posters here are missing a key phrase in the OP: "constantly refreshed table". SELECT-only solutions are thus pointless from what I understand. There...

rarara (6/19/2012)

---

OK, specifically this stumps me:

If this is my table:

ID Date Description

--------------------------------

221 1/11/12 09:00 Note1

222 1/11/12 09:02 Note2

225 1/11/12 09:08 Note3

678 1/11/12 10:00 Note4

898 1/11/12 10:33 Note5

How do I cross-reference...

You bring up a good point Jeff: if you are profiling UDF-using queries, make sure SET STATISTICS IO is OFF as well as SHOW ACTUAL EXECUTION PLAN to avoid seeing...

I wasn't aware that this bug hits on a restart of a non-AlwaysOn sql server! I wonder what happens if the ~1000 bump up blows you past a datatype...

chris-320654 (6/19/2012)

---

I re-ran my tests with hyperthreading disabled and there was no benefit at all. If anything times were very slightly slower for the single threaded powershell test, and noticeably...

do you have always on in play here?

what is exact table definition?

are you doing any rollbacks?

Sachin Nandanwar (6/19/2012)

---

TheSQLGuru (6/19/2012)

We cannot tell you which of these is best for your environment. LOTS of things come into play such as memory usage, latching, locking, CPU use,...

The official guidance is to be found in the document here, Table 2. It is basically size-of-index-plus-a-bit operation for the sort, no matter if it is in the database...

GilaMonster (6/19/2012)

---

TheSQLGuru (6/19/2012)

---

Hey Gail - do you have a reference for that number you...

Indianrock (1/19/2010)

---

We have some tables with millions of records in them. What we seem to be finding is that, in general, sampled updates of statistics creates problems. ...