Viewing 15 posts - 4,621 through 4,635 (of 22,219 total)
Phil Parkin (7/8/2016)
SQL!$@w$0ME (7/8/2016)
Does the clustered key column(s) has to be NOT NULL/UNIQUE as best practice?
Yes. Otherwise SQL Server has to create its own 'uniquifier', to make the rows unique....
"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
July 8, 2016 at 6:31 am
I'm in agreement with Kevin.
Since the clustered index defines data storage, I recommend that the cluster be the most commonly used path to the storage. If that's the primary key,...
"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
July 8, 2016 at 4:28 am
You'll be able to see the objects, but you won't be able to tell what they are or where they came from.
"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
July 7, 2016 at 7:45 am
So, my suggestion is, leave the compatibility at 120 and just add the traceflag to force it to use the older cardinality estimator.
"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
July 7, 2016 at 5:13 am
There are differences, and this could account for everything. The first plan I looked at, 1027.sqlplan, is using the 70 Cardinality Estimation Engine. That means that database is using 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
July 7, 2016 at 4:05 am
Jeff Moden (7/6/2016)
tezsb (7/6/2016)
"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
July 6, 2016 at 10:22 am
Generally, you'll have the same IP address for very long periods of time. However, I travel a lot and demo Azure at many different locations. It's quite easy to quickly...
"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
July 6, 2016 at 4:08 am
I absolutely would not seek licensing advice on the internet. Microsoft is going to decide if you're in compliance or not. I'd go there to ask.
"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
July 6, 2016 at 4:02 am
But you are looking for waits. You have a process that is timing out. That means it's running long. Why is it running long? Well, it's not getting the resources...
"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
July 6, 2016 at 3:58 am
ffarouqi (7/5/2016)
Grant Fritchey (7/5/2016)
If it's getting timed out, that means it's firing, so it's not an issue that it's an Agent job,...
"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
July 5, 2016 at 10:54 am
ChrisM@Work (7/5/2016)
"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
July 5, 2016 at 10:48 am
Not really. You can look at create & update dates for the objects (sys.sysobjects), but it won't tell you what the changes are. You can compare between what's currently in...
"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
July 5, 2016 at 9:13 am
What has changed? Data? Structure? Code? Settings?
Nothing just randomly changes how it works out of the blue. If a query starts behaving differently, it could be any of the things...
"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
July 5, 2016 at 8:40 am
I said all that, and I'm a little wrong. The servers are the same. My mistake.
"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
July 5, 2016 at 8:38 am
Define "access to production"
Access to the underlying OS? I worked for 10 years without having that and everything was just fine (one or two minor snags, but nothing worth writing...
"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
July 5, 2016 at 6:38 am
Viewing 15 posts - 4,621 through 4,635 (of 22,219 total)