Viewing 15 posts - 19,831 through 19,845 (of 22,226 total)
Trader Sam (8/1/2008)[hr
Guilty by association!
There you go...
I was at a meeting of our town Board of Health this week (they're trying to pass regulations on Outdoor Wood Furnaces). One...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 8:28 am
Hrmmm...
Unless this is the only table in the database, I'd be really shocked to see a database lock based solely on inserts to a single table. I'm guessing there's a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 8:10 am
So I guess the guideline should be don't publish anything that can be linked to you that you wouldn't want published in the newspaper on the frontpage with your name...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 7:54 am
If TypeID and LangCode are the PK's that are meant to be used to link to the Object table (parent to child), then the Object table needs to also have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 7:22 am
Last comment. If you google my name the first result is The Jack Corbett Guide to Topless Clubs, which is NOT me. You get me as the 5th...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 7:15 am
Once you pass a certain number of rows, the engine has to lock the table to be effecient. There's no getting around that fact. So, instead, you have to look...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 5:48 am
It's just a chapter out of a larger book. The information is likely to be good, but it could be pretty light.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 5:42 am
I'm honestly mixed on this one. On the one hand, it's none of HR's or the company's business what I do in my off time. On the other hand, participating...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 5:37 am
Hey Jack,
You know, I do forget about that threading thing. Holdover from the days of 2000. I will say, it still doesn't work quite like having multiple connections from multiple...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 1, 2008 at 5:25 am
It's an ancient book. But hey, relational databases are relational databases. It's not til you get to all the funky queries and ETL and all that fun stuff that 2000/2005/2008...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 12:51 pm
Tuning Advisor stinks.
I've used Profiler to capture production and then play it back. It's actually pretty easy. The real key is that you absolutely have to recover to a precise...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 12:10 pm
Fleming & von Halle's "Handbook of Relational Database Design" is one of the best introductory books that I'm aware of.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 12:03 pm
As several people have already posted, that's just too vague a question to give you a good answer. If you're really stuck on how to get started, here's a basic...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 12:01 pm
You still can't buy it though. All they're offering is the "Readiness" disk and the July CTP.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 11:56 am
Today? I seriously doubt it, but this is the first time I heard this rumor.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 31, 2008 at 6:49 am
Viewing 15 posts - 19,831 through 19,845 (of 22,226 total)