Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,201 through 37,215 (of 59,098 total)

RE: How many rows were inserted?

r.vanlaake-1086273 (8/21/2010)
ok, thanks!!!
Ray
You say that but which suggestion did you follow? Some of these suggestions use a deprecated command and some won't give you what you want via code,...
--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)

August 21, 2010 at 1:11 pm

#1210059
RE: help me to select ROW_NUMBER in sql server 2000

I disagree with the idea of NOT using an IDENTITY for such a purpose if it's on a Temp Table.
--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)

August 21, 2010 at 1:07 pm

#1210057
RE: Date Conversion Fills the Transaction log

GilaMonster (8/21/2010)
He's not.
Heh... crud... I missed that. Thanks, Gail.
--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)

August 21, 2010 at 11:39 am

#1210051
RE: Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

wardster (8/21/2010)
In Mel's example in the original article, he deletes from his staging table after committing the transaction which inserts into the target table and updates the source table, and...
--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)

August 21, 2010 at 11:32 am

#1210048
RE: XP_cmdshell DIR

chrs-513176 (8/20/2010)
Jeff -
I adapted your code above and it works most of the time except when I want to get the size of compressed backup files created by Quest LiteSpeed....
--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)

August 21, 2010 at 11:24 am

#1210047
RE: The Joy of Numbers

_ms65g_ (8/17/2010)
Hi,
Here is a new approach for splitting a delimited string. It is set-based, without CHARINDEX, using number table…
See:
DECLARE @s-2 VARCHAR(620)='item_01,item_02,item_03';
SET @s-2 = ','+ @s-2 + ',';
;WITH C AS
(SELECT n,...
--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)

August 21, 2010 at 11:11 am

#1210046
RE: Performance tuning

subha.msc2007 (8/21/2010)
Hi,
i will give you the brief introduction about the performance issues.
1. connectivity problems &
2. Database tuning issues
Database tuning issues 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)

August 21, 2010 at 10:53 am

#1210045
RE: Linking to the Previous Row

Zeev Kazhdan (8/21/2010)
... but I wonder, what would be a performance using this PREV and NEXT join statements, as well as to ask
if there is any faster way to implement...
--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)

August 21, 2010 at 10:48 am

#1210043
RE: Linking to the Previous Row

philmond (8/20/2010)
Could you please tell me what's the advantage of using CTE and ROW_NUMBER() over a mush more intuitive temporary table with an IDENTITY(1,1) field?
IMHO... Just a tiny bit of...
--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)

August 21, 2010 at 10:38 am

#1210042
RE: Last Day of Month subscription for Shared SSRS schedule

That's what I'm talking about... You have the Users and the Subscription service (whatever that is for you) calling the same proc and you're running into trouble.
The "final" proc...
--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)

August 21, 2010 at 10:32 am

#1210041
RE: help needed in code tuning.

GilaMonster (8/20/2010)
Jeff Moden (8/20/2010)
Comment withdrawn. I couldn't find the MS reference that I remember seeing to support what I said so I've withdrawn my comment.
Now I'm curious......
--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)

August 21, 2010 at 10:11 am

#1210039
RE: From Zero to SSIS! Learning SQL Server Integration Services

Steve Jones - Editor (8/20/2010)
Ha, where's the argument in that 🙂
I don't know if Andy's the best, but he's pretty good. Course, being a fellow Southerner, I like listening 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)

August 21, 2010 at 9:46 am

#1210036
RE: Dates from Calendar control

Riskworks (8/20/2010)
Interesting. When I convert to date the code does not throw the error, but it is still not picking up the June 30, 2010 3:00 row. ...
--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)

August 21, 2010 at 9:43 am

#1210035
RE: Deprecated form of CROSS JOIN

Thanks for the help, folks. I just wanted to make sure I wasn't missing something in the deprecation lists. I appreciate your time.
--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)

August 21, 2010 at 9:39 am

#1210033
RE: Date Conversion Fills the Transaction log

Oh yeah. Almost forgot. Since the formula is "deterministic", a lot of folks may be tempted to make the computed column PERSISTED. That will take just 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)

August 21, 2010 at 9:36 am

#1210032

Viewing 15 posts - 37,201 through 37,215 (of 59,098 total)