Viewing 15 posts - 7,246 through 7,260 (of 9,720 total)
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
You're welcome. Let us know if you need anything else.
October 12, 2010 at 5:39 am
Paul White NZ (10/11/2010)
Jack Corbett (10/11/2010)
$3k is about right at this point. You can do it for less by finding a cheaper hotel and roommate.A cheaper room-mate? :blink:
Hey! I...
October 12, 2010 at 5:34 am
If you're going to use the backup on another server, rather than the server the backup was saved to, I recommend moving the backup file *before* converting it to a...
October 12, 2010 at 4:14 am
Then I suggest doing more of a normalized set up with all the "main" part numbers in one table and all the alternate part numbers in a reference table.
Just an...
October 8, 2010 at 12:49 pm
I accidently hit enter on this post.. wish I could have deleted it.
October 8, 2010 at 12:38 pm
Viewing 15 posts - 7,246 through 7,260 (of 9,720 total)