Viewing 15 posts - 17,341 through 17,355 (of 39,903 total)
If your company has a copy of SQL Toolbelt from Red Gate, I'd run SQLDoc against the database and get a lot of information in a form that might be...
December 15, 2010 at 9:35 am
One thing I didn't mention, and didn't realize until late yesterday, was that Lee took a lot less to go to Philly. I am pleased to see athletes, LeBron James...
December 15, 2010 at 9:32 am
TravisDBA (12/15/2010)
I agree, but having the first doesn't mean doodly squat if the person does not have the skills to get the difficult job we do done, and the fact...
December 15, 2010 at 9:28 am
You can convert from strings to dates and vice versa (see Cast/Convert in BOL) with NULLs.
December 15, 2010 at 9:25 am
TravisDBA (12/15/2010)
December 15, 2010 at 8:41 am
OCTom (12/15/2010)
December 15, 2010 at 8:38 am
Craig Farrell (12/14/2010)
Steve Jones - SSC Editor (12/14/2010)
Is it now more, or less, frightening?
I'm now wishing I was underwater in the scuba gear... kilts skeer me! Won any blue...
December 14, 2010 at 4:05 pm
Is it now more, or less, frightening?
December 14, 2010 at 2:25 pm
You are welcome, and glad it's working.
You were on a good track, and using temp tables to work with a subset of data for troubleshooting is something you can use...
December 14, 2010 at 2:04 pm
What do you mean by date conversions? NULL doesn't convert to anything but NULL.
NULL might be your best bet. You can always do MINDATE() ... WHERE mydate > '1/2/1900'
December 14, 2010 at 2:03 pm
grahamc (12/14/2010)
In this case it might not be such a big deal, but surely a counter like Page Life Expectancy is a better way of monitoring Memory pressure??
This is typically...
December 14, 2010 at 2:01 pm
Typically the "pull" is through a query. As far as how you'll get the data to people, you'll have to make some decisions.
If you are just pulling this from...
December 14, 2010 at 1:59 pm
rabartels (12/14/2010)
perhaps first look if your I/O is fineBenchmarking SQL Server IO with SQLIO
Good idea, though we're already in production. Hard to stop things and bang on the disks with...
December 14, 2010 at 1:50 pm
The Phillies certainly are the favorites on paper, but we don't play on paper. Anyone think the Giants were going to win before Oct last year?
Phillies have had injuries in...
December 14, 2010 at 1:48 pm
Craig Farrell (12/14/2010)
GilaMonster (12/14/2010)
Brandie Tarvin (12/14/2010)
(Where's my halo? Self-righteous doesn't work without my halo, darnit!)
How long did it take you to forge your own halo, in between the lightning strikes,...
December 14, 2010 at 1:46 pm
Viewing 15 posts - 17,341 through 17,355 (of 39,903 total)