Viewing 15 posts - 5,041 through 5,055 (of 22,219 total)
Jeff Moden (3/3/2016)
Grant Fritchey (3/3/2016)
Jeff Moden (3/2/2016)
sickb00000y (3/2/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
March 3, 2016 at 7:23 am
You can't really figure out what the "last" user is without some method of indicating the order of the users. You have to have a date or a sequence 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
March 3, 2016 at 6:36 am
Jeff Moden (3/2/2016)
sickb00000y (3/2/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
March 3, 2016 at 6:31 am
Data is going to grow. You need to be prepared for that. If you want to monitor what's happening on a database, the best tool is extended events. However, 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
March 3, 2016 at 6:30 am
shamshad.ali (3/3/2016)
Can you please let me know how can I test it and share the stats? then we can decided if it is feasible to go ahead?Shamshad
Set up the situation....
"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
March 3, 2016 at 4:21 am
Jeff Moden (3/2/2016)
Considering the recent track record for SPs and CUs, you might consider waiting for at least a month before you deploy either.
Oh yeah, I wouldn't recommend deploying a...
"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
March 2, 2016 at 11:50 am
GilaMonster (3/2/2016)
Grant Fritchey (3/2/2016)
Anycompletedtransactions that are currently in the log are what get backed up.Uncommitted also get backed up.
I always forget that part of how it works....
"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
March 2, 2016 at 9:44 am
The number and frequency of SPs for every new version of SQL Server has been dropping over time. I wouldn't wait on SPs any more but would instead rely on...
"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
March 2, 2016 at 9:00 am
As others have said, the log backup is the easiest one to explain. Any completed transactions that are currently in the log are what get backed up. Those completed transactions...
"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
March 2, 2016 at 8:58 am
The big value will get added to the last page, and then everything else will be inserted behind it. Without testing I couldn't see just to what degree having one...
"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
March 2, 2016 at 6:39 am
Is it just the one row? Or are you regularly going to be inserting rows at the end of the chain along with rows at the start? If the former,...
"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
March 2, 2016 at 5:28 am
+1 For Denny Cherry. My other preferred resource on Virtualization is David Klee. You can pick up a lot of his stuff here[/url]. While this is a major undertaking, it's...
"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
March 2, 2016 at 3:24 am
Just remember that whatever memory you give to SQL Server, it's going to use all of it. It will load everything into cache and keep it there as long as...
"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
March 2, 2016 at 3:21 am
There are security patches that it's probably a good idea to get on the servers for all the reasons Gianluca lists. However, I've managed servers that stayed up regularly 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
March 1, 2016 at 3:58 pm
Has the database that is failing its backups passed DBCC?
"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
March 1, 2016 at 10:37 am
Viewing 15 posts - 5,041 through 5,055 (of 22,219 total)