Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,616 through 42,630 (of 59,102 total)

RE: Store Proc Error

Actually, this is the way I write code at work... it makes debugging much, much easier...
ALTER PROCEDURE TraceReport
@server ...
--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 2, 2009 at 10:52 am

#1033451
RE: Store Proc Error

Ah crud... sorry Tara... I forgot that EXEC will only take constants and variables as operands. It won't take functions. For example...
EXEC('SELECT ' + SQRT(4))
... fails just like...
--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 2, 2009 at 10:49 am

#1033450
RE: Be a Craftsman

David Korb (8/1/2009)
...because you may end up maintaining CLR routines on SQL Server.
Heh... just having a little fun here... if you know T-SQL well enough, there isn't a need 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)

August 2, 2009 at 10:03 am

#1033445
RE: Purchase of SQL Server 2005 Developer Edition

freens77 (8/1/2009)
Jeff, thanks for your reply. I had believed and hoped that was the case. Thanks for eliminating that concern for me. 🙂
Cheers.
No problem and Lowell is correct......
--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 6:18 pm

#1033413
RE: Be a Craftsman

So long as Microsoft isn't responsible for the certs. I see no reason to know how to write in C# if I'm going to be a DBA or Database...
--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 6:12 pm

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

Viewing 15 posts - 42,616 through 42,630 (of 59,102 total)