Jeff Moden

Forum Replies Created

Viewing 15 posts - 32,491 through 32,505 (of 59,099 total)

RE: Where are all the MVBs?

GilaMonster (9/24/2011)
That's one nice thing about been a consultant.
Heh... and, oh, how I miss that. And, yes... I agree... the wrong people would read the book. After all,...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 24, 2011 at 4:25 pm

#1386141
RE: Where are all the MVBs?

Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server.
I have...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 24, 2011 at 1:49 pm

#1386132
RE: Big Gaps
majorbloodnock (9/23/2011)
I've been doing a lot of nodding whilst reading some of these replies.
For me, the following are major gaps I see, often in surprisingly senior IT people.
Understanding what it...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
September 24, 2011 at 1:06 pm

#1386127
RE: A time-out occurred while waiting for buffer latch

Which edition of SQL Server do you have? Also, any chance of you posting the code for your reindex job... sanitized, of course.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 24, 2011 at 12:14 pm

#1386124
RE: How to Maintain History of data in tables.

On of the easiest ways to do this, and it will capture any and all changes, is to do as suggested above but use some very well written triggers (and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 24, 2011 at 12:04 pm

#1386123
RE: sql DB table handling thousands of inserts a sec

You say these tables are also used for reporting? If THIS particular table is used for reporting, there's a fairly good chance it has some indexes on them that...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 24, 2011 at 11:31 am

#1386120
RE: Trouble calculating a column (need some help)

bennett_js (9/23/2011)
The issue is when I try to run statement:
SELECT PWARD_EQUIPMENT.EQUIPMENT_ID, PWARD_EQUIPMENT.AMMO_QUANTITY AS QUANTITY_ON_HAND,
SUM(PWARD_AMMO_USE_EQUIPMENT.QUANTITY_USED) AS QUANTITY_USED, SUM(PWARD_EQUIPMENT.AMMO_QUANTITY + QUANTITY_USED) AS QUANTITY_RECEIVED
FROM ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 24, 2011 at 11:09 am

#1386118
RE: Temp tables and table variables scope and persistence.

CELKO (9/23/2011)
That is not a bad code smell; that is a code stink in SQL. Local variables say this is COBOL written in SQL; good SQL nests expressions into one...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 24, 2011 at 9:45 am

#1386108
RE: Query optimizing 2

I apologize for the delay but yes, indeed, I am doing some testing in my "spare" time. This has become quite interesting.
Conventional wisdom would indicate that a single "SUM"...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 23, 2011 at 7:39 pm

#1386075
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Mike M - DBA2B (9/23/2011)
I have to say, most of my day has been "just ok". Seeing that Jeff received this has put me over the moon. Jeff, not only...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 23, 2011 at 4:05 pm

#1386050
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

mkeast (9/22/2011)
Congratulations, Jeff.
You have been deserving of an award like this for years. As a long-time SSC member and regular tally table user (and calendar table!), I thank you...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 23, 2011 at 5:57 am

#1385637
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

L' Eomot Inversé (9/22/2011)
Great interview, Jeff.
And congratulations again on the award.
Thanks again, Tom. And don't you ever even think about quitting. Your posts and advice have been quite...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 23, 2011 at 5:39 am

#1385629
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Mike McQuillan (9/22/2011)
Congratulations Jeff, I'm really pleased for you! Well done and a good interview too.
I have to admit, I was pretty nervous about the interview and how it might...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 23, 2011 at 5:35 am

#1385627
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

mtassin (9/22/2011)
He calls himself an “Accidental DBA.” His title at DiscoverReady is Lead Application DBA and Data Architect. He’s known as a writer for SQLServerCentral.com whose articles are...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 23, 2011 at 5:33 am

#1385625
RE: An interview with Jeff Moden: Exceptional DBA of 2011 and natural helper

Kiara (9/22/2011)
Congratulations, Jeff, and thank you, yet again, for everything you do and all you teach.
Thank you again, Kiara. I appreciate the kind words.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

September 23, 2011 at 5:20 am

#1385614

Viewing 15 posts - 32,491 through 32,505 (of 59,099 total)