Viewing 15 posts - 511 through 525 (of 629 total)
Lynn Pettis (4/24/2012)
paul.knibbs (4/24/2012)
david.wright-948385 (4/24/2012)And what of the government: they would be legalising something they know to be harmful.
To be fair here, this is already the case for tobacco and...
April 24, 2012 at 5:53 pm
Freddie-304292 (4/24/2012)
TravisDBA (4/24/2012)
david.wright-948385 (4/24/2012)
jay-h (4/24/2012)Drugs are not harmless, but crimalization is even worse.
I'm sorry Jay that really doesn't make any sense at all.
It does if you are a user. I'm...
April 24, 2012 at 5:40 pm
Steve Jones - SSC Editor (4/24/2012)
jay-h (4/24/2012)
Steve Jones - SSC Editor (4/23/2012)
djackson 22568 (4/23/2012)
I'm not sure I want a law enforcement official suggesting that drugs are acceptable, or drinking...
April 24, 2012 at 5:18 pm
Freddie-304292 (4/24/2012)
Steve Jones - SSC Editor (4/23/2012)
I'm not sure I want a law enforcement official suggesting that drugs are acceptable,
I would, the drug laws are terrible, causing way more...
April 24, 2012 at 5:03 pm
OTOH, I can think of a situation where it could form a valuable part of the screening process. "Well, you're here for the DBA job, first thing, could you...
April 23, 2012 at 9:01 am
The issue with this is as well as asking for you to breech your terms and conditions and compromise your own confidentiality, they are also asking you to compromise the...
April 23, 2012 at 7:19 am
Sean Lange (4/17/2012)
andrew gothard (4/17/2012)
Sean Lange (4/16/2012)
hbtkp (4/16/2012)
but this is how i am getting my final data in report.
so based on how they calculate...
April 17, 2012 at 3:46 pm
Sean Lange (4/16/2012)
hbtkp (4/16/2012)
but this is how i am getting my final data in report.
so based on how they calculate , i need to...
April 17, 2012 at 3:27 pm
Possibly a question so obvious that it verges on the daft, but have you run a statistics update when you migrated?
January 31, 2012 at 3:00 pm
If they can't be bothered to read the articles - Kendra Little's got a webcast on this very issue on
November 10, 2011 at 7:49 am
Or there's also
http://www.sqlmag.com/article/sql-server/quaere-verum-clustered-index-scans-part-iii
or even
http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx
Unfortunately, many people think that NOLOCK means Magically Return My Data Faster With No Side Effects Whatever - and it can be rether hard to get them...
November 10, 2011 at 7:48 am
Why not test it on your DEV system?
You should be testing backup restores on a regular basis anyway. If you have to do a DR restore due to dataloss...
March 4, 2011 at 4:50 am
In the first query, the use of ISNULL on the columns you're applying the filters to is forcing a table/Clustered index scan as the engine cannot use any covering indexed...
February 3, 2011 at 5:17 am
It's not in 2005, but I *believe* this is available in 2008
HTH
Andrew
November 18, 2010 at 2:30 pm
Jeff Moden (11/14/2010)
sqldba_icon (11/13/2010)
sure. where can i find the details?Google? Books Online? I'm not trying to be a smart guy here... that's where I'd look.
Not trying to be...
November 15, 2010 at 3:20 pm
Viewing 15 posts - 511 through 525 (of 629 total)