Viewing 15 posts - 4,456 through 4,470 (of 22,224 total)
Nice work Luis.
"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
September 7, 2016 at 8:02 am
The question is, what are your primary keys and your foreign keys. From the layout it could be either order number or order number and location or just location. Your...
"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
September 7, 2016 at 2:59 am
Why?
If you just move the tables, but not the data, what's the point. You could simply script the database. If you move the tables, but not the foreign keys, constraints...
"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
September 7, 2016 at 2:41 am
They did say thanks. That's more than we get sometimes.
"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
September 6, 2016 at 4:11 am
If the function starts with the definition of a table like this:
...RETURNS @somename TABLE
(...
Then it's a multi-statement table valued function. You can read more about the three kinds of functions...
"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
September 6, 2016 at 4:10 am
If you used extended events, you don't have to track down columns. The event package will include everything. It does make things easier. However, on 2008, you'll have to consume...
"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
September 6, 2016 at 4:06 am
GilaMonster (8/31/2016)
"Becoming a successful SQL Developer"
Never done a professional development session before. Not sure how to...
"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 31, 2016 at 9:44 pm
Eirikur Eiriksson (8/31/2016)
Grant Fritchey (8/25/2016)
Eirikur Eiriksson (8/25/2016)
Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?😎
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
August 31, 2016 at 9:42 pm
Sergiy (8/31/2016)
Grant Fritchey (8/31/2016)
Sergiy (8/30/2016)
JALLYKAMOZE (8/29/2016)
What is the best and permanent way to take care of parameter sniffing?
A clustered or covering index having the column used for the range selection...
"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 31, 2016 at 9:35 pm
Sergiy (8/30/2016)
JALLYKAMOZE (8/29/2016)
What is the best and permanent way to take care of parameter sniffing?
A clustered or covering index having the column used for the range selection as a first...
"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 31, 2016 at 1:53 am
Take a look at the Microsoft documentation.
"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 31, 2016 at 1:30 am
Best thing to do here would be to set up an extended event session to capture the security changes.
"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 31, 2016 at 1:30 am
Take a look at the wait statistics. Understand what is causing the server to run slow, if it is. It could be fine, but you'll only know by monitoring.
I would...
"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 31, 2016 at 1:29 am
You have two different delete statements, each one using a different WHERE clause, but both on the same table. So, first up, what other statements are involved with the transaction?...
"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 30, 2016 at 10:30 am
If you're getting different execution plans, then it has to be differences between the servers and/or databases that is causing it. The trick is identifying the differences. Most 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
August 30, 2016 at 10:24 am
Viewing 15 posts - 4,456 through 4,470 (of 22,224 total)