Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,726 through 34,740 (of 59,099 total)

RE: Tempdb Size increases and acquires the complete disk space

Manuni Shah (3/7/2011)
The issue goes as follows,
Tempdb size generally remains around 3GB. One day it starts increasing and acquires the whole of the empty disk space of 29 GB within...
--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 9, 2011 at 6:04 am

#1296443
RE: Union Query Total

Chris Morris-439714 (3/9/2011)
clarmatt73 (3/9/2011)
Hi All,
I have a stored procedure that has five union queries within it, the first and last queries in the code are the Header and Footer for...
--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 9, 2011 at 5:56 am

#1296436
RE: Quality Over Timing

Oddly enough, I don't blame the customers. On the jobs where I've been able to contact the customer directly instead of through a PM, I've been able to convince...
--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 9, 2011 at 5:52 am

#1296433
RE: MS SQL String combination

GPO (3/9/2011)
Who IS that masked man?
Just lil' ol' pork chop slinger, me. 🙂
--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 9, 2011 at 5:44 am

#1296427
RE: MS SQL String combination

samuelg78 (3/9/2011)
It worked great. I had tried to post in many forum but you are the only one who can managed to solve it. Great thks.
Thanks, samuelg78. It's nice...
--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 9, 2011 at 5:42 am

#1296426
RE: MS SQL String combination

My bad. I shouldn't post this late at night. 😛
You need to build a "Zero Based" Tally Table. Here's how to do 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)

March 9, 2011 at 12:42 am

#1296341
RE: MS SQL String combination

p.s. Sort the output by length, by value, or a combination of both to get it the way you want 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)

March 9, 2011 at 12:33 am

#1296336
RE: MS SQL String combination

Agh. Dammit. 😛 I just can't sleep when such an interesting and fun problem is at hand.
Ok, here's what you do. Execute the following code to build...
--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 9, 2011 at 12:30 am

#1296334
RE: MS SQL String combination

...and I apologize for copping out for sleep. If no one solves this for you tonight or tomorrow, I'll try to get to it after my local PASS meeting...
--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 8, 2011 at 11:04 pm

#1296315
RE: MS SQL String combination

Agh! Look at the bloody time. It's 1:00AM here. I've gotta get up in 4 hours.
To solve this problem, think "Binary Counter" with a filter. For...
--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 8, 2011 at 10:56 pm

#1296312
RE: MS SQL String combination

samuelg78 (3/8/2011)
The maximum number of elements will be 10. And each element is unique. And the pass in string maybe not be in order e.g: "01-02-04-03", "03-02-01".
Understood. But 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 8, 2011 at 10:50 pm

#1296308
RE: MS SQL String combination

Also, will each element have the same number of characters as the other elements in the same string?
--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 8, 2011 at 10:41 pm

#1296304
RE: MS SQL String combination

What is the maximum number of elements in any given string?
--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 8, 2011 at 10:38 pm

#1296303
RE: Quality Over Timing

Cool picture that, ironically, lives up to what I think of a lot of software vendors that write T-SQL have done and still do... take a look at the printing...
--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 8, 2011 at 10:17 pm

#1296295
RE: Common table exp

Wow! Pretty good, Joe. Great post and you didn't call the user any names or infer any insults. I'm impressed. Seriously. Nice change.
--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 8, 2011 at 9:56 pm

#1296291

Viewing 15 posts - 34,726 through 34,740 (of 59,099 total)