Viewing 15 posts - 13,936 through 13,950 (of 22,224 total)
I actually don't have any good advice on this one. I can tell you that going to a SQL Saturday, or better still, the Summit, has a tendency to get...
"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
November 15, 2010 at 8:47 am
vmssanthosh (11/15/2010)
We mostly do bulk loads in our databases. nearly a lakh data will get inserted/updated in our databases everyday.
In those cases, fk relationship will degrade the insert/update operation....
"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
November 15, 2010 at 7:41 am
Jack Corbett (11/15/2010)
Since I'm one of the organizers, live in the area, and missed the Summit, I'll be at SQLRally.
How is your son?
Mine, by the way, broke his nose while...
"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
November 15, 2010 at 7:03 am
Sweet. I like it. I like the format and I think it's perfect that it was lead out of the gate by Jeff. Nice, direct and to the point solution....
"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
November 15, 2010 at 5:38 am
I'd suggest checking the settings on the tempdb. It can be set to auto-shrink and then, yes, you're looking at serious issues, but in general, I'd definitely move tempdb to...
"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
November 14, 2010 at 6:20 pm
GilaMonster (11/14/2010)
Grant Fritchey (11/14/2010)
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?I might go.
Might go? Aren't you presenting there?
And that's why I might go.
"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
November 14, 2010 at 8:58 am
WayneS (11/14/2010)
Who all is planning on going to SQL Rally in Orlando in May?
I might go.
"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
November 14, 2010 at 8:39 am
Man, last week was a thrill ride. I too got to meet several of the regulars, although I didn't see nearly enough of Jeff. Sorry about that one. Johann even...
"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
November 14, 2010 at 6:25 am
Get Itzik Ben-Gan's book: T-SQL Fundamentals
"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
November 12, 2010 at 4:39 pm
We've had to build a system that does something like this. What we did was add a table that maintains versions. Then we had a master table, think of it...
"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
November 12, 2010 at 4:10 pm
GilaMonster (11/11/2010)
jcrawf02 (11/11/2010)
Craig Farrell (11/10/2010)
Must be the week...http://www.sqlservercentral.com/Forums/Topic1019000-392-1.aspx
Nice sig 😉 To be perfect, should start with "Yea" instead of "'lo", and have an extra thy in "Thy spool 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
November 11, 2010 at 8:21 am
In SQL Server 2008, yes. You can call DBCC FREEPROCACHE(plan_handle). You just have to get the appropriate plan handle out of the procedure cache.
"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
November 8, 2010 at 3:20 pm
Let me put a question back at you. Since most of the topics you outline have extensive documentation, courseware, books, etc., how do you propose getting developers to that information?...
"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
November 8, 2010 at 11:36 am
You might take a look at the RML Utilties from Microsoft. They can help you interpret the information from a trace.
"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
November 8, 2010 at 11:20 am
It's not necessarily a problem. It's just another indicator. I'd see if you have other indications of performance problems, excessive waits or queues, long running queries, that sort of thing....
"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
November 8, 2010 at 11:17 am
Viewing 15 posts - 13,936 through 13,950 (of 22,224 total)