Viewing 15 posts - 6,901 through 6,915 (of 22,219 total)
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
Those are based on the queries run from the query window. You can change connections and it will still maintain the count of executions from that query window.
It's not 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 10:13 am
In addition to what Perry says, I also understand that there are a number of internals improvements leading to a higher degree of stability and better performance overall.
"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 6:47 am
Viewing 15 posts - 6,901 through 6,915 (of 22,219 total)