SELECT CASE WHEN number%3 = 0 THEN 0 ELSE number END AS a

INTO #tmp

FROM kgbtools.dbo.BigNumbers

(100000 row(s) affected)

CREATE CLUSTERED INDEX idx ON #tmp (a)

DBCC freeproccache

go

SELECT *

FROM #tmp...

Jeff Moden (3/6/2013)

---

TheSQLGuru (3/6/2013)

---

The UDFs are a problem if for no other reason than the optimizer cannot know what is coming out of them, thus it will get inaccurate estimates...

So, you update the DOB with the sproc UPDATE statement, and then the trigger updates the DOB too (after removing the time)? Uh, maybe just strip off the time...

My vote is for the huge covering index being the culprit here...

shaycullen (3/6/2013)

---

"Like I said, once you are connected to SQL Server you are on that box, and it doesn't use/know about a .NET connection string to hop over to another...

Jeff Moden (3/6/2013)

---

kk1173 (3/5/2013)

---

to give you an idea of type of queries that are being run

SELECT minormkt

,Sum(admits) as 'Total Admits' ,Sum([days]) as 'Total Days' , sum(OppAdm) as...

1) http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx. Note there are 2 additional parts to this blog series.

2) With such a complex construct (2000 line sproc, trigger(s) in play, etc) you may be...

shaycullen (3/6/2013)

---

I think I explained myself incorrectly. I want to do this in a SQL Query.

I have a 3rd party application that allows me to run SQL against the...

"always on" and readable secondaries is just improved database mirroring.

shaycullen (3/6/2013)

---

Hi,

I have setup a clustered environment for my SQL Server database and configured Always On replication with no issues, everything seems to be working perfectly, however I have one...

Database mirroring tracks (and exposes via the database mirroring monitor gui) a variety of metrics about delay, ship rate, restore rate, how far behind, etc. See books online topic...

Lowell (3/5/2013)

---

That trigger emulates what a column with an identity does... so you can simply define the column as having an identity and skip the trigger completely.

Create table tbname (colname...

with that few spindles I would simply do a 12-disk RAID10 set and drop everything on it. Spindle-aggregation is usually a good thing. I have had good success...

surprisingly linear!

Jeff Moden (3/2/2013)

---

Yeah, you're right, Kevin. I should'a'node. 🙂 The "symptoms" told me I should ask anyway. Didn't know the "problem" would be such an incredible machine....