Viewing 15 posts - 6,541 through 6,555 (of 22,219 total)
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
Phil Parkin (3/24/2015)
Actual rows and Est rows are very different. Are your statistics up to date?
Yeah, estimated 1, actual 87000, that's a slight disparity. No wonder it assumed a scan...
"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 5:47 am
Please post at least the execution plan so we can see how the optimizer is resolving the query based on your structures.
"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:15 am
The easiest way is going to be to run the RESTORE using WITH MOVE. But, that means the file layout has to be the same, even if the locations are...
"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:14 am
It's stored as a clustered index, so there is data stored within the database.
"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 23, 2015 at 7:31 am
GilaMonster (3/18/2015)
Luis Cazares (3/17/2015)
Can someone help with a crystal ball or interrogation system for this thread?http://www.sqlservercentral.com/Forums/Topic1668185-391-1.aspx
Sorry, mine's broken, it's only showing clouds.
OMG! That explains why I've been doing all this...
"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 18, 2015 at 7:21 am
Like I said, you probably won't be able to shrink immediately. The unused log space and closed transactions are before the open transactions. Until that changes, you're going to need...
"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 18, 2015 at 7:19 am
I think the issue must lie somewhere besides the cardinality estimator. In fact, both plans have the exact same estimates. They even have the exact same costs. Something else is...
"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 18, 2015 at 7:18 am
Viewing 15 posts - 6,541 through 6,555 (of 22,219 total)