Viewing 15 posts - 10,816 through 10,830 (of 22,219 total)
It's not that you don't protect it. In fact, you can protect it a lot more. It's just not a single file that you assign a password to like Access....
"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
June 4, 2012 at 11:15 am
When all you have available is the full backup, that's all you're going to get. If you have log backups available, you can restore right to the end of 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
June 4, 2012 at 8:57 am
michaeljharper (6/4/2012)
Also, word of advice, asking instructors at a school, who are absolutely dependent on you attending that school for their livelihood, if you maybe ought to spend another two...
"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
June 4, 2012 at 6:00 am
Generally, integrated security, Windows security, is considered to be the better approach. You can use a login and a password. That's called SQL Server security. But I wouldn't suggest 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
June 4, 2012 at 5:47 am
If updating the statistics slows down the performance of the query, it's likely because a new execution plan was created based on the updated statistics. You'll need to look at...
"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
June 4, 2012 at 5:44 am
You need to validate how much CPU usage you're seeing on the system now. If you're already operating at the edge, sustained CPU usage at or above 75%, then 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
June 4, 2012 at 5:35 am
Not entirely sure what you mean by the question, but one of the coolest new pieces of technology to come with SQL Server 2012 is the AlwaysOn Availability Groups. 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
June 4, 2012 at 5:32 am
In the US, in certain fields, it will absolutely help. But overall, no, it won't help your technology career that much. If you were just getting started and I were...
"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
June 4, 2012 at 5:27 am
Nope. Sorry, nothing but hard work in front of you to make a database run faster. Check out my book on query tuning.
Or, you can buy really big servers. Throwing...
"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
June 4, 2012 at 5:23 am
Just an aside, instead of relying on backups for stored procedures, triggers, and other structural pieces of the database, I'd get all that code into a source control system.
"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
June 4, 2012 at 5:21 am
Do you already have a backup process in place? Have you verified that your backups work? That means have you tested a restore? I'd start there as step one of...
"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
June 4, 2012 at 5:19 am
pages/sec is just an indication of load. You don't know if it's high or low until you get a baseline to compare it 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
June 1, 2012 at 5:22 am
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
I'm with you. Fast enough is fast enough.
But, I remember when a friend of mine (wish I could say I did this) spotted 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 31, 2012 at 12:07 pm
patrickmcginnis59 (5/31/2012)
Grant Fritchey (5/31/2012)
I'm with you. Fast enough is fast enough.
But, I remember when a friend of mine (wish I could say I did this) spotted a problematic query in...
"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 31, 2012 at 11:34 am
donnapatriciakelly (5/31/2012)
I work in the Business Intelligence area, and deal with all sorts of source systems. Getting data...
"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 31, 2012 at 11:01 am
Viewing 15 posts - 10,816 through 10,830 (of 22,219 total)