Viewing 15 posts - 19,951 through 19,965 (of 22,226 total)
mhaskins (7/18/2008)
Joshua Jones (7/18/2008)
For me the soft skills came from being a customer service professional ...
Mine too - I don't know if my minimum wage customer service jobs were really...
"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
July 18, 2008 at 8:03 am
This reminds me of when i started at my current company. I started the same day as another guy in my group. He was considered the people person/manager in 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
July 18, 2008 at 7:48 am
This is a good article. I can see why it was reprinted. I'd like to see an update. Things are just a little different in 2005/2008. Those differences, some 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
July 18, 2008 at 7:09 am
David Tiss (7/27/2007)
Great article, I learned a lot.
I'm wondering if the included column feature in SQL Server 2005 will also help with bookmark lookups?
INCLUDE columns absolutely help with lookup...
"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
July 18, 2008 at 7:07 am
Soft skills... Soft skills....
OH! I know. That's when you use wrist locks and grapple into submission holds rather than smash their face flat and kick their naughty bits up between...
"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
July 18, 2008 at 6:06 am
And the functionality has improved a ton. I love being able to pull execution plans right off the screen.
"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
July 17, 2008 at 12:16 pm
I'm happy to see someone else come out with the old data saw, only move the data you need and only when you need it. I would have added that.
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
July 17, 2008 at 8:12 am
Actually, if I were doing it, first, I'd try to avoid dynamic sql unless you use sp_executesql and pass it parameters (this creates execution plans that are reusable). For what...
"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
July 17, 2008 at 6:58 am
Between the query window in Management Studio and the command line options available through sqlcmd.exe, anything you can do with isql.exe is very old hat indeed. They're either just using...
"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
July 17, 2008 at 6:54 am
There probably is a vanishingly small performance hit for that, yes. However, all the other issues around writing are so intensive, that little tiny blip where the query engine rearranges...
"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
July 17, 2008 at 6:52 am
That's not against what I said at all. That's what I've been trying to suggest. Thanks for stating it in a different way.
"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
July 17, 2008 at 5:59 am
When data changed, a given row would be versioned, but not all rows or all tables. Also, the "version" was not a moment-by-moment creation. They would work on a given...
"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
July 17, 2008 at 5:56 am
Maybe I'm old fashioned (or just old), but I've always felt that one of the principal duties you have is supporting those around you to the best of your ability....
"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
July 17, 2008 at 5:50 am
What do the execution plans look like? Maybe it's not using the uniqueidentifier at all?
"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
July 17, 2008 at 5:22 am
OK.
WHILE (@StartDate < @StopDate)
BEGIN
SET @StartDate = DATEADD(month,1,@StartDate)
SET @EndDate = DATEADD(day,-1,DATEADD(month,1,@StartDate))
...
"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
July 16, 2008 at 12:34 pm
Viewing 15 posts - 19,951 through 19,965 (of 22,226 total)