Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,266 through 47,280 (of 59,102 total)

RE: Help! TempDB just keeps on growing

When you guys made the "new" TempDB, did you make sure it was still set to the "Simple" recovery mode?
--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 14, 2008 at 12:13 am

#898425
RE: Custom Password Policy Stored Procedure Needed

Heh... loops... IF's... RBAR...
The hard part is figuring out how many of each character type is in the password and the following code figure that out nicely. 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)

November 14, 2008 at 12:09 am

#898423
RE: Concat mutiple rows into one row

See the following article for how to do the CSV concatenation along with some pitfalls to avoid...
http://www.sqlservercentral.com/articles/Test+Data/61572/
To help us give you a better/tested answer, take a look at the link...
--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 13, 2008 at 11:38 pm

#898414
RE: Update one table based on another table

Can you show what you've tried, so far?
--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 13, 2008 at 11:34 pm

#898411
RE: update and "if...else" clause?

UPDATE t5
SET UpdateField = CASE
...
--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 13, 2008 at 11:32 pm

#898409
RE: Introduction to DML Triggers

timothyawiseman (11/13/2008)
Heh. Robert and Mohit have a point. Instead of triggers views could be used to let a legacy application interact with and change the data in the...
--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 13, 2008 at 7:58 pm

#898384
RE: Exporting resultset of temp table to other formats. How?

sql-oholic (11/13/2008)
if i change temp table to global temp table, it works.
It's been a while since I've had to do such a thing, but that just doesn't seem right 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)

November 13, 2008 at 7:53 pm

#898383
RE: Arrays in Stroed Prcoedure

Thanks, Goldie. Glad to "meet" you. I appreciate 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)

November 13, 2008 at 6:40 pm

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

steveb (11/13/2008)
I also have to solve a lot of problems with our out-sourced projects and it shows that out-sourcing may seem like a cheaper option but can end up costing...
--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 13, 2008 at 6:34 pm

#898374
RE: CTE vs Derived Table

Jim Russell (11/13/2008)
You are right as usual, Jeff. I was mainly thinking of the cases where a CTE is referenced multiple times, and had always assumed that the results...
--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 13, 2008 at 6:21 pm

#898371
RE: Exporting resultset of temp table to other formats. How?

Bob Hovious (11/13/2008)
Doh! :w00t:
I knew there had to be a better way. What I really like about this approach is that you could use...
--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 13, 2008 at 6:15 pm

#898370
RE: Exporting resultset of temp table to other formats. How?

sql-oholic (11/13/2008)
Bob & Jeff,Thanks!
I'll try these methods. thank you
Thanks for the feedback. 🙂
--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 13, 2008 at 6:13 pm

#898369
RE: Storing Negative Numbers

Lynn Pettis (11/12/2008)
Jeff Moden (11/11/2008)
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. ...
--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 13, 2008 at 6:07 pm

#898368
RE: Arrays in Stroed Prcoedure

Oh dear... I blew it... :blush: I normally try to write in a gender-agnostic fashion especially when I don't really know someone. My appologies. Perhaps a first...
--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 13, 2008 at 5:58 pm

#898365
RE: DR Strategy with virtual machines?

I don't know for sure, but I don't believe so. VM has come a long way from it's inception.
So far as fast recovery of databases go, some SAN types...
--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 13, 2008 at 5:55 pm

#898364

Viewing 15 posts - 47,266 through 47,280 (of 59,102 total)