Viewing 15 posts - 14,326 through 14,340 (of 22,232 total)
First off, nesting views frequently leads to performance problems. I recommend against it.
Based on the info in the spread sheet, it looks like you have out of date statistics. You've...
"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 24, 2010 at 8:01 am
Yep 10gb
"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 24, 2010 at 7:53 am
You can't segregate the data within a table. If your client has to be completely isolated, then you have to move them to another table. The only other option 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
September 24, 2010 at 7:51 am
You can run it for 24 hours, you just have to be prepared for the fact that you're going to get a whole lot of data. Plan accordingly, run 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
September 22, 2010 at 9:42 am
Bhuvnesh (9/22/2010)
"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 22, 2010 at 6:48 am
Brandie Tarvin (9/22/2010)
Grant Fritchey (9/22/2010)
...I think people thought I was a little weirder than usual.
I'm so glad you put those last two words on that sentence. Otherwise, I would feel...
"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 22, 2010 at 6:44 am
From Books Online:
Security
In Windows Authentication mode, the user account that runs SQL Server Profiler must have permission to connect to an instance of SQL Server.
To perform tracing with SQL 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
September 22, 2010 at 6:23 am
Bhuvnesh (9/22/2010)
Tara-1044200 (9/21/2010)
the execution plans are choosen differently.
No , view has same exec plan as it has for inner incorporated query.sql optmizer treats both view and query same while analyzing...
"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 22, 2010 at 6:20 am
GilaMonster (9/22/2010)
Grant Fritchey (9/22/2010)
GilaMonster (9/22/2010)
Ran across this earlier, thought it appropriate.Ha! I have that hanging at my desk.
I have this one hanging above mine (at home)
http://www.despair.com/despair.html
I bought this one 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
September 22, 2010 at 6:13 am
GilaMonster (9/22/2010)
Ran across this earlier, thought it appropriate.
Ha! I have that hanging at my desk.
"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 22, 2010 at 5:53 am
Chris Morris-439714 (9/22/2010)
Alvin Ramard (9/21/2010)
Steve Jones - Editor (9/21/2010)
Keep up the bad jokes and we'll likely get 30 a day 🙂
A query walks into a bar, sees two tables and...
"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 22, 2010 at 5:52 am
GilaMonster (9/21/2010)
dbowlin (9/21/2010)
I will probably go with one of the editors, but it could be anyone.....even me!
One of the editors? The only editor here is Steve. The rest of us...
"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 21, 2010 at 1:27 pm
skrilla99 (9/21/2010)
Grant,Would the default trace be a good choice here to persist data across restarts?
-Dan B
I guess it depends on what's being looked for. The Default Trace doesn't store DML,...
"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 21, 2010 at 1:23 pm
Do you mean you want to know what database was most recently queried from (or to)?
In that case, you could do something like this:
SELECT TOP 10
...
"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 21, 2010 at 12:20 pm
If you supply a value through OPTIMIZE FOR, it's going to use that value. It won't help it arrive at a better plan, just the one that it can arrive...
"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 21, 2010 at 12:08 pm
Viewing 15 posts - 14,326 through 14,340 (of 22,232 total)