r_noob (7/15/2013)

---

I've spent a fair bit of time searching, but can't seem to find a succinct answer...is there a more efficient/faster way of performing the following query? I simply...

vick.ram79 (7/15/2013)

---

Use local variables to hold the values of the passed parameters. And then use the local variables instead of the passed parameters. This has ALWAYS worked for us in...

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...