Viewing 15 posts - 8,206 through 8,220 (of 22,219 total)
The query against sys.dm_exec_requests will show all the queries running as well as any blocking. You can see the resources being used, how long a query has been running, pretty...
"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 9, 2014 at 12:29 pm
Not enough information to really say for sure what it might be, but since restarting changed the behavior, I'm thinking one of two things. First, it's possibly you had resource...
"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 9, 2014 at 12:04 pm
william.rees.howells (5/9/2014)
Please forgive my stupidity 🙂
Nothing to forgive. So far, I'm the only one who posted anything stupid on this thread.
"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 9, 2014 at 10:59 am
Yeah, what Gail said. It'll be live on Tuesday.
"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 9, 2014 at 10:31 am
william.rees.howells (5/9/2014)
Belarc Advisor. It's more for auditing but it shows your license keys as well. Seemed to do the trick and it was lucky because it was the first...
"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 9, 2014 at 9:03 am
Which key finder did you use? I tried one and it didn't work. The first PowerShell script I tried also didn't work.
"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 9, 2014 at 7:46 am
Grant Fritchey (5/9/2014)
"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 9, 2014 at 7:21 am
I'm attempting to run the executable now and I keep getting an error about "Invalid license data." I've got emails sent to Microsoft to see what's up with this.
"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 9, 2014 at 7:19 am
I'd probably bump the threshold cost up to at least 30 based on the information you have.
You can make this change right in the middle of the day. It's very...
"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 9, 2014 at 6:35 am
Yes, one will finish then the next one will 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
May 9, 2014 at 6:32 am
I would assume you get the disk so that you can adjust the services on offer on the server. I've never tried adding a second instance. I'll check with some...
"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 9, 2014 at 6:22 am
What you have in diagram 1 is a definition of an index and the balanced tree, or b-tree, that defines. Yes, each little box in that diagram is a page...
"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 9, 2014 at 5:56 am
I'd probably go to PowerShell to run this. It's pretty easy to set the command to connect to the other server and run a restore operation. It's also very easy...
"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 9, 2014 at 5:48 am
You can only do that if you have a license for an additional SQL Server instance and your own product key. The money you're paying for on the VM with...
"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 8, 2014 at 5:04 pm
Yes.
Seriously though, each one is more efficient in a given situation. If both data sets are ordered, the Merge join is extremely efficient. If you have a smaller set 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
May 8, 2014 at 3:50 pm
Viewing 15 posts - 8,206 through 8,220 (of 22,219 total)