Viewing 15 posts - 17,356 through 17,370 (of 22,226 total)
If it expires, it usually means it can get overwritten or removed by the backup process, so you might want to watch for that. The real question is, how often...
"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
May 28, 2009 at 10:27 am
Lynn Pettis (5/28/2009)
Anyone catch this little gem?
I didn't even read what he said...
You don't suppose it's our favorite emmveepee that was so desperate to convince us all that we...
"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
May 28, 2009 at 10:24 am
Pradyothana Shastry (5/27/2009)
"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
May 28, 2009 at 10:21 am
GilaMonster (5/28/2009)
Roy Ernest (5/28/2009)
BTW, the echo guy is strange. He has been doing this quite often. Or give an answer without reading the question. :hehe:
Or posting bad advice (truncate tran...
"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
May 28, 2009 at 8:21 am
stonecold560 (5/28/2009)
Abhay,So that means when I first did the backup manually it picked up all the trasacations?
Each transaction log backup gets all the logged operations 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
May 28, 2009 at 6:53 am
Different companies are going to define that in different ways. Where I work a senior database developer will be able to design databases based on requirements, develop t-sql, troubleshoot performance,...
"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
May 28, 2009 at 6:50 am
Is the automated job running more often than you used to run the backups manually? If so, that would explain the difference.
"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
May 28, 2009 at 6:41 am
Logs and log backups don't have anything to do with the data file groups. If the third group is read only, then no log activity will be recorded against 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
May 28, 2009 at 6:40 am
There is no SELECT trigger. The best way is what you already have planned, collect the data through a server-side trace (which you can use Profiler to set up). Depending...
"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
May 28, 2009 at 6:37 am
Attention to detail.
Which server are you connected to? You might want to know before you run that drop table command.
Does this UPDATE query have a WHERE clause? Be sure before...
"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
May 28, 2009 at 6:35 am
Pradyothana Shastry (5/27/2009)
Statistics will be updated automatically after index rebuild
Right, all this echoing is starting to get creepy. You can stop now.
"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
May 27, 2009 at 5:32 pm
And because I can...
10 bottles of beer on the wall, 10 bottles of beer...
"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
May 27, 2009 at 5:30 pm
GilaMonster (5/27/2009)
Is there an echo in here ...echo in here... ...echo in here... ?http://www.sqlservercentral.com/Forums/FindPost724259.aspx
http://www.sqlservercentral.com/Forums/FindPost723631.aspx
Well now that's just strange. What the heck?
"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
May 27, 2009 at 5:26 pm
You may have to edit the SSIS package the import/export wizard creates.
"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
May 27, 2009 at 1:28 pm
Don't migrate the timestamp column. It will generate on it's own.
"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
May 27, 2009 at 12:57 pm
Viewing 15 posts - 17,356 through 17,370 (of 22,226 total)