Viewing 15 posts - 10,411 through 10,425 (of 22,219 total)
PiMané (9/21/2012)
Being a "generic" software spread across the country we can have databases with customers mainly from one state (where...
"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 24, 2012 at 5:27 am
Yep, I agree set-based processing is the biggest.
After that, some talk about why modifying databases is such a pain. Why relational storage is actually good for performance, not just 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 24, 2012 at 5:26 am
You'll need to set up basic monitoring to understand more fully what's happening on the system. Gails articles are an excellent place to start. You can also look at 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
September 24, 2012 at 5:03 am
Well you know I loved this article. I've been ranting about this issue for quite some time. It's nice to have yet another resource to point to in order 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
September 24, 2012 at 3:59 am
SQLRNNR (9/21/2012)
SQL Kiwi (9/21/2012)
Brandie Tarvin (9/21/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 22, 2012 at 5:05 am
Lowell (9/21/2012)
Grant wanted to avoid putting the answers on the forum, but i'd kind of like 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
September 21, 2012 at 11:51 am
Abu Dina (9/21/2012)
Grant Fritchey (9/21/2012)
Abu Dina (9/21/2012)
You get a phone call from one the users. They tell you the database is slow. What do you do?
You answer that reasonably well,...
"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 21, 2012 at 9:07 am
Abu Dina (9/21/2012)
You get a phone call from one the users. They tell you the database is slow. What do you do?
You answer that reasonably well, you're hired. You start...
"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 21, 2012 at 8:25 am
Jeff Moden (9/21/2012)
raghu14319 (9/20/2012)
plz send some interview scenarios on sql dba
Gosh... just do a Google search and you'll get more questions and answers (caution... some are wrong!) than you 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 21, 2012 at 7:13 am
Yeah, I've been in similar situations before too. All you can do is make your case. If all else fails, try this excuse[/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 21, 2012 at 5:03 am
golak_senapati (9/20/2012)
After migrating to SQL Server 2008, how can I get to know that all the tables are migrated successfully with its data (accurate data)?
It's a backup and restore, or...
"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 20, 2012 at 1:23 pm
Ooh, just spotted this, for examples, unless you're trying to set a standard as @parm1, etc. (and if so, no, no, no) I wouldn't use those in any examples. 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 20, 2012 at 7:42 am
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/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 20, 2012 at 6:54 am
SQLSACT (9/20/2012)
Grant Fritchey (9/20/2012)
SQLSACT (9/20/2012)
Grant Fritchey (9/20/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 20, 2012 at 6:45 am
ananda.murugesan (9/20/2012)
Total server memory 8 GB, I have set it max memory 6GB but SQL side using 5.79 GB, so it seems ok in sql side....
"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 20, 2012 at 6:42 am
Viewing 15 posts - 10,411 through 10,425 (of 22,219 total)