I could possibly be tempted with a 2.5...

So the MLB channel had a weekend marathon of spring training awesomeness! I was able to watch a few games which was great, one of which was the New York/Washington...

ISNULL() is a function that returns a second value if the first is null. In your situation, if the last_updated_on field is null the created_on field will be used.

YEAR( ISNULL(<if...

The string is too long to be converted to a datetime data type.

try SELECT convert(datetime,'1/6/2012 12:36:35.631 PM')

Or use datetime2 as coldcoffee suggested in his example.

halifaxdal (3/14/2012)

I...

Good call, no 🙁

Here I thought I was being nifty in suggesting it. Upgrade!

I saw you posted in 2005 and even made changes to my script to work in 2005...

I made up some DDL for this. If only 5% of answers have "other" as an answer, then what do you think about adding a sparse comment field to your...

Yeah, Brent Ozar[/url] has a decent article on SAN basics and the different types of SAN storage. Check his 2nd SQL University link for SQL Storage related best practices on...

Just search google for "RAID levels", "RAID Configurations", or "RAID Basics". There's tons of information out there on it.

It depends 🙂

It depends on the type of company hiring you. If they have their own storage administrators then your depth of SAN knowledge doesn't need to be that great....

Do you mean an X axis that goes into the negative?

So the other day I was surfin' the intarwebs and I had a baseball game on in the background, I don't even remember who was playing. I realized how much...

Here is a site that defines all the parameters for that extended procedure.

exec xp_readerrorlog 1,2,null,null

Glenn Berry[/url] has a great script for performance numbers. Check it out!

select convert(varchar(6),current_timestamp,112)