Viewing 15 posts - 10,456 through 10,470 (of 22,219 total)
anthony.green (9/18/2012)
Maybe they are trying to see if you know the limits and basics of SQL, they are all valid questions.
I don't know that I agree. The first three questions...
"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 18, 2012 at 5:50 am
Yes, you can do exactly that. Understand though, that prior to SQL Server 2012, the playback mechanism of Profiler is extremely primitive, single-threaded, and can only be run from 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
September 18, 2012 at 5:48 am
Animal Magic (9/18/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
September 18, 2012 at 5:44 am
If you're trying to only get the latest value, you might want to try some of the different methods I outlined in this article on Simple-Talk[/url].
"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 18, 2012 at 5:41 am
Hardware and compression are the two best things that I know of for making backups run faster. There just aren't any knobs to twist or switches to throw that make...
"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 18, 2012 at 5:30 am
Excellent. Glad to hear you're up & running.
Now, you're going to want SQL Agent to start automatically with your server. Time to get going on 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
September 18, 2012 at 5:22 am
Yes
"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 17, 2012 at 8:41 am
Since this is a 2008 forum, let's go with extended events or change data capture. Either of these will let you know who modified data. Triggers are incomplete and can...
"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 17, 2012 at 8:35 am
Because the GUI is trying to assist you through the process. And if you haven't got the full backup, the restore is going to go south. It's only validating against...
"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 17, 2012 at 8:09 am
Seriously considering dropping 2005 from my list of forums to monitor. Any driving reason why I shouldn't? I dropped 2000 a long time ago.
"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 17, 2012 at 7:31 am
dt2 (9/17/2012)
Yes it was in 2012. Simply a vanilla build 2008 R2 server, with vanilla sql 2012 instance.
I created a new database,...
"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 17, 2012 at 7:21 am
SQLSACT (9/17/2012)
Grant Fritchey (9/17/2012)
SQLSACT (9/17/2012)
Grant Fritchey (9/14/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
September 17, 2012 at 6:46 am
Not MSSQLSERVER(local). Just:
(local)
And not MSSQLSERVER.(local). Just:
.
You might also try:
yourmachinename\MSSQLSERVER
Please, I don't mean literally "yourmachinename" but rather, the name of your windows machine. Just trying to be more clear.
"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 17, 2012 at 6:27 am
dt2 (9/17/2012)
I can reproduce this on a vanilla 2008 R2 server, with a vanilla SQL install.
Maybe you are just too good and i'm just a dummy, but what am...
"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 17, 2012 at 6:21 am
Because you have to take an initial transaction log backup to begin that process. You're setting up log shipping. It requires you to have logs to ship. The log being...
"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 17, 2012 at 6:13 am
Viewing 15 posts - 10,456 through 10,470 (of 22,219 total)