Viewing 15 posts - 14,311 through 14,325 (of 22,219 total)
You might be able to find a free software that could help you here: http://www.supershareware.com/sql-server-comparison-free/
I'd go for something like that rather than try to write it myself.
Do you have Visual...
"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:06 am
Yep. A linked server query will move all the data across the wire and then perform filtering. You're better off using OPENQUERY to pass the processing to the remote machine...
"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:02 am
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
Viewing 15 posts - 14,311 through 14,325 (of 22,219 total)