Viewing 15 posts - 9,616 through 9,630 (of 22,224 total)
Presumably they all use the internet. Reference known web sites and talk about how they might work. You can use Amazon, Wikipedia, the Internet Movie Database (nicely named) or any...
"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 3, 2013 at 3:50 am
You must use COPY_ONLY when backing up a database on a secondary server. When backing up a database on the primary you can run a regular backup, or a COPY_ONLY...
"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 3, 2013 at 3:47 am
Jeff Moden (8/31/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
September 1, 2013 at 4:38 am
SQLRNNR (8/31/2013)
Grant Fritchey (8/31/2013)
Cool. That relieves a lot of pressure. I haven't taken a single Microsoft certification. Now, since the only one I respect is gone, I don't have to.
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 1, 2013 at 4:37 am
GilaMonster (8/31/2013)
Microsoft will no longer offer Masters and Architect level training rotations and will be retiring the Masters level certification exams as of October 1, 2013.
Sent late on 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
August 31, 2013 at 3:53 am
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
Viewing 15 posts - 9,616 through 9,630 (of 22,224 total)