Viewing 15 posts - 15,751 through 15,765 (of 22,219 total)
Maybe it's getting updated for 2008. 2005 is getting just a tad long in the tooth at this point. I might suggest an alternative
I
I
I
I
\/
"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
March 11, 2010 at 6:37 am
200 million queries... that's a poster child for the horrors of ORM. Yikes. Best of luck with your issues.
"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
March 11, 2010 at 5:31 am
Paul White (3/10/2010)
GilaMonster (3/10/2010)
Grant Fritchey (3/8/2010)
An unique index and a unique constraint are the same thing (in fact, creating a unique constraint creates a unique index).
Except for 2 points
Unique index...
"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
March 10, 2010 at 6:01 am
Assuming the complexity of the queries is as you've outlined, both will probably work about the same way.
However, are single row inserts the best way to move millions of rows?...
"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
March 9, 2010 at 8:21 am
Lynn Pettis (3/8/2010)
WAY TO GO...
"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
March 8, 2010 at 8:51 pm
Roy Ernest (3/8/2010)
Of Topic...On an average how many people attend SQLSaturdays?
#34 in Boston went well over 300 (approximately 325) and it was my understanding that we were one of the...
"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
March 8, 2010 at 12:00 pm
It does cause some overhead, which is why, most of the time, you try to schedule database backups for slower operation times. However, it does not lead to blocking as...
"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
March 8, 2010 at 11:05 am
I thought MCP was Main Coolant Pump.
"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
March 8, 2010 at 9:24 am
Jeff Moden (3/8/2010)
Heh... my favorite response is, "Database? What database?" 😛
Every time I get these "Hey, let's build a database that doesn't have referential integrity/indexes/normalization/mirrors our objects/only stores unstructured...
"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
March 8, 2010 at 8:03 am
Excellent list and great set of suggestions. I'd suggest an exchange, already covered by others. Yanke the DTA and put PowerShell up in its place.
The DTA is just way...
"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
March 8, 2010 at 7:36 am
GilaMonster (3/8/2010)
"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
March 8, 2010 at 7:28 am
I think I understand the question.
2. Yes, it's certainly possible to add a unique constraint to table 2. In fact, you should. Too many people rely on the ID column...
"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
March 8, 2010 at 7:00 am
An 8 table join is not going to kill performance assuming the query is well written and the indexes are properly structured. A 40 table join won't kill performance (trust...
"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
March 8, 2010 at 6:52 am
Although, below, I think 8 pages (or is it 3, I've forgotten), SQL Server can't defrag the index at all, let alone will defragging an index that size give you...
"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
March 8, 2010 at 6:19 am
I've tried finding that kind of work in the past and never was able to either. The few hits I have received came through networking with fellow DBA's. They're the...
"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
March 8, 2010 at 6:14 am
Viewing 15 posts - 15,751 through 15,765 (of 22,219 total)