Viewing 15 posts - 6,541 through 6,555 (of 22,226 total)
EMarkM (3/25/2015)
Pretty much the first step in any installation document I write (if the organisation doesn't have one, or amend if they do) is to create a Windows...
"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 25, 2015 at 6:46 am
Since INTERSECT does distinct values, why would you also need the DISTINCT word in each of your queries?
But, what Gail said. No way to tell you what's going on without...
"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 25, 2015 at 6:34 am
You could shut down the service (although if you can do that, you ought to be able to connect to it) and the copy the database files to a safe...
"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 25, 2015 at 6:32 am
I guess I misunderstood the question. I'm with Gail.
"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 25, 2015 at 6:28 am
If you can't connect as a windows logon, it's gone. I sure hope this isn't your production server.
"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 25, 2015 at 4:29 am
Yeah, it can be. sp_updatestats is an OK way to update statistics on most systems for most statistics. But some systems and some statistics are going to need a 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
March 25, 2015 at 4:28 am
The indexes may be fragmented AND the stats are out of date. Rebuilding indexes takes care of both. But, the most likely issue is that the stats are out 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 24, 2015 at 7:55 pm
I don't use the GUI much myself, but I demo it regularly and I've had to use it for screen captures and other functions. I haven't had problems with 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
March 24, 2015 at 4:38 pm
Not sure. Maybe the index is corrupt. I've only hit that error on hints when I was attempting to force the optimizer to do something it just couldn't do.
By 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 24, 2015 at 3:56 pm
I suspect there was something up with that index, possibly it wasn't even there. You'd only get an error if a hint suggested something that simply couldn't be done, which...
"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 24, 2015 at 2:43 pm
CXPACKET is just an indication of parallel processing going on. As a wait, it's not indicative of anything other than that, you have parallel query processing. You need to look...
"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 24, 2015 at 2:42 pm
It's really going to come down to testing to see if making modifications to the key values hurts performance, and if so, how much. Just having an index on 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 24, 2015 at 2:20 pm
Everything Cadavre said.
Tuning queries requires understanding what the T-SQL statement you have is doing and understanding how the optimizer works with your T-SQL. The way to do that is 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
March 24, 2015 at 10:09 am
Jakub.Janda (3/24/2015)
"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 24, 2015 at 6:53 am
ChrisM@Work (3/24/2015)
Hey Grant, in the Plan1 execution plan there's a NLIJ with "Expr1004" in the Outer References list. Any idea what the "Expr1004" is for and where it was constructed?
I'm...
"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 24, 2015 at 6:48 am
Viewing 15 posts - 6,541 through 6,555 (of 22,226 total)