Viewing 15 posts - 6,901 through 6,915 (of 22,221 total)
Before I immediately did the restore, I'd check that object_id to see what the object is that is misallocated. If it's a nonclustered index, you can drop it and recreate...
"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 15, 2015 at 4:24 am
The best way to get this kind of thing done is not to put the database into single user mode. The best way is to put it into restricted user...
"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 15, 2015 at 4:21 am
T_Peters (1/14/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
January 15, 2015 at 4:20 am
I'm with Gail. You find out what the companies expectations are around Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO). RPO is the amount of information, measured in time,...
"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 15, 2015 at 4:06 am
Steve Jones - SSC Editor (1/14/2015)
Grant Fritchey (1/14/2015)
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... 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
January 14, 2015 at 8:39 pm
Good to hear it.
Personal opinion, avoid system generated names. They just make everything harder.
"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 14, 2015 at 8:38 pm
Back on topic for a moment.
Maybe I'm in a weird head-space at the moment, but it seems like the questions have gotten... not worse, but weirder. Sort of off 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 14, 2015 at 3:50 pm
Modify the syntax so that it includes the name you want:
ALTER TABLE [dbo].Mytable ADD CONSTRAINT xxx UNIQUE NONCLUSTERED
(
[ID] ASC
)
"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 14, 2015 at 3:49 pm
Not something I've tried, but you could look at Red Gate SQL Dependency Tracker[/url]. It does a pretty good job of finding everything that references a table (or other...
"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 14, 2015 at 3:41 pm
It aged out of cache is the first thing that comes to mind. Just because others were created earlier, they may also have been accessed more recently. Another thing 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
January 14, 2015 at 3:36 pm
I'm with Jeff here. I tried a couple of experiments to see if I could break this. Nothing obvious worked.
"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 14, 2015 at 3:27 pm
Sean Lange (1/14/2015)
Koen Verbeeck (1/14/2015)
Steve Jones - SSC Editor (1/14/2015)
Boy, it seems like my questions are getting worse lately. Taking a beating in the QoD.
The question of today wasn't...
"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 14, 2015 at 3:18 pm
Another approach would be to hard code your list into a temporary table in the query and then join to that. Not pretty, but it'll work. There just has 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
January 14, 2015 at 11:55 am
Exactly what I was thinking. Where do those other two values come from? They have to be stored somewhere and then you join to that.
"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 14, 2015 at 11:49 am
Instead of doing a UNION operation, what about just a JOIN operation. You have three columns that are going to give you a relationship between the two tables. You only...
"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 14, 2015 at 11:48 am
Viewing 15 posts - 6,901 through 6,915 (of 22,221 total)