Viewing 15 posts - 13,951 through 13,965 (of 22,219 total)
Jack Corbett (11/5/2010)
Grant Fritchey (11/5/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
November 5, 2010 at 7:29 am
WayneS (11/5/2010)
Hey gang - can I get your thoughts on using TFS to deploy database changes?Thanks!
Posted. Hope that helps.
"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 5, 2010 at 7:09 am
We've been doing this for years. It works really well. I detail a bunch in the book that's getting released from Red Gate next week. In a nutshell, you deploy...
"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 5, 2010 at 7:08 am
Chris Morris-439714 (11/5/2010)
GSquared (11/5/2010)
CirquedeSQLeil (11/4/2010)
Grant Fritchey (11/4/2010)
CirquedeSQLeil (11/4/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
November 5, 2010 at 6:51 am
CirquedeSQLeil (11/4/2010)
Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion that may drive.
I used...
"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 4, 2010 at 4:19 pm
GSquared (11/4/2010)
GilaMonster (11/4/2010)
Lynn Pettis (11/4/2010)
Gail, Sounds like all future informal conversations will need to include a member of management.
The 'informal conversation' today (3rd time same issue) had the Project manager...
"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 4, 2010 at 1:45 pm
Can you do this? Yes, you can. Since it's only a dev server it shouldn't be too large a problem, but you really do have three things that don't like...
"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 4, 2010 at 6:28 am
One other thing, SQL Server 2008 does give you some ability to help with dynamic SQL. You can set the server to "Optimize For Ad Hoc Workloads." Here's a description...
"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 4, 2010 at 6:03 am
You have to know that with dynamic queries, every single change to the string that defines the query means you get a new execution plan, unless you use parameterized queries...
"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 4, 2010 at 5:56 am
In addition to limiting the indexes that you perform maintenance on based on fragmentation, I'd also limit based on the number of pages. Defragging or rebuilding an index less than...
"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 4, 2010 at 5:36 am
One of the keys to indexing is to watch the leading edge, the first column. You really need to avoid, as much as humanly possible (I'd say eliminate, but that's...
"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 4, 2010 at 5:34 am
Roy Ernest (11/3/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
November 3, 2010 at 7:42 am
GilaMonster (11/3/2010)
Grant Fritchey (11/3/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
November 3, 2010 at 6:14 am
GilaMonster (11/3/2010)
Gianluca Sartori (11/3/2010)
I'm not suggesting anyone to cheat, but the voting system relies on browser cookies to determine if a vote was placed... :Whistling:
and I have 2 computers 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 3, 2010 at 5:38 am
GilaMonster (11/3/2010)
BrainDonor (11/3/2010)
I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down...
"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 3, 2010 at 5:19 am
Viewing 15 posts - 13,951 through 13,965 (of 22,219 total)