Viewing 15 posts - 9,616 through 9,630 (of 22,219 total)
jeetsingh.cs (8/30/2013)
can i go doing both andshould i go for certification
Certifications is a whole different discussion.
You're early enough in your career that it might help some. Maybe.
I'm honestly 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
August 30, 2013 at 11:16 am
I am not sure. This is not something I've seen before. Do you have all the service packs applied to the server?
"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
August 30, 2013 at 7:20 am
Is it possible that it's a filtered statistic? I mean, the "good" example only sampled 38 rows. That seems pretty radically off unless it's filtered down to only a few...
"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
August 30, 2013 at 6:59 am
Not seeing the code or structures or plans, just guessing at possible solutions, but allow me to point out, there is nothing inherently good, or bad, in nested loop joins....
"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
August 30, 2013 at 6:55 am
Simple, follow your passion... and the money. Do what you love AND will get paid for.
"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
August 30, 2013 at 6:52 am
durai nagarajan (8/30/2013)
we definetely need a service out of SQL to monitor...
"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
August 30, 2013 at 5:23 am
One method I've seen people use to get around this is to create a SQL Agent job that runs the RESTORE. Then, you give people permission to execute the job,...
"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
August 30, 2013 at 5:12 am
Personally, this sounds like a job for PoweShell.
You can easily walk through the databases on a server, or from a list you provide, and then run your T-SQL script 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
August 30, 2013 at 5:09 am
It's not the best possible solution, but you can set up Alerts within SQL Agent. Here's the Books Online example of how to get it done.
"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
August 30, 2013 at 4:58 am
Since it's happening overnight, there has to be a process that is getting run overnight. Do you have scheduled jobs. If so, what are they doing?
I wouldn't suggest rebooting 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
August 30, 2013 at 4:55 am
Hmmm... This is 2008 right? How about putting extended events to work. You could try a few events like database_created, database_file_size_change, database_started, database_data_file_size_changed, file_written. It's not an investigation I've launched...
"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
August 29, 2013 at 6:29 am
Sean Pearce (8/29/2013)
http://www.apexsql.com/sql_tools_log.aspxApexSQL Log
Order now from $1,499 :w00t:
But that just reads the log. It doesn't read log backups.
Plus, you don't need a tool to read the log. There's an undocumented...
"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
August 29, 2013 at 6:20 am
Youch.
First, I'd toss the query hints. Then, get rid of all the functions on columns in the JOIN criteria and WHERE clause. After that... who knows. I'm not even addressing...
"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
August 29, 2013 at 4:40 am
No, that's pretty abnormal. I just did a test on one of my servers and I didn't see any difference at all in the time to create a database using...
"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
August 29, 2013 at 4:34 am
Koen Verbeeck (8/28/2013)
JLMayes (8/28/2013)
TravisDBA (8/28/2013)
Agreed, but let's make sure ALL the facts are uncovered first before calling anyone out. Otherwise, it just turns the whole situation into a witch hunt.:-D
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
August 28, 2013 at 3:49 pm
Viewing 15 posts - 9,616 through 9,630 (of 22,219 total)