Viewing 15 posts - 9,571 through 9,585 (of 22,219 total)
While I was never crazy about the Mac OS, VMWare on the Mac was magnificent. It worked wonders. I loved how tightly it was coupled with the OS. I'm back...
"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 11, 2013 at 4:30 am
If you did hit a situation where this might help, I'd be sure to use FREEPROCCACHE with the parameter for the specific plans you want to remove rather than blasting...
"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 11, 2013 at 4:28 am
Erland Sommarskog (9/10/2013)
Grant Fritchey (9/10/2013)
The only way to get run-time information is to capture the plan while executing using SSMS or extended events.
You can also capture them with SQL Trace....
"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 11, 2013 at 4:15 am
The plans stored in the cache do not carry run-time values with them. They only have the compile time values. This is perfectly normal behavior. The only way to get...
"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 10, 2013 at 3:24 pm
I don't know MySQL at all, but on a SQL Server instance it sounds like you're talking about extended properties. The ability to add additional, meta-data, about the columns or...
"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 10, 2013 at 3:43 am
If these are completely different functional applications with no shared data between them, then no, I would not put them into the same database. The sizes you're talking about are...
"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 10, 2013 at 3:40 am
Yep. Exactly. Nothing hidden there. They are different constructs doing different things.
"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 10, 2013 at 3:36 am
L' Eomot Inversé (9/9/2013)
Grant Fritchey (9/9/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 10, 2013 at 3:33 am
Also, if the data is that volatile you might be looking at statistics issues on the indexes. How are you doing maintaining those?
"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 9, 2013 at 4:12 pm
Not sure anyone noticed, but we passed the three year anniversary of the thread. Thank the gods the terrible twos are over. Our little... thread... is a toddler now.
"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 9, 2013 at 4:06 pm
Take a look at some of your more common or longer running queries that are using these nested views. Then, check the execution plan, specifically looking at the first operator,...
"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 9, 2013 at 10:51 am
I'll go one step farther than the others. In addition to scripting everything out and then running a restore, I'd get the scripts into some sort of source control so...
"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 9, 2013 at 4:11 am
Yeah, you have to do a little work to see the activity in the performance metrics. I outline it in an article here[/url].
"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 9, 2013 at 4:07 am
For backups I've been using Amazon storage and Azure. Both work about the same. If you do go with Azure, I strongly recommend getting a copy of Cerebrata's file management...
"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 9, 2013 at 4:05 am
Steven.Howes (9/6/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 6, 2013 at 10:28 am
Viewing 15 posts - 9,571 through 9,585 (of 22,219 total)