Viewing 15 posts - 9,796 through 9,810 (of 22,232 total)
Brandie Tarvin (5/29/2013)
How much RAM would you recommend?
All of it.
"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
May 29, 2013 at 4:42 am
On a side note, don't rely too much on certifications. Except for the advanced certification, Microsoft Certified Master (MCM), most of the certifications are extremely straight-forward tests that people 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
May 29, 2013 at 4:41 am
It looks like the basic restore operation is set up fine. It's mainly a question of getting the connections clear before you restrict access to the database. You're going 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
May 29, 2013 at 4:39 am
SQL Server Management Studio (SSMS) is the front end for managing SQL Server. It provides two things, a graphical user interface for managing your SQL Server instances, your databases, 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
May 29, 2013 at 4:31 am
SQLBill (5/28/2013)
"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
May 28, 2013 at 9:13 pm
Well, backups, obviously. The issue for me would be, are we talking about functionality that belongs inside the same database or not? For example, do we need referential integrity. 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
May 28, 2013 at 9:08 pm
NJDave (5/28/2013)
Can you explain this sentence more?
These servers are currently virtualized - how would it make 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
May 28, 2013 at 3:17 pm
That's a new term to me. I've never heard it before.
Doing a few searches, I don't think it's any kind of industry standard term, but one that is used either...
"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
May 28, 2013 at 12:16 pm
If you isolate the schemas as was mentioned, it can be possible to do a partial restore to get back information from just the schema. But it's still a lot...
"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
May 28, 2013 at 12:09 pm
Thanks for the link Gail.
You need to start slow. Identify the query that is causing you the most pain. Figure out what's wrong with it. Fix that, then move on...
"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
May 28, 2013 at 12:07 pm
Nolocks only reduce contention caused by locking. They don't reduce any other kind of contention. So if your queries are using too much CPU, nolock doesn't help. If your queries...
"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
May 28, 2013 at 12:04 pm
There's a pretty good chance if you keep copies of your operating system installation and SQL Server installation, that you can keep those databases propped up and running for years...
"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
May 28, 2013 at 11:57 am
A few people come to mind. First, SQL Skills. Probably some of the best people around. One of SSCs own, Kevin Boles, does this sort of work. You could look...
"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
May 24, 2013 at 9:02 am
When I saw "visionary Database Administrator" I would have thrown my hands up and run screaming. That means, "We break all the rules, regularly, sometimes even on purpose, we know...
"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
May 24, 2013 at 3:24 am
GilaMonster (5/22/2013)
Grant Fritchey (5/22/2013)
GilaMonster (5/22/2013)
Oh look... "I don't think that's right... " again. Anyone got a baseball bat? Or a punching bag?Will an Arkansas tire thumper work?
No idea what one...
"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
May 23, 2013 at 4:00 am
Viewing 15 posts - 9,796 through 9,810 (of 22,232 total)