Viewing 15 posts - 10,411 through 10,425 (of 22,224 total)
It's hard to make real substantive suggestions based on general information. Bigger, faster hardware always helps some. Depending on how much you upgrade the hardware, you can mask really bad...
"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 11:09 am
If very large data sets are needed, there's seldom much tuning that can be done through T-SQL or indexes. Usually, if you have to move extremely large data sets, you...
"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 11:06 am
Brandie Tarvin (9/24/2012)
I've never used object databases. Can you point me to some reference material? EDIT: Reference material regarding your reporting comment, that is.
Ah, I meant databases generated by ORM...
"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 6:14 am
CELKO (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 24, 2012 at 5:31 am
Roland Alexander STL (9/21/2012)
Which is the point of using local variables, since it will force a new plan each time the query is run. Of course, this is also 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:28 am
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
Viewing 15 posts - 10,411 through 10,425 (of 22,224 total)