1) Your server would likely die a horrible death if you set up replication on 500 databases, unless they were mostly read-only.

2) Likewise for database mirroring (even asynchronous).

3) I built...

recommendations:

1) see here:

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) as someone else said, you will likely need to batch up the DELETE.

3) you...

Hey, NOT COOL!! We do PUBLIC performance...

GilaMonster (2/15/2013)

---

Fragmentation, probably not. Low page density (a side effect of fragmentation), hell yes. Having half of your expensive SSD going to waste because of low page density isn't the...

Paul White (2/14/2013)

---

The C# code could no doubt be improved - I'm not an expert in that language by any means, but it does bear a resemblance to the sort...

Normally I would say that this caused different query plans that made it more efficient, but that isn't the case here. So I will go with someone having rebuilt...

Mister Magoo, that is some very slick TSQL.

Paul White - yet again you have impressed!! Very few people out there appreciate how powerful SQLCLR can be (when...

execution plan differences

blocking

check wait stats during execution

check file IO stalls during execution

sp_whoisactive (awesome freebie from Adam Machanic of SQLBlog fame) can really help you here

Or get a professional to remote...

Colin, sorry I don't have time to dig into this more, but see if this sample code I have from one of my SQL Saturday sessions can point you in...

momba (2/5/2013)

---

...I need to study this row number() thing. Will let you know how it goes when I straigten it out. Thanks for being so patient with my...

This could be more efficient (esp if "pkstuff" tight and/or the table is indexed properly for the correlated SELECT):

select CONVERT (varchar(9),EMPLOYEE_ID) AS emp_id

, CONVERT(datetime,(CONVERT(varchar(8),ADMISSION_DTE))) AS Adm_date

, ADMISSION_CDE

, ADMIT_TYPE_CDE

, CONVERT(datetime,(CONVERT(varchar(8),DISC_DTE))) AS...

1) telling your prospective employer you have investigated features could be a nice way to get them to ASK you about them - and then you are in deep kimchi...

deep.tkt (1/24/2013)

---

We have had a MSSQL database for data warehouse of size 1.5TB and recently with the purging and arching we were able to cleanup some data and now we...

Ninja's_RGR'us (6/17/2011)

---

Dan.Humphries (6/17/2011)

---

You know I don't know that I really gave it much thought. My mind just said that made sense and I went with it. But now...

I think Grant's last item (readable secondary) is one of the MOST commonly used reasons why people are hungry for SQL 2012 and it's "advanced mirroring" capabilities. The other...