Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,606 through 46,620 (of 59,101 total)

RE: How do you archive data?

Interesting idea... and, if you really do that, there is no reason for a purge process. Just create the new table on a daily basis and have a script...
--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)

December 15, 2008 at 9:09 pm

#912912
RE: Are the posted questions getting worse?

Lynn Pettis (12/15/2008)
Well, call me a softy, but I gave him something to work with. Hope it takes the comments to heart and takes the time to provide us...
--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)

December 15, 2008 at 9:05 pm

#912909
RE: how to convert vb function to sql function

I thought this was a fun problem to solve and also gave the opportunity to demo both the power and readability of "Cascading CTE's".
Here's the function...
CREATE FUNCTION dbo.ConvertFractionToDecimal
/**********************************************************************************************************************
...
--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)

December 15, 2008 at 8:54 pm

#912906
RE: how to convert vb function to sql function

Damned nice try, Peter... thought you had it, but not quite...
SET STATISTICS TIME ON
SELECT '5' , dbo.fnResolveFractionals('5') ...
--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)

December 15, 2008 at 8:43 pm

#912905
RE: Are the posted questions getting worse?

Heh... here's my twit for the week... gotta love the arrogance...
http://www.sqlservercentral.com/Forums/Topic619172-1291-1.aspx#619380
--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)

December 15, 2008 at 6:37 pm

#912886
RE: Filling in blanks

sognibene (12/15/2008)
Thanks, Jeff. I was wondering what I was going to have for dinner tonight.
Heh... mmmmmm... p-o-r-k c-h-o-p-s... gaaaahhhh... 😛
--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)

December 15, 2008 at 6:20 pm

#912885
RE: Guest Editorial: On writing SQL

rbarryyoung (12/15/2008)
One thing that I have started to do in the last two years that I have found to be very helpful is to include test commands in the comments...
--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)

December 15, 2008 at 6:16 pm

#912884
RE: Help me in this question

You'll also find that it's absolutely necessary to keep from getting "false returns" in a GUI that may be interpretted as error messages, especially on triggers.
--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)

December 15, 2008 at 2:34 pm

#912813
RE: Help me in this question

yousef.am (12/14/2008)
I need to know what the following statement does:
set nocount on;
Save yourself some huge amounts of time in the future... learn to use Books Online, the "help system" 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)

December 15, 2008 at 2:32 pm

#912811
RE: Filling in blanks

Chris Morris (12/15/2008)
sognibene (12/15/2008)
At some point we're going to have to evaluate having a "permanent" tally table in the DB. For now, it's only used in reporting and since...
--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)

December 15, 2008 at 2:26 pm

#912808
RE: Are the posted questions getting worse?

Steve Jones - Editor (12/15/2008)
Just when I thought things couldn't get worse...
Well now that "depends"...
--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)

December 15, 2008 at 1:56 pm

#912787
RE: The Full Potential of SQL 2000

Heh...
ECHO "Hello World"
SELECT 'Hello World'
PRINT 'Hello World'
--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)

December 15, 2008 at 6:25 am

#912415
RE: PIVOT vertical table without Aggregating

Heh... you can't take the time to make a dozen insert statements and a create table statement to help me help you... good luck.
--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)

December 15, 2008 at 4:42 am

#912374
RE: Should I index staging tables?

Impossible to tell from what you've described.
--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)

December 14, 2008 at 8:55 pm

#912291
RE: Are the posted questions getting worse?

Heh... oh, you said "crap"... 😀
--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)

December 14, 2008 at 8:46 pm

#912289

Viewing 15 posts - 46,606 through 46,620 (of 59,101 total)