Viewing 15 posts - 7,246 through 7,260 (of 9,725 total)
CirquedeSQLeil (10/12/2010)
Anybody know the link to sponsor SQLSat 49 as a Blogger?
Sorry, Jason. Call for sponsors is closed.
However, on future SQL Saturday events, just click the sponsors page and you...
October 13, 2010 at 5:28 am
Oh, and before I forget... Have the stats on the table been updated at all since inception?
And just how long have all your services been running?
I don't recommend restarting...
October 12, 2010 at 12:25 pm
Is the query forcing recompiles? Or forcing the use of a specific execution plan each time (maybe the wrong execution plan)?
This could still be a hardware or network issue. How...
October 12, 2010 at 12:23 pm
CirquedeSQLeil (10/12/2010)
Brandie Tarvin (10/12/2010)
CirquedeSQLeil (10/12/2010)
GilaMonster (10/12/2010)
October 12, 2010 at 12:09 pm
CirquedeSQLeil (10/12/2010)
GilaMonster (10/12/2010)
October 12, 2010 at 11:59 am
Kit G (10/12/2010)
RBF?
You missed his earlier reference to it: "Really Bl00dy Fast"
October 12, 2010 at 10:45 am
Another .sig-worthy quote.
Chris Morris-439714 (10/12/2010)
Never mind what the book says, what happens when you use it in anger against 75 million rows?
October 12, 2010 at 10:42 am
Brandie holds out virtual chocolate-covered biltong. "I hear it makes everything better."
October 12, 2010 at 10:38 am
Wait a sec... Read that page carefully.
Brad states:
Non-sargable search arguments in the WHERE clause, such as "IS NULL", "<>", "!=", "!>", "!<", "NOT", "NOT EXISTS", "NOT IN", "NOT LIKE", and...
October 12, 2010 at 9:03 am
Brad's article is written in 2007. So I'd think he'd have known about any SQL 2005 stuff.
He does add that covering indexes might explain a seek instead of a...
October 12, 2010 at 8:57 am
This might explain the difference between what you're saying and what you're seeing.
Brad
October 12, 2010 at 8:41 am
Steve Jones - SSC Editor (10/12/2010)
jcrawf02 (10/12/2010)
At the risk of encountering a porcine missile, have you ever heard of earplugs? 😀
I have found that single rooms are the best earplugs...
October 12, 2010 at 7:43 am
Congrats indeed! That's a wonderful milestone.
Only 82 more years to go. @=)
October 12, 2010 at 7:08 am
liewsb (10/11/2010)
I will carry out to shrink the log file this morning, here are the steps to carry out:
1. Change the Database recovery model to simple.
2. Execuate checkpoint command;
3....
October 12, 2010 at 5:49 am
Viewing 15 posts - 7,246 through 7,260 (of 9,725 total)