Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,586 through 42,600 (of 59,067 total)

RE: IF Statements affecting performance ?

GilaMonster (8/1/2009)
Jeff Moden (8/1/2009)
It would be a great addition to your blog but it would also make a hellofa nice article for SSC, too!
Maybe what I'll do is blog 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)

August 1, 2009 at 2:38 pm

#1033398
RE: Be a Craftsman

Man, you're on a roll with great topics and write-ups about those topics.
In Jeff Attwood's article, he posted "what we do is craftsmanship, not engineering" and I have to take...
--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 1, 2009 at 2:03 pm

#1033393
RE: How to comment out the step in the sql job

I'm doing great. Thanks for asking.
You also told me that I should write books on SQL way back then. I'm actually in the process of writing one. ...
--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 1, 2009 at 1:27 pm

#1033390
RE: Convert Multiple rows into one using unique field

Thanks for the feedback, Labneh. We aim to please... we sometimes miss but we we're still aiming. 😀
--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 1, 2009 at 1:16 pm

#1033388
RE: Uptime = Downtime? (Database Weekly, Aug 3, 2009)

This is a good subject. The military realized the fallacy of "If it ain't broke, don't fix it." a long, long time ago. Daily, weekly, monthly, quarterly, yearly,...
--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 1, 2009 at 1:08 pm

#1033384
RE: Migrating Foxpro database programs to SQL 2005

With the exception of the occasional view or UDF, I'd say write everything into stored procedures and use scripts or a GUI to call them. You can also create...
--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 1, 2009 at 12:48 pm

#1033380
RE: Store Proc Error

It's more than just that... you also have to quote encapsulate the dates...
SELECT QUOTENAME(GETDATE(),'''')

ALTER PROCEDURE TraceReport
@server varchar(6),@FromDate datetime,@ToDate datetime
AS
BEGIN

SET NOCOUNT ON;

EXEC('SELECT databasename,starttime,eventclass,LoginName,TargetUsername,Objectname
FROM ' + @server + '.TRACEDB.dbo.TraceTable where starttime between...
--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 1, 2009 at 12:42 pm

#1033378
RE: How to comment out the step in the sql job

You can't comment out the step but you can comment out the code it runs. Use whatever constitutes a comment or rem for whatever type of code the block...
--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 1, 2009 at 12:30 pm

#1033374
RE: Purchase of SQL Server 2005 Developer Edition

Set your mind at ease, the Developer's Edition is identical the the full blown Enterprise Edition except for the licensing restristictions and the operating systems it can run on. ...
--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 1, 2009 at 12:27 pm

#1033373
RE: Are the posted questions getting worse?

Allister Reid (8/1/2009)
I thought someone might try to unpick what he was doing to try to help with the bigger picture...
I did just exactly that. I'm not sure...
--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 1, 2009 at 12:19 pm

#1033369
RE: IF Statements affecting performance ?

Ah! Got it. Thanks for taking the time to explain. Heh... it's funny... I knew that could be the case in a single query but I wasn't...
--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 1, 2009 at 12:15 pm

#1033368
RE: Select Statement Performance

Just from a practical standpoint, the less you select, the fewer bytes need to make it across the pipe, go through implicit conversions, etc, etc. If you don't need...
--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 1, 2009 at 11:13 am

#1033362
RE: IF Statements affecting performance ?

Heh... nope. I knew that and I've asked the question incorrectly... What I should have as about the following is...
GilaMonster (8/1/2009)
Jeffrey Williams (7/31/2009)
I don't think IF statements are...
--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 1, 2009 at 10:11 am

#1033359
RE: Date conversion

Tejas Shah (8/1/2009)
I face this problem in one of my project's reports, so I keep practice to not convert the field.
I actually agree. Formatting dates and times in T-SQL...
--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 1, 2009 at 9:46 am

#1033357
RE: differiniate quotes as data vs quotes as column identifier

You bet... thanks for the feedback, Ghanta.
--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 1, 2009 at 9:34 am

#1033356

Viewing 15 posts - 42,586 through 42,600 (of 59,067 total)