Viewing 15 posts - 9,481 through 9,495 (of 22,219 total)
Brandie Tarvin (10/3/2013)
Why, oh, why do people keep perpetuating (or creating) myths about backups? And in an article about interview questions no less.
I wouldn't hire anyone who answered 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
October 3, 2013 at 5:45 am
Yeah, we might want to have a "Come to Odin" talk with Jeremy. This one for example:
...in order to keep the transaction log small...
No, no, no, no, f' no, no,...
"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 3, 2013 at 5:41 am
If the tempdb is actively in use, you may not be able to shrink it until the objects stored there are cleared 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
October 3, 2013 at 2:48 am
You need to better define what you mean. You can create a backup as was described above. That creates a copy of the database. It's a fundamental part of protecting...
"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 3, 2013 at 2:47 am
GilaMonster (10/1/2013)
Grant Fritchey (10/1/2013)
GilaMonster (10/1/2013)
SQLRNNR (10/1/2013)
Paul White (10/1/2013)
GilaMonster (10/1/2013)
And if you want details, come to the WIT lunch on the Thursday.
I'll be there. A bit scared, probably, but I'll be...
"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 2, 2013 at 6:12 am
GilaMonster (10/1/2013)
SQLRNNR (10/1/2013)
Paul White (10/1/2013)
GilaMonster (10/1/2013)
And if you want details, come to the WIT lunch on the Thursday.I'll be there. A bit scared, probably, but I'll be there.
Good.
I'll probably be...
"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 1, 2013 at 4:04 pm
Stefan Krzywicki (10/1/2013)
I now know why people hire wedding planners. Wow, this is a lot of work.
Another reason I love my wife. We invited about 20 friends & family, bought...
"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 1, 2013 at 8:29 am
jasona.work (10/1/2013)
Grant Fritchey (10/1/2013)
"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 1, 2013 at 7:36 am
Please. For purposes of employment, some of us cannot comment on politics because no matter what side I argue for, I'll yack off a customer or six. Can we keep...
"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 1, 2013 at 6:53 am
I used Policy Based Management as a secondary check on backup age. It's really easy to set up and maintain. You can read an introduction[/url] about it here.
"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 1, 2013 at 4:08 am
If you have to run these in parallel, then I would suggest using PowerShell. You can spawn multiple threads to have them all firing at the same time. I don't...
"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 1, 2013 at 4:06 am
Another mechanism is to use PowerShell. You can pretty easily walk the structure and generate scripts. Allen White has an example where he does it for the entire database. It'd...
"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 1, 2013 at 4:01 am
You're pumping 20000 rows (estimated, actual could be more) into table variables, where there are no statistics. Then you're combining that with a multi-statement table valued function, which also doesn't...
"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 1, 2013 at 3:56 am
Yes. The most I ever had was SQL Server 2000, 2005, 2008, 2008R2 and 2005 Express and 2008 Express. That was six instances of various versions on one desktop. No...
"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
September 30, 2013 at 8:34 am
To alter a database to a add a log file, you'd go through the processes outlined here.
"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
September 30, 2013 at 7:05 am
Viewing 15 posts - 9,481 through 9,495 (of 22,219 total)