Viewing 15 posts - 5,236 through 5,250 (of 22,224 total)
You're stuck.
Trace is probably the best answer, at least in 2008. If you moved to 2012 or greater I'd also suggest looking at moving to Extended Events. It doesn't make...
"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
January 13, 2016 at 4:12 pm
mvinokur (1/13/2016)
I hope someone has help me with this. I am also getting a warning column with no statistics.
This is on a column that is a primary key.
Auto Create...
"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
January 13, 2016 at 8:49 am
Except for upgrading (and I wouldn't suggest going to 2012, 2014 has been out for two years and is very stable), and what has been suggested, the only other solutions...
"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
January 13, 2016 at 6:17 am
Always start with the Microsoft documentation when you have fundamental questions about what something is or how it works. For example, here's the information on indexed views. Then you can...
"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
January 13, 2016 at 6:11 am
Eirikur Eiriksson (1/12/2016)
Grant Fritchey (1/12/2016)
What's the query hint doing?😎
WITH (READ
UNCOMMITTED)???
I know what it does. I just don't understand why it's included.
"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
January 13, 2016 at 5:25 am
What's the query hint doing?
"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
January 12, 2016 at 8:26 pm
The reason there are tools around this task is because there really isn't any simple, quick & easy way to get it done. Especially not one that supports all 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
January 12, 2016 at 2:40 pm
And Visual Studio, both versions mentioned, has been quite stable.
"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
January 12, 2016 at 11:09 am
Hugo Kornelis (1/11/2016)
Grant Fritchey (1/11/2016)
You can, if necessary, apply a clustered index to the table and then drop that index.
In most cases, the better idea is to stop halfway through...
"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
January 11, 2016 at 3:41 pm
Martin Sherwood-301653 (1/11/2016)
With the advent of (MPP) capability within Azure SQL DWH was curious to field 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
January 11, 2016 at 3:41 pm
ypeng5 (1/11/2016)
"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
January 11, 2016 at 1:26 pm
I'm having trust issues with Lenovo. Both because of the horror show of the W530 and the security issues they've been having recently.
Still, that's a nice looking piece 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
January 11, 2016 at 10:59 am
That's actually a pretty dense set of questions. Any advice I'm offering up here should be taken with a very large grain of salt.
1) Heck no. Take Azure and everything...
"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
January 11, 2016 at 10:53 am
kramaswamy (1/11/2016)
"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
January 11, 2016 at 10:40 am
Automation is your bestest buddy.
You're not going to test every backup every night. Start with the vital ones. Figure out how often you can test them, more is better. Automate...
"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
January 11, 2016 at 9:04 am
Viewing 15 posts - 5,236 through 5,250 (of 22,224 total)