Viewing 15 posts - 15,571 through 15,585 (of 22,219 total)
TheSQLGuru (4/2/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
April 2, 2010 at 8:00 am
I think the time in service, as part of the bridge between MCTIP and MCM, actually adds unecessary overhead that is simply going to be gamed anyway. I'm assuming this...
"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
April 2, 2010 at 7:51 am
WayneS (4/2/2010)
Grant Fritchey (4/2/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
April 2, 2010 at 7:36 am
Sorry, test failed. Please try again.
"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
April 2, 2010 at 6:28 am
I saw this question over on ask.sqlservercentral.com as well. I don't understand what you're trying to achieve with this information. Most of it is survey type questions, not questions regarding...
"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
April 2, 2010 at 6:27 am
That's the problem with bringing titles and time in rate to the equation. One of the best DBA's I know isn't a DBA, she's a developer; Gail Shaw. I think...
"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
April 2, 2010 at 6:20 am
Using a number does make sense, but I wouldn't suggest you use NUMERIC. The NUMERIC(12,0) suggested is 9 bytes in size. An INT is only 4 bytes and covers 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
April 2, 2010 at 6:05 am
GilaMonster (4/1/2010)
Now I have someone whining about my april fool's blog post. 🙁
Oh that was flipping sad.
I hope the schmuck finds your post every day for the rest of his...
"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
April 1, 2010 at 11:05 am
Assuming this is a serious question...
Since I'm unclear what you're asking, I'll tell you how to define parameters for your procedure. Assume you want to pass a column called ID...
"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
April 1, 2010 at 10:56 am
Steve Jones - Editor (4/1/2010)
Grant, you ought to use that for an editorial. It's certainly something worth talking about.
On it. For sure this time.
"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
April 1, 2010 at 9:03 am
Jack Corbett (4/1/2010)
Grant Fritchey (4/1/2010)
Paul White NZ (4/1/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
April 1, 2010 at 7:38 am
Do you have an execution plan?
"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
April 1, 2010 at 7:10 am
It's best to use the Microsoft supplied tool, SQL Server 2008 Upgrade Advisor, to check to see if you have any compatibility issues before you do the restore. But, as...
"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
April 1, 2010 at 7:06 am
Paul White NZ (4/1/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
April 1, 2010 at 6:42 am
Paul White NZ (4/1/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
April 1, 2010 at 6:38 am
Viewing 15 posts - 15,571 through 15,585 (of 22,219 total)