Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,886 through 39,900 (of 59,098 total)

RE: Architecture Principles

Heh... no, I didn't miss a thing when I said "execute only the code that needs to be executed." One of the guys at my old job decided 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)

February 6, 2010 at 9:18 pm

#1115139
RE: DBCC Timewarp

The Dixie Flatline (2/6/2010)
Thank you for that helpful information, George. I apologize.
Can someone tell me if it makes a difference whether or not the new servers occupy 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)

February 6, 2010 at 8:18 pm

#1115133
RE: DBCC Timewarp

CirquedeSQLeil (2/6/2010)
The Dixie Flatline (2/6/2010)
Fine then, Mr. Wings-On-Your-Hat-And-Feet-Man with the vaguely French name.
I'll just get my answer off Twitter.
I wave my subatomic particles at all of your...
--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)

February 6, 2010 at 8:16 pm

#1115132
RE: Democratizing the Microsoft MVP Award

Voting by the general public smacks of a popularity contest rather than a public service award (which is what being an MVP is really all about). If you really...
--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)

February 6, 2010 at 7:19 pm

#1115128
RE: Democratizing the Microsoft MVP Award

Heh... you beat me to it, Liz. I was thinking that very same thing.
--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)

February 6, 2010 at 7:13 pm

#1115124
RE: How to display a columns current row and next row value in single select query?

Sorry... I missed copying the last criteria which broke the code. The following works and I'm taking CPR (cut, paste, replace) lessons tomorrow.. 😛
WITH
cteNumbered AS
(
SELECT ROW_NUMBER() OVER (ORDER...
--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)

February 6, 2010 at 5:56 pm

#1115113
RE: How to display a columns current row and next row value in single select query?

In case someone needs it, here's the test data I used...
--===== Conditionally drop the test table in case we need to rerun
IF OBJECT_ID('TempDB..#TestTable') IS 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)

February 6, 2010 at 5:21 pm

#1115108
RE: How to display a columns current row and next row value in single select query?

Sorry... made a mistake and had to erase this post. I'll be 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)

February 6, 2010 at 5:13 pm

#1115106
RE: need script to generate load on tempdb databse!!!

sanketahir1985 (2/1/2010)
Hi friends
can any buddy provide script to generate load on tempdb database in sql 2005.
Heh... generate a load? Shoot... run one or two of the following... this...
--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)

February 6, 2010 at 2:44 pm

#1115087
RE: Best code for generating sequence numbers

peter-970097 (2/5/2010)
Thank you for the feedback
Agreed, the IDENTITY column works fine for creating a unique RECNUM ID, but this type of process is required when creating a 'unique' sequential number...
--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)

February 6, 2010 at 1:45 pm

#1115072
RE: Remove non printable characters

Grinja (2/5/2010)
Hi,
Is there an equivilent function to Excel's 'CLEAN' in SQL to remove non printable characters?.
Thanks,
G
I believe this will do it for you...
CREATE FUNCTION dbo.RemoveNonDisplayChars
/********************************************************************
Purpose:
Remove the non-displayable...
--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)

February 6, 2010 at 12:15 pm

#1115052
RE: Remove non printable characters

My apologies, Ramesh. I should have qualified my statement. Instead of saying...
"I believe you'll find it's a wee bit more difficult to do than just using REPLACE."
......
--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)

February 6, 2010 at 11:47 am

#1115040
RE: DBCC Timewarp

The Dixie Flatline (2/5/2010)
Jeff, is that new in 2008, or would it work for 2005 as well?
If memory serves, parameter one is PI to 8k decimal places.
It was deprecated in...
--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)

February 6, 2010 at 8:55 am

#1115013
RE: Converting data with apostrophes in it

Luke L (2/5/2010)
what I would do is create a stored procedure...
Heh... sorry Luke. I missed what you said above. Good to have a backup, though. 🙂
--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)

February 6, 2010 at 8:54 am

#1115012
RE: Table Variable Issue

The Dixie Flatline (2/5/2010)
You got me, Jeff. Me and table variables were just a summer thing, y'know. That said, any time someone has the ah-hah!...
--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)

February 6, 2010 at 8:52 am

#1115011

Viewing 15 posts - 39,886 through 39,900 (of 59,098 total)