Grant Fritchey

Forum Replies Created

Viewing 15 posts - 14,266 through 14,280 (of 22,224 total)

RE: Index question for a monthly summary table

scott.pletcher (9/29/2010)
I would stick with the more used field (and properly ascending) field. On an index, the most important thing is to match the first column in the index,...
"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

September 29, 2010 at 12:02 pm

#1229250
RE: Index question for a monthly summary table

Nevyn (9/29/2010)
Grant Fritchey (9/29/2010)
I guess my question is, where does the slowdown occur? Is it in the insert? If so, are you getting lots of page splits or is 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

September 29, 2010 at 11:34 am

#1229227
RE: Differential backup effect on transaction log

Piling on a bit...
No, neither differential or full backups affect the transaction log.
"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

September 29, 2010 at 9:26 am

#1229147
RE: Index question for a monthly summary table

I guess my question is, where does the slowdown occur? Is it in the insert? If so, are you getting lots of page splits or is it just an I/O...
"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

September 29, 2010 at 9:24 am

#1229144
RE: Are the posted questions getting worse?

Jack Corbett (9/29/2010)
So how do you all deal with a "maverick"/"lone ranger" coder? I think you all know what I mean. That person who goes off and does...
"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

September 29, 2010 at 9:01 am

#1229121
RE: Re-creatable deadlock on index - rebuild index does not solve

Yeah, late to the game, I was going to suggest READ COMMITTED SNAPSHOT as well.
Isolation levels are very different from locking hints. Isolation levels define how transactions will behave...
"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

September 29, 2010 at 8:58 am

#1229115
RE: Are the posted questions getting worse?

Stefan Krzywicki (9/29/2010)
Oh, I think there's a point to meetings. If you're all working on the same thing and are talking about problems so everyone can think about solutions or...
"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

September 29, 2010 at 7:59 am

#1229035
RE: Re-creatable deadlock on index - rebuild index does not solve

Yes, READ COMMITTED is the default. Well, I'm stumped then. Something that is just a SELECT shouldn't be grabbing exclusive locks, so the best thing I can suggest is...
"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

September 29, 2010 at 7:54 am

#1229027
RE: Are the posted questions getting worse?

GilaMonster (9/29/2010)
Brandie Tarvin (9/29/2010)
Secondly, he should be asking you what he can do to facilitate what you're doing. Not badgering you about the fact that you're behind schedule.
An extension 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

September 29, 2010 at 7:28 am

#1229001
RE: Re-creatable deadlock on index - rebuild index does not solve

scott_lotus (9/29/2010)
That's a good point. Im sure the query is SELECT only. Added (NOLOCK) to the larger tables used but not the table in question.
1) I thought SELECTS exclusively...
"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

September 29, 2010 at 7:15 am

#1228993
RE: The Design Investment

Matt S. (9/29/2010)
@Grant
I hear you. I've seen DBAs light up with some glimmer of hope when I'm hired to reign in developers gone wild. It's because I sell my services...
"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

September 29, 2010 at 7:12 am

#1228991
RE: Are the posted questions getting worse?

Brandie Tarvin (9/29/2010)
GilaMonster (9/29/2010)
Got a project manager that holds a weekly meeting in which does the following:
* Asks the developers what they are currently busy with
* Updates his % completed...
"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

September 29, 2010 at 7:01 am

#1228978
RE: The Design Investment

Matt S. (9/29/2010)
I also partially agree with the comments made against ORMs. I feel that many developers use those tools to generate the DB and that makes me shutter. 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

September 29, 2010 at 7:00 am

#1228975
RE: The Design Investment

Grant Fritchey (9/29/2010)
I don't know about everyone else, but I'm seeing less and less data design these days as we use more and more ORM tools. They "do the design...
"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

September 29, 2010 at 6:58 am

#1228967
RE: Convert notes data to sql table usage

Personally, the easiest would be to put SQL Server Integration Services to work on it. SSIS can do this type of break down quite easily.
Another option, not as easy, would...
"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

September 29, 2010 at 6:56 am

#1228965

Viewing 15 posts - 14,266 through 14,280 (of 22,224 total)