Viewing 15 posts - 5,656 through 5,670 (of 22,219 total)
I don't know why that property is sometimes missing from a plan. I'll see if I can find out.
How are you capturing this query? Through SSMS? Querying the cache? Capturing...
"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 26, 2015 at 7:25 am
Another vote for No.
It's a fight you're likely to lose unless you can provide alternatives. I'd suggest looking at log shipping to another server. If you can, get upgraded 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 26, 2015 at 3:51 am
Can you post one or two samples of the plans that don't have that property?
"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 26, 2015 at 3:46 am
I don't see any indications in the documentation that the ALTER DATABASE command would reset sequences. What process or syntax did you use to rename 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
August 26, 2015 at 3:45 am
sgmunson (8/25/2015)
Jeff Moden (8/25/2015)
sgmunson (8/25/2015)
Rod at work (8/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
August 25, 2015 at 7:52 pm
If it ignored the index, it's because it wasn't satisfying the queries. Columnstore indexes work best with aggregate style queries. They don't work at all well with point lookup or...
"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 25, 2015 at 3:36 pm
Part of the DBCC process creates a snapshot of the database. That snapshot was marked corrupted due to an I/O issue (undetermined from here). So your main database is fine.
However,...
"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 25, 2015 at 4:53 am
I'm with Sean. It sure sounds like normalization might be an issue. I'd focus there as well.
In terms of impact of adding a column, it depends. If you're talking about...
"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 25, 2015 at 4:50 am
doug 88182 (8/24/2015)
I have 40 servers.
Each server has a [dbadb] database.
Each database has a view named v_DatabaseFiles that shows information on the database files...
"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 24, 2015 at 3:36 pm
Jeff Moden (8/24/2015)
Grant Fritchey (8/24/2015)
Threadizens, please don't skip posting your top scripts. I need help on this article.
I thought you just wanted commands. As for "top scripts", I'm not...
"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 24, 2015 at 11:04 am
Steve Jones - SSC Editor (8/24/2015)
Wow some great lists. This might be a good thread to compile into an article.
Ha! That's the plan, but I'm wondering now if I should...
"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 24, 2015 at 10:58 am
I don't know. That's weird. But the site seems a little off today. A disturbance in the force perhaps.
"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 24, 2015 at 8:26 am
In over 20 years working with SQL Server, I've only ever seen the OS files defragmented in handful of cases. Most of the time if you build your database files...
"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 24, 2015 at 6:25 am
Threadizens, please don't skip posting your top scripts. I need help on this article.
"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 24, 2015 at 4:50 am
Without seeing the query, I can't tell what you're running. As Jeff said, if you're using the Maintenance Plan wizard to do this, it's running for all indexes.
For index maintenance,...
"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 24, 2015 at 4:35 am
Viewing 15 posts - 5,656 through 5,670 (of 22,219 total)