Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,856 through 39,870 (of 59,072 total)

RE: AutoNumber Column

Sounds like an interview or homework question.
You can use ROW_NUMBER() OVER(ORDER BY...) without having to store it in a table or sub-query...
SELECT ROW_NUMBER() OVER (ORDER BY Pros_name) AS RowNum,
...
--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:49 pm

#1115144
RE: Distributed Transaction?

I'm not sure if this is the problem or not but make sure that MSDTC is running correctly on both machines.
--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:43 pm

#1115142
RE: Trigger not working as expected during batch update

bobbevers (2/6/2010)
I have this trigger on a table that I am told is getting updated through batch updates.
ALTER TRIGGER [dbo].[UpdateLastComm]
ON [dbo].[RTD_Latest]
AFTER UPDATE
AS...
--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:32 pm

#1115141
RE: Best code for generating sequence numbers

peter-970097 (2/6/2010)
Thanks Jeff for the informative reply.
Independently of this blog, we very quickly canned any further thought on ISOLATION LEVEL et aliter
All the tests we did with this were catastrophic!
We...
--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:24 pm

#1115140
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

Viewing 15 posts - 39,856 through 39,870 (of 59,072 total)