Viewing 15 posts - 15,766 through 15,780 (of 22,226 total)
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
WayneS (3/5/2010)
Grant Fritchey (3/5/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 5, 2010 at 1:38 pm
Jack Corbett (3/5/2010)
GilaMonster (3/5/2010)
Jack Corbett (3/5/2010)
If you are already known as a top-level person (Grant, Gail, etc..), then the cert is unnecessary.
When you're bidding for work (consulting), a collection 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
March 5, 2010 at 1:36 pm
Roy Ernest (3/5/2010)
Yes true regarding the knowledge base. I know nothing about BI, I have done only...
"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 5, 2010 at 8:22 am
I don't know who this top-level Grant guy you're talking about is.
I recently interviewed at a company where it was made pretty clear, just how little I know. You're only...
"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 5, 2010 at 8:03 am
If you're trying to simply identify the objects, sure you can use straight TSQL, but if you're trying to generate scripts, you really need to look at some method 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
March 5, 2010 at 6:36 am
Jack Corbett (3/5/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 5, 2010 at 6:27 am
I think this really comes to down to personal preference and/or experience. Here's my 1.5 cents:
I am not certified. Based on my current job, salary, experience level, and experience interviewing...
"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 3, 2010 at 11:19 am
It doesn't sound too mysterious. You say you get bursts of inserts over time, and these bursts can cause page splits or whatever within the index and while things are...
"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 3, 2010 at 9:38 am
Viewing 15 posts - 15,766 through 15,780 (of 22,226 total)