Viewing 15 posts - 17,281 through 17,295 (of 39,834 total)
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
Brandie Tarvin (12/14/2010)
GilaMonster (12/14/2010)
Want some entertainment? I give you Gus's reply here http://www.sqlservercentral.com/Forums/FindPost1034345.aspx, nominated for comment on the week.It almost resulted in coffee over laptop.
I can see why. @=) I'll...
December 14, 2010 at 1:45 pm
The "low end" refers to the barrier to entry. It's easy(ier) to pick up development skills on these products, as opposed to C/C++
December 14, 2010 at 1:44 pm
Ron Porter (12/14/2010)
December 14, 2010 at 8:45 am
Heard Tim Legler on Mike and Mike say that most of the time this doesn't work. 97 Marlins, '09 Yankees were able to buy a championship. Most other times it...
December 14, 2010 at 8:34 am
For the most part I agree with GSquared. The performance issues can grow as you layer and nest things. UDFs and Views, while abstracting and reusing code, often mask issues....
December 14, 2010 at 8:33 am
What is the primary key on bookingactivity?
You can find duplicates by using a GROUP BY on the pK and a having count(*) > 1. What you first need to do...
December 13, 2010 at 2:54 pm
You cannot do this. You would either need to create the tables with the proper database name as I've done with dynamic SQL, or run a pre-written script. If the...
December 13, 2010 at 2:49 pm
For me, email is really the way I hear about things. I have a smartphone, iPad, and multiple machines. On one of those, I'll get a note. It could be...
December 13, 2010 at 10:11 am
Viewing 15 posts - 17,281 through 17,295 (of 39,834 total)