Viewing 15 posts - 8,281 through 8,295 (of 22,224 total)
sqlvogel (5/2/2014)
Bill Talada (4/30/2014)
The number one rule of a primary key is that it must be "meaningless" yet unique.
That's your number one rule but definitely not the number one rule....
"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
May 2, 2014 at 5:58 am
But you can check the compile time of the plan by looking at the SELECT operator properties (or the DELETE operator, etc.). 30 minute compiles are abnormal as hell, but...
"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
May 1, 2014 at 5:21 pm
OPTIMIZE FOR UNKOWN is a query hint and must be applied to each individual query. It has to be a part of the text, no options. There is no central...
"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
May 1, 2014 at 9:06 am
I have not tested it, but there's no reason why it won't work just fine. Each instance of SQL Server and each version gets it's own installation.
"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
May 1, 2014 at 9:03 am
hisakimatama (5/1/2014)
Anyone else from The Thread planning to attend this week's SQL Saturday...
"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
May 1, 2014 at 7:55 am
Erin Stellato is here? Where is she?
Ha! Thanks. It's not true, but it's nice to hear.
"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
May 1, 2014 at 7:33 am
Scroll down in the documentation here (down to Remarks). It shows all the causes for the clearing of the cache and procedure cache. I'll bet they're doing one (or more)...
"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
May 1, 2014 at 6:16 am
1) DBA work is usually, by definition, 24/7. It's just the nature of the beast. We're frequently on call to handle emergencies. That said, most of the time, it'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
May 1, 2014 at 4:59 am
One argument against error handling in T-SQL is that there is already error handling in the calling application. To which I'll respond that there are unique error events within SQL...
"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
May 1, 2014 at 4:54 am
I'm not sure Grant Fritchey knows the answer to this. Is it a home-grown shipping process? I don't think the normal one flushes the cache.
"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
May 1, 2014 at 4:51 am
Luis Cazares (4/30/2014)
pooyan_pdm (4/30/2014)
"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
April 30, 2014 at 4:36 pm
Tons of stuff has changed. First, did you change the compatibility level on your database to 120? If not, you're using the old statistics with the new optimizer in compatibility...
"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
April 30, 2014 at 12:36 pm
ErikMN (4/30/2014)
So to summarize:CONS:
- Slightly more complicated and slightly more costly to query
One table (denormalized):
PROS:
- Slightly faster queries
Careful. It's at least partly a myth that denormalized storage is faster. It...
"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
April 30, 2014 at 11:09 am
shafirmubarak (4/30/2014)
Yes, the unique enforcement would be absolute necessary.But i was not sure how surrogate key will be of use?
In some situations it will help performance to have 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
April 30, 2014 at 11:01 am
shafirmubarak (4/30/2014)
For example, user id is used as a linkage across multiple tables.
I am concerned about defining a key for the child tables as it requires 3- 9 columns...
"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
April 30, 2014 at 10:25 am
Viewing 15 posts - 8,281 through 8,295 (of 22,224 total)