Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,296 through 47,310 (of 59,099 total)

RE: How To utilize log files

I've gotta dog-ear this page... all those in favor of developers having write access to production boxes, raise your hand! 😛
--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)

November 12, 2008 at 6:20 pm

#897861
RE: Stored Procedure speed versus Select Statement

Patrick Russell (11/12/2008)
Jeff Moden (11/11/2008)
Also, can you post your restructured WHERE clause, please?
Below is the code using the restructured WHERE clause you posted. In testing I saw no noticable difference;...
--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)

November 12, 2008 at 6:17 pm

#897860
RE: How To utilize log files

goodguy (11/12/2008)
I'm not a pro like all the others who have already ventilated this thread, but what I would do in this case is restore a backup on an independent...
--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)

November 12, 2008 at 6:13 pm

#897859
RE: Tempdb is full due to crappy procedure!!!

AndrewMurphy (11/12/2008)
Oh....and look into shooting the developer 😀
Um... for what? Using a paltry 40 MB of TempDB? Fragementing the disk because TempDB started out insanely small. ...
--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)

November 12, 2008 at 6:11 pm

#897858
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks for taking the time to say so! Keeps folks like me going. Thanks CM...
--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)

November 12, 2008 at 5:52 pm

#897854
RE: Nested Transactions - Best Practice

Adam, thanks for not only the explanation of what your trigger does and why DRI isn't going to do it for you, but also the trick you came up with...
--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)

November 12, 2008 at 5:47 pm

#897851
RE: Normalizing-Denormalized Tables

Ed Klein (11/12/2008)
Can we see the code for the function, Ed, or are you just saying that it would be nice to have one?
--Jeff Moden
I'm just saying it would be...
--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)

November 12, 2008 at 5:33 pm

#897848
RE: Fix the Little Things

majorbloodnock (11/12/2008)
Thing is, MS don't need to do this kind of stuff. If there's a market, someone will write a utility that does all these "little things". If there's sufficient...
--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)

November 12, 2008 at 6:28 am

#897463
RE: how find the missing value from a range of value

Heh... mine too... I copied it from a gap detecter that I had in my library. It's some really ugly code with the correlated sub-query and all, but it's...
--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)

November 12, 2008 at 6:19 am

#897457
RE: Would pivot work here?

Brandie Tarvin (11/12/2008)
Jeff Moden
Ggraber has the right idea
Possibly, but his code is interupted by the forum turning part of it into a smiley face, which means I get a...
--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)

November 12, 2008 at 6:15 am

#897456
RE: Normalizing-Denormalized Tables

Very cool... I didn't know about the product. Thanks.
--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)

November 12, 2008 at 6:11 am

#897454
RE: Normalizing-Denormalized Tables

Mohit (11/11/2008)
Hi Jeff,
I was planning to create 5 databases, each with different number of records. One with the original 30, second with 300, 3rd with 1000,...
--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)

November 11, 2008 at 11:48 pm

#897352
RE: Storing Negative Numbers

Lynn Pettis (11/11/2008)
Jeff Moden (11/11/2008)
Oh my... I just remembered where the heck such a requirement for all positive numbers may have come from... PeopleSoft software. Seems like the last...
--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)

November 11, 2008 at 11:46 pm

#897351
RE: How To utilize log files

Restoring part of the log will get the proc back?
--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)

November 11, 2008 at 11:44 pm

#897350
RE: Cannot convert nvarchar datatype to int error

Lynn Pettis (11/11/2008)
If it is an 'I' then 0 else 1.
Jeff, been try to help him, but we can't even get him to help himself. I have pointed him...
--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)

November 11, 2008 at 11:38 pm

#897347

Viewing 15 posts - 47,296 through 47,310 (of 59,099 total)