You REALLY CANNOT do clustering or "always on" based on some forum posts. PLEASE do yourself a favor and get some professional help!!

I concur Craig. Rigorous testing will ABSOLUTELY prove that the OR stuff is MUCH worse performing than a dynamic sql solution over the full variety of input values. ...

SalvageDog (4/18/2013)

---

The posts from peter-757102 and Sean Lange say it all. In a nutshell, this approach will almost always cause index/table scans. Not an issue for a small...

Please provide scripts for all tables/triggers involved. I am also a bit unclear - are you trying to actually SEND the email from a trigger or queue up a...

Given the really basic nature of the questions you are asking I feel you should REALLY get someone experienced and knowledgeable to help you determine what your HA/DR/read-only scale-out needs...

I have a Web2.0 client that is using it across the board (SQL Servers, middle tier servers and web servers). Nice stuff it seems, although I am just scratching...

Good points Jeff. I would definitely look at pre-populating the concatenated objects as temp tables. I had that in my notes I took while looking at alternatives for...

eseosaoregie (4/13/2013)

---

Hi guys,

thanks for the responses. I will try that alternative approach and let you know what my results are. CLR came up when I was discussing this with a...

The way you have done the SELECT (SELECT...), (SELECT..) ... FROM forces those massive nested loop joins on 900K rows and the logical IO from those is stunningly high.

First, make...

Mike Byrd (4/12/2013)

---

Am helping a client upgrade his servers (currently SS 2005 with Windows 2003 cluster). Talked to Dell sales rep this afternoon and he had not heard of...

ABSOLUTELY NOT!! It is purpose...

Thanks for the feedback on this. Did they post a public hotfix yet or is it still a private build? If the latter, please post the link here.

My addition to this thread is to inquire why you used full integers for your surrogate keys. Do you REALLY need 4.2BILLION possible values? I bet not. ...

Phil Parkin (4/7/2013)

---

Word's .docx files cannot run code, as far as...

winmansoft (4/6/2013)

---

I did run this query on server

SELECT session_id AS SessionID,

wait_duration_ms AS Wait_Time_In_Milliseconds,

resource_description AS Type_of_Allocation_Contention

FROM sys.dm_os_waiting_tasks

WHERE wait_type LIKE 'PAGELATCH_%'

AND (resource_description LIKE '2:%:1'

OR resource_description LIKE '2:%:2'

OR resource_description LIKE '2:%:3')

I got no...