I would set up an extended events session to capture the queries being executed on the server. I would also start monitoring the server using Performance Monitor.

You need to...

Cadavre (1/18/2012)

---

Wikipedia's black-out is javascript based. I didn't realise it was "blacked-out" until a colleague informed me - I block all web-based scripts from running on my machine so it...

Jan Van der Eecken (1/18/2012)

---

Jack Corbett (1/18/2012)

---

I assume I'm not the only one who sees no content (well really only the word "content") in the body of today's...

Nope, no query that I saw either.

You have to understand where the split occurs between what's useful to monitor and what's not. Memory & CPU monitoring is now different. You're not going to want to look...

You're looking at a 500+ rows in a multi-statement UDF and you've got index hints inside the queries? I think you're digging a very deep hole. Hints should be used...

Jeff Moden (1/17/2012)

---

Grant Fritchey (1/17/2012)

---

We do have ASK.SQLServerCentral.Com if you really prefer posting to a place with a reputation system.

The thing is, some questions lend themselves to that style of...

Good to see you got the answer. Thanks Gianluca

Simply joining the tables, yes, you're going to return two rows. So, what are the filter criteria that makes it so you'll only get one? Add that to a WHERE...

I strongly recommend you DO NOT join the two views together. Joining one view to another or nesting views within each other leads to incredibly complex execution plans which can...

L' Eomot Inversé (1/17/2012)

---

I believe (sadly) that this will have no effect at all...

We do have ASK.SQLServerCentral.Com if you really prefer posting to a place with a reputation system.

The thing is, some questions lend themselves to that style of web site. But many...

You can make it a little cleaner:

DECLARE @MyParam1 VARCHAR(50) = '42',

@MyParam2 INT = 42,

@MyParam3 TINYINT = 2 ;

A quick summary of the things you can do for database backup testing. The best thing you can do is to test the restore. There are some third party solutions...

The cached plan only saves you recompile time for performance. A multi-statement table valued function is only good for working with very small data sets. This is because, as Gail...