Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,121 through 39,135 (of 59,098 total)

RE: Foreign key constraints...WHY??

My recommendation would be to first lookup "Constraints" and the "classes" under that heading in Books Online. That's a great place to start learning about all of the different...
--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)

April 1, 2010 at 7:24 pm

#1144582
RE: Full Database ReOrg

As a side bar, make sure you do a full blown backup of the data and the log file BEFORE you let the vendor anywhere near it. Backups before...
--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)

April 1, 2010 at 7:18 pm

#1144579
RE: SP says it's exceeded nesting level when there is no nesting involved!

WayneS (4/1/2010)
CirquedeSQLeil (4/1/2010)
Congrats on finding the issue.
This would be a nice example of a bad loop.
Bad loop indeed. Hmm, what would be a good loop? :w00t:
Recursion to...
--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)

April 1, 2010 at 3:20 pm

#1144503
RE: Generic Audit Trigger

YSLGuru (4/1/2010)
Jeff Moden (8/14/2007)
Thanks for the awesome compliment, Kenny... and thanks for the patch to the code!
Jeff - I just read over this thread and was curious if there...
--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)

April 1, 2010 at 11:10 am

#1144278
RE: Performance Tuning Big Table

scziege (4/1/2010)
Hi,
can you send a suggestions for a design of one table with 250 millions rows ?
Greetings
Absolutely...
Step 1: Define the purpose of the of table and the underlying data...
--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)

April 1, 2010 at 6:26 am

#1143888
RE: Delete / Replace Blobs

jtetler (4/1/2010)
Jeff - the index is clustered. I'll probably try both methods & see what kind of space savings I get. We have to keep 30 days of...
--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)

April 1, 2010 at 6:18 am

#1143876
RE: The Missing Certification

Gift Peddie (3/31/2010)
Heh... and not to worry... part of my goal is to help keep the lights on.
Thanks Microsoft made someone else MVP that was more important to me than...
--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)

April 1, 2010 at 6:06 am

#1143864
RE: The Missing Certification

CirquedeSQLeil (3/31/2010)
Jeff Moden (3/31/2010)
Heh... and not to worry... part of my goal is to help keep the lights on. 😉
Thanks. Now every time I read a post by 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)

April 1, 2010 at 6:05 am

#1143861
RE: Using Sproc for Paging

I know of a pretty fast way using dynamic SQL... but I need more detail in order to help.
--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)

April 1, 2010 at 5:57 am

#1143856
RE: Cross tab and Moving running totals

David,
Looks like Lutz may have is sussed but I'll ask anyway... are you all set on this 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)

April 1, 2010 at 5:55 am

#1143855
RE: Is this query a join?

Heh... I love cross joins... they make good Tally tables and interesting questions. 😀
--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)

March 31, 2010 at 9:50 pm

#1143637
RE: Overactive use of Temp Tables?

Usually, "It depends". This time, "It doesn't matter". 😉
Even without the Temp Table and going direct, you'd likely get a recompile everytime anyway because of the amount of data...
--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)

March 31, 2010 at 9:45 pm

#1143636
RE: DBCC Timewarp

I'm a bit disappointed... no mention of the hampster poo enhancement. 😛
--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)

March 31, 2010 at 9:38 pm

#1143632
RE: Delete / Replace Blobs

jtetler (3/31/2010)
Lowell,
Thanks for the code. I probably won't get to try it 'til next week or so - I'll be travelling a bit, but I'll let you know how...
--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)

March 31, 2010 at 9:25 pm

#1143622
RE: The Missing Certification

Jeff Moden (3/31/2010)
Gift Peddie (3/31/2010)
I came to SQL Server Central from Houston PASS, I stayed at SQL Server Central but I stopped attending PASS meetings five years ago. I...
--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)

March 31, 2010 at 9:22 pm

#1143619

Viewing 15 posts - 39,121 through 39,135 (of 59,098 total)