Viewing 15 posts - 19,831 through 19,845 (of 22,219 total)
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
IDENTITY columns do not duplicate, even without a constraint, when operating normally. You can force duplicates in by using IDENTITY_INSERT or by doing a RESEED, but the normal behavior is...
"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:18 am
When you say duplicated, do you mean in the data? I've never seen that in normal functions, it must be a bug or you're not using the IDENTITY setting and...
"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 5:37 am
The newest version of Red Gate's SQL Prompt will do that for you and lots more. Also Red Gate's SQL Refactor has a way to clean up the layout 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 5:32 am
And just like your last post, take a look at the execution plans that will tell you a lot of what you need to know for making these sorts 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 5:30 am
Check the execution plan. WHERE clause order can affect some execution plans, but won't affect all. On a very simply query like this, it's unlikely to make a difference.
"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 5:28 am
dale_keller (7/30/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 30, 2008 at 12:08 pm
gcopeland (7/30/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 30, 2008 at 12:00 pm
Viewing 15 posts - 19,831 through 19,845 (of 22,219 total)