Viewing 15 posts - 10,291 through 10,305 (of 22,219 total)
weberharter (11/26/2012)
GilaMonster (11/26/2012)
What I said was
"Typically a scan is a full scan (in the absence of TOP or other operators that give row goals)"
Hence, if you see a scan and...
"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, 2012 at 7:40 am
There are lots and lots of new things in SQL Server 2012. Here's a fairly complete listing. What specifically are you after?
"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, 2012 at 7:33 am
I have not seen a single point with a collection of all the updates. I have updated my book on execution plans. It includes a bunch of new stuff for...
"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, 2012 at 7:31 am
Instead of log shipping if you're looking at offsite, check out mirroring. It's much more resilient.
In general, you're doing things right. There's two issues when it comes to backups, RTO...
"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, 2012 at 6:44 am
But according to MS then you should restore the system databases at the time you restore your user DB.
I've never seen this one unless you're doing a system restore, 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 26, 2012 at 6:35 am
Since these are two different queries, you have to examine what they're doing in order to understand what the execution plan is representing to you. One is doing a MIN,...
"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, 2012 at 6:20 am
I'm with Jeff. Just because you have change control and auditing in place doesn't mean you can't do your job. In fact, you can do your job better under 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
November 26, 2012 at 6:11 am
If you just take away the timestamp, as Jeff says, you can overwrite the backup. I'd suggest though, you should be nervous about doing that. If your backup fails during...
"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, 2012 at 6:07 am
You could take a look at the sys.dm_exec_query_stats information. You can see the total_logical_reads for all executions of the query. Compare the output of the two, possibly using the number...
"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, 2012 at 6:04 am
Evil Kraig F (11/14/2012)
We're currently upgrading between versions on a piece of vendor software. Short version is they allow for end users 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 14, 2012 at 4:53 pm
L' Eomot Inversé (10/29/2012)
WayneS (10/29/2012)
"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
October 30, 2012 at 1:24 pm
SQLSACT (10/25/2012)
Grant Fritchey (10/23/2012)
"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
October 26, 2012 at 8:17 am
Yeah, I've seen that approach before too. It's supposed to make the code self-documenting or something. Any column can only ever be from one table. What a pain.
"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
October 25, 2012 at 12:33 pm
The basic design is quite simple. You have to create an interim table that has the primary key from patient and the primary key from pharmacy. That creates the many...
"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
October 25, 2012 at 8:39 am
If you're truncating the entire database, how about setting it to restricted user prior to running the process? If you need to you can even rollback outstanding connections immediately (with...
"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
October 25, 2012 at 8:25 am
Viewing 15 posts - 10,291 through 10,305 (of 22,219 total)