Viewing 15 posts - 10,441 through 10,455 (of 22,219 total)
Brandie Tarvin (9/19/2012)
Lynn Pettis (9/19/2012)
Brandie Tarvin (9/19/2012)
Lynn Pettis (9/19/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 19, 2012 at 11:17 am
Lynn Pettis (9/19/2012)
Stefan Krzywicki (9/19/2012)
SQLRNNR (9/19/2012)
Grant Fritchey (9/19/2012)
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4....
"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 19, 2012 at 9:27 am
SQLSACT (9/19/2012)
Grant Fritchey (9/19/2012)
SQLSACT (9/19/2012)
Grant Fritchey (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 19, 2012 at 7:49 am
Brandie Tarvin (9/19/2012)
Grant Fritchey (9/19/2012)
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild...
"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 19, 2012 at 7:14 am
Nothing wrong with this maintenance plan. I mean, everything is covered:
1. Check DB Integrity
2. Back Up Db Full
3. Back up Db transaction log
4. Shrink Db
5. Rebuild index
6. Update statistics
7. Reorganize...
"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 19, 2012 at 6:48 am
I don't know your structure, but on a guess, I'd assume that you're actually looking at denormalized data. Can't you normalize the structure and then import the information into 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 19, 2012 at 5:00 am
SQLSACT (9/19/2012)
Grant Fritchey (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 19, 2012 at 4:18 am
jasona.work (9/18/2012)
I just realized the subject of this thread is WRONG!
It's about the SQL in the City, in Chicago, I have NO idea where I came up with the Saturday...
"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:40 am
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
Viewing 15 posts - 10,441 through 10,455 (of 22,219 total)