Viewing 15 posts - 14,161 through 14,175 (of 22,219 total)
Maybe I've gone round the bend. Possibly senility has finally kicked in good and hard. Maybe it's just me, but does this sound a little bit nuts to anyone else?
They're...
"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
October 6, 2010 at 11:42 am
Will lights go off or horns sound or a little HUZZAH sound come out of the speaker for the person who hits 1m?
"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
October 6, 2010 at 9:25 am
If you stop the profiler trace, then click on File, Export, Script Trace Definition, and then select the version of SQL Server you want to output it for, you 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
October 6, 2010 at 9:21 am
Stefan Krzywicki (10/6/2010)
Wow, loading data into Access from SQL Server through SSIS is a Royal PITA.
That sentence is WAY too long:
Wow, loading data into Access is a Royal PITA
"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
October 6, 2010 at 9:18 am
Visual Studio Team System has a set of validations that can be run against your SQL code. They came out of what used to be the 2000 Best Practices Analyzer....
"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
October 6, 2010 at 9:17 am
parthi-1705 (10/6/2010)
barry.smallman (10/6/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
October 6, 2010 at 9:02 am
Yes, the interim table approach will allow for data integrity. But I wouldn't try to do the universal interim table. Despite the fact that it adds to the number 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
October 6, 2010 at 8:59 am
Alvin Ramard (10/6/2010)
Kit G (10/6/2010)
Grant Fritchey (10/6/2010)
bitbucket-25253 (10/5/2010)
Now how many members of the thread will be coming...
"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
October 6, 2010 at 7:18 am
samalex (10/6/2010)
Thanks for the great advice, but the problem we're running into is we don't know if a client will want cash flows and other tables that roll...
"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
October 6, 2010 at 7:16 am
I don't completely understand what's going on, so please excuse my ignorance.
First, can you explain in further detail why you can't have constraints?
I'm not a huge fan of GUIDs,...
"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
October 6, 2010 at 6:37 am
Even without an execution plan, I count five (5) different IN statements and I see a number of functions on columns in the WHERE clauses. Those alone will kill performance.
"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
October 6, 2010 at 6:06 am
What about setting up a server side trace to monitor for that query? You can capture who is calling it, when, from where, pretty much everything you need.
"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
October 6, 2010 at 6:03 am
Although, using sys.dm_exec_requests won't show blocking if parallelism is involved.
Another way to do it, and you can use almost the same query, is to look at sys.dm_os_waiting_tasks.
"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
October 6, 2010 at 6:01 am
Less than a thousand to go. I think it'll take another couple of days, but it's sure to be this week.
"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
October 6, 2010 at 5:54 am
GilaMonster (10/5/2010)
sqlbuddy123 (10/5/2010)
My two cents..You can check these books to become a master
I'll disagree slightly...
Books alone will not make you a master. Books + experience + experimentation may, with sufficient...
"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
October 6, 2010 at 5:41 am
Viewing 15 posts - 14,161 through 14,175 (of 22,219 total)