I think the author forgot a much better, more targeted option: RECOMPILE on the statement(s) INSIDE the sproc that are being screwed by parameter sniffing/plan caching. That is...

How about something like this? You can do a table of numbers to generate a set of them with the required distribution.

DECLARE @i float = RAND(CHECKSUM(NEWID()))

SELECT CASE WHEN @i...

I am wondering why you are using the older 1204 for deadlock information instead of (usually more useful) 1222.

Protest all you want. But do note that I was NOT unequivocal in my statements and did allow for edge-case usage. 🙂

Try a profiler run to capture poorly performing statements. Also use PerfMon and Task Manager to capture performance metrics. Your indications suggest CPU issues. Find bad query(s)...

To be direct, I can't stand the new format!! Way too much wasted space. If this was done for "mobile-friendly" formatting, give users the ability to specify what...

Not sure, but I think 2005 SP2 might have 2000 SP3 beat for the "WOW, how badly can you FUBAR a patch?!?" award. :w00t:

Lowell (7/2/2013)

---

no, but the features differences all really have to do with a lot of advanced things, that would never come up in basic development; they come up more...

DannyCool (7/2/2013)

---

Hi there

i am trying to automate sql 2012 installation and i dont want to install sql2012 and sp1 separately. I want it in 1 install file.

I am trying to...

pjrpjr7 (6/26/2013)

---

CREATE TABLE [dbo].[SampleExcel2](

[CustID] tinyint NULL,

[TxnID] tinyint not NULL,

[TxnTime] datetime NULL,

[Amount] int NULL

) ON [PRIMARY]

INSERT [dbo].[SampleExcel2] ([CustID], [TxnID], [TxnTime], [Amount]) VALUES (1, 1, '6/1/13 12:30 AM', 900)

INSERT [dbo].[SampleExcel2] ([CustID], [TxnID],...

pjrpjr7 (6/26/2013)

---

Hi,

I have a table wherein I have customerID, transactionid, transactiontime, amount. My requirement is that I need to fetch only those customers who had 3 or more transactions within...

I have a client that has several thousand SQL Express instances at their clients, hosting tens of thousands of databases. Works fine, lasts a long time! 🙂

Sounds like your...

If nothing else make sure you collect Differential FileIO Stalls and Differential WaitStats during periods of slow (and regular?) performance so you can say definitively "look, you morons, it is...

ALZDBA (6/25/2013)

---

6 spindles:

4x136GB -> 2 RAID1 volumes -> C-drive and D-drive

2x300GB -> 1 RAID1 volume -> E-drive

I hope they upgraded all hardware drivers before they made it available because that...

mayurkb (6/25/2013)

---

TheSQLGuru (6/25/2013)

---

I would have nonclustered indexes on the requisite fields required to find the aged records (some date field on all parent tables I would presume). Child tables...