Viewing 15 posts - 7,186 through 7,200 (of 22,226 total)
Yeah, looks like you're running the release version. Just go here for details. There's also a link to the cumulative updates if you want to try them out.
"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
November 28, 2014 at 8:50 am
I don't know anyone having major issues with it. In fact, it seems to have fixed several problems people were having with 2012. I'd say it's been ready since April....
"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
November 28, 2014 at 8:48 am
You need to have indexes in place that will give the optimizer something to work with. As it is, the only option it has is to scan the tables.
"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
November 27, 2014 at 10:15 am
The differential backup will be used only if you specify it yourself for backups. It won't automatically run unless you set it up. The differential will only backup changes 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
November 27, 2014 at 10:11 am
Be sure you test the in-memory stuff on a non-production server. Once you create a database as in-memory, it has to stay that way forever. You don't want to do...
"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
November 27, 2014 at 10:08 am
Just disable the service. It's the kind of thing you may want to reenable in the future. Plus, it won't save memory, just storage.
"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
November 27, 2014 at 5:22 am
The GUID will fragment a lot more, that's for certain. I'd be inclined to use the three integers. They sound like the natural key anyway. And compound keys are 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
November 27, 2014 at 5:21 am
Well, first of all, I'd say that while an identity column does uniquely identify a row, you still should have the business key as a unique constraint on the table....
"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
November 26, 2014 at 10:37 am
Read the execution plan to understand how the query optimizer chose to interpret your query.
"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
November 26, 2014 at 10:32 am
Query Shepherd (11/26/2014)
Yes. Sorry, I ment page splits and the timestamp is not indexed and the table is not a heap...
Then it won't do anything any differently than any 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
November 26, 2014 at 10:30 am
So this has nothing to do with the query. It's the settings within SSRS that will allow you to have multiple columns.
Unfortunately, I don't know SSRS well enough 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
November 26, 2014 at 8:56 am
How do you mean paging? Data is stored on pages. Do you mean page splits? Timestamp isn't going to lead to page splits unless you've indexed it and then 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
November 26, 2014 at 8:54 am
For the general stages, go and look at the error log of a server right after startup. It'll show you a number of processes as each completes so that you...
"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
November 26, 2014 at 8:52 am
Yes, have one.
But seriously:
Start with backups. Identify the Recovery Point Objective (RPO). That's the amount of data that the business is willing to lose. They'll say zero, but that's an...
"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
November 26, 2014 at 7:31 am
If you know for certain that you're using no other mechanisms that need the SQL Writer service, it can be disabled. That's from the Books Online.
"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
November 26, 2014 at 3:21 am
Viewing 15 posts - 7,186 through 7,200 (of 22,226 total)