Viewing 15 posts - 9,691 through 9,705 (of 22,224 total)
My suggestion... don't do that. Unless you're building some sort of address reporting engine that counts the number of references to street vs. road in official address usages, you will...
"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, 2013 at 7:24 am
You can pretty quickly set up extended events to capture the query and it's performance and then recapture it after adding the index. You can also capture the execution plans...
"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, 2013 at 7:20 am
It doesn't look like you have cartesian joins. You have defined join criteria. A cartesian is when you don't have join criteria defined and every row is joined on every...
"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, 2013 at 7:16 am
You'll have to work with the vendor to either supply you with the information of how your system is configured, or get them to give you read privileges to 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
July 31, 2013 at 7:00 am
That will show you what is currently in the cache. It is an aggregation of executions for each of your statements in cache, the number of times called, average CPU,...
"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, 2013 at 6:58 am
If you don't have monitoring in place to track disk space and disk usage, there's no way to tell. Nothing within SQL Server will automatically remember that on Jan 1...
"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, 2013 at 6:53 am
SQLRNNR (7/30/2013)
Koen Verbeeck (7/30/2013)
SQLRNNR (7/29/2013)
L' Eomot Inversé (7/29/2013)
WayneS (7/29/2013)
Just curious - how many like that new tile look on the home page?FWIW: I prefer the older images over these tiles.
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
July 30, 2013 at 3:45 pm
Welcome!
Keep your hands and feet inside the vehicle at all times and enjoy the ride.
"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, 2013 at 8:19 am
Bhaskar.Shetty (7/30/2013)
I am facing a weird problem since couple of days, When we tried to execute the any SP (Randomly) sometimes throws the error "The definition 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 30, 2013 at 8:18 am
No, you'd need to script it. But, if you have a fairly consistent naming or storage mechanism you should be able to script the scripting, write dynamic T-SQL to build...
"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, 2013 at 8:14 am
I would not assume they're identical in all respects. You need to identify specifically why the query is running slowly. I'd start with sys.dm_exec_requests. That will show you if 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
July 30, 2013 at 8:05 am
A pretty common use of unique keys is when you have an artificial primary key for a table, the single most common example is the identity field, but you still...
"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, 2013 at 8:04 am
Spools are a way for the query engine to store data, either for reusing it, or for rollbacks (other situations too, imagine where it might need to keep stuff for...
"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, 2013 at 8:01 am
I'm cool with anyone handling backups. As long as they get done and (the kicker) as long as we can successfully restore them in a timely manner. If it takes...
"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, 2013 at 7:58 am
WayneS (7/29/2013)
Just curious - how many like that new tile look on the home page?FWIW: I prefer the older images over these tiles.
It's all http://www.youtube.com/watch?v=0pRUGsB1qGY all the time, everywhere.
"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 29, 2013 at 12:23 pm
Viewing 15 posts - 9,691 through 9,705 (of 22,224 total)