Viewing 15 posts - 271 through 285 (of 687 total)
Markus (3/19/2012)
Andy P. seems to have baseball in his blood doesn't he... he can be tempted with a contract for more time pitching.
I could possibly be tempted with a 2.5...
March 19, 2012 at 11:05 am
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...
March 19, 2012 at 8:57 am
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...
March 16, 2012 at 7:06 am
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.
March 14, 2012 at 11:56 am
halifaxdal (3/14/2012)
Lynn Pettis (3/14/2012)
Has to be both of us. I count 19 columns in the defintion of the cursor and 19 variables.One question, why are you using a cursor?
I...
March 14, 2012 at 11:19 am
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...
March 14, 2012 at 10:17 am
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...
March 14, 2012 at 9:37 am
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...
March 14, 2012 at 8:18 am
Just search google for "RAID levels", "RAID Configurations", or "RAID Basics". There's tons of information out there on it.
March 14, 2012 at 8:11 am
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....
March 14, 2012 at 7:58 am
Do you mean an X axis that goes into the negative?
March 14, 2012 at 6:59 am
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...
March 14, 2012 at 6:57 am
Here is a site that defines all the parameters for that extended procedure.
exec xp_readerrorlog 1,2,null,null
March 14, 2012 at 6:27 am
March 13, 2012 at 7:02 am
select convert(varchar(6),current_timestamp,112)
March 13, 2012 at 6:55 am
Viewing 15 posts - 271 through 285 (of 687 total)