I took the mentored training at New Horizons and I liked that a lot. Had the video training in the classroom and got to go as fast or as...

Must be an addin my SSMS 2008/2012 let's me type ok.

Try a.APPLICATION_DT >= TO_DATE('20120801','YYYYMMDD')

There are situations...

Strictly performance wise with all things being equal (i.e. controller, cache, #disk etc) I agree RAID 0 would be fastest, but wouldn't put anything valuable on it.

What do you want the "Source" field to say when the 2 rows are combined? I'm assuming the TotalAmount is summed but we can't really sum the source field....

Try this article

http://www.sqlserverclub.com/articles/how-to-deal-with-negative-spids-in-sql-server.aspx

Jeff: I see what you mean by the 3 scans vs 2 scans. I ran the script on a VM server here at work, since that's where I am now,...

Thanks a bunch. Correlated sub queries. Forgot what it was called. Forgot what was said about it. Been forgetting a lot of things. Must be getting old. :doze:

The...

I've seen it in a help desk application. If you're looking for a help desk app and you hate this naming convention stay away from HDAuthority from Scriptlogic.

Worked for me when I did it at my previous work place. Get's a bit messy if you do it a lot.

are you using "S" or "s"

case matters...

sqlcmd -S server\instance

you're missing the scale (the number of digits after the decimal point)

Numeric(2,0)

I found this to be very helpful. Funny thing is I just watched it last night. 🙂

It's a readiness video for the MCM Prorgram. I'm hoping to get an...

This works for me. I've made a few assumptions as to the ID, value and name.

I've also modified the test data for assumption 1 and 2.

1. ID value is...