Viewing 15 posts - 15,721 through 15,735 (of 22,219 total)
RBarryYoung (3/14/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
March 15, 2010 at 5:30 am
There is a third party tool available for migrating DTS packages to SSIS. Go check out DTS Exchange[/url]. We've been using it and it's a great tool.
"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
March 13, 2010 at 7:04 am
Just to pile on a bit, I'm with Jeff. It sounds like your architecture, your structures, and your code are to blame. You need to get someone in who 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
March 13, 2010 at 6:54 am
I'd report it to Microsoft. I've never seen that behavior and I've been using SSMS 2008 since the beta to manage 2000 and 2005 databases without any issues (except the...
"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
March 13, 2010 at 6:50 am
Alvin Ramard (3/12/2010)
Great job on Twitter Grant. Mention DBCC TimeWarp to Paul and then run. 😀
I haven't logged back into Twitter yet. You're saying I got away 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
March 13, 2010 at 5:35 am
CirquedeSQLeil (3/12/2010)
Grant Fritchey (3/12/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
March 12, 2010 at 1:19 pm
And then the next day you get a call from your manager who explains exactly why you'll be doing whatever heinously stupid operation it is that the developer decided they...
"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
March 12, 2010 at 1:07 pm
Alvin Ramard (3/12/2010)
george sibbald (3/12/2010)
Alvin Ramard (3/12/2010)
george sibbald (3/12/2010)
Before we have a DBA contest some one is going to have to define what a DBA does first.............
A DBA tells developers:...
"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
March 12, 2010 at 1:05 pm
CirquedeSQLeil (3/12/2010)
Grant Fritchey (3/12/2010)
I'm holding out for the Adequate DBA Competition. I'll be GREAT!
Why not the Barely Meets Expectations DBA?
Could you imagine the competition? :hehe:
And yes, it's Brad's book on...
"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
March 12, 2010 at 12:06 pm
I'm holding out for the Adequate DBA Competition. I'll be GREAT!
And yes, it's Brad's book on how to be an exceptional DBA. It's really worth a read.
"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
March 12, 2010 at 11:55 am
GilaMonster (3/12/2010)
Paul White (3/12/2010)
GilaMonster (3/12/2010)
Gianluca Sartori (3/12/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
March 12, 2010 at 11:32 am
That's a classic case of parameter sniffing. SQL Server is able to use the hard coded value to determine that the index has what it needs and is relatively low...
"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
March 12, 2010 at 11:01 am
I'm going to assume the column is a datetime and you're not taking into account the time aspect of the date math.
"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
March 12, 2010 at 10:25 am
Paul White (3/12/2010)
Grant Fritchey (3/12/2010)
And when you make the query into a procedure as Paul says, make the parameters NOT NULL and the users will have to supply them.
Good point...
"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
March 12, 2010 at 9:52 am
Bhuvnesh (3/12/2010)
kvtraju (3/12/2010)
Hi everyone iam newbie can you guys suggest me the best handbook on dba administration 2005Dont forget to read SQL_Server_Execution_Plans by Grant Fritchey, Amazing Book
Thank you, 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
March 12, 2010 at 7:11 am
Viewing 15 posts - 15,721 through 15,735 (of 22,219 total)