Viewing 15 posts - 10,456 through 10,470 (of 22,226 total)
GilaMonster (9/18/2012)
In that case, pack beer. Good European beer, not American beer.
Careful there. We're not living twenty years in the past. These days, America has beer as good as Europe....
"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 10:39 am
jasona.work (9/18/2012)
Just realized that I will have to leave the rum at home...Sorry...
:crying:
Well it's a good thing I'm not speaking at SQL Saturday. Now, when I show up for SQL...
"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 9:47 am
Just remember that sys.dm_os_performance_counters is just querying against the Performance Monitor counters. They're as accurate or as inaccurate as anything else within Performance Monitor because they're both from the same...
"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 8:35 am
Ray K (9/18/2012)
jasona.work (9/17/2012)
Going to try to avoid being a "sit in the corner" person, do some networking, chat with people.
By all means! This is one of the best...
"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 6:50 am
I agree, read Perry's stuff.
With Availability Groups, you are getting something similar to a failover cluster, but without the stupid shared storage requirement (I always thought that was the silliest...
"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 6:16 am
As far as I know, that's per instance.
"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:57 am
Yes. If you're trying to set up availability groups, you are dealing with different servers with different storage. Now, that storage could be the same SAN, but each server is...
"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:55 am
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
Viewing 15 posts - 10,456 through 10,470 (of 22,226 total)