Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,091 through 39,105 (of 59,072 total)

RE: Why Be an MCP?

All I wanted to know is whether or not Microsoft makes money at training or not. My analogy is "is Microsoft wearing a shirt or not." 😉
--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 2, 2010 at 11:59 am

#1145006
RE: Cross tab and Moving running totals

Happy Easter to you, too, David. C'mon back if you can't put a tack in it. I just want to make sure you get an answer you can...
--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 2, 2010 at 11:56 am

#1145002
RE: Cross tab and Moving running totals

Sorry David... I've been staring at your latest problem with this and I just don't get it especially since your latest example doesn't actually match with the test data 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 9:22 pm

#1144590
RE: Finding Columns

krypto69 (4/1/2010)
We have an old db with allot of columns/tables...having trouble finding columns
Is there a script I can run to find columns with the associated table name?
Just press the f4...
--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:35 pm

#1144586
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

Viewing 15 posts - 39,091 through 39,105 (of 59,072 total)