Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,906 through 52,920 (of 59,098 total)

RE: New Company, new DBA Tools budget, can you recommend any?

Paul Bakker (1/16/2008)
Does anyone have experience with the freeware version of SqlSafe? Can this product safely used in a production enviroment?
Heh... freeware...
My recommendation is that you read the license...
--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)

January 16, 2008 at 7:12 am

#768634
RE: Query for work shift differential

Samuel Vella (1/16/2008)
Jeff,
(Did you miss my earlier posts?)
Case would be a lot easier for very simple examples but sometimes @nbr is derived and for clarity/optimization it would be better 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)

January 16, 2008 at 6:58 am

#768625
RE: SQL - Derived Tables

Hey Prashant...
You remember I said "don't let it dampen your writing spirit"? Here's why... like I said, you have some good information in your article and people have already...
--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)

January 16, 2008 at 6:43 am

#768610
RE: SQL - Derived Tables

...and everything happens in memory instead of a combination of memory and disk.
...while a temporary table exists until the server is brought down and also it uses lot of disk...
--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)

January 16, 2008 at 12:44 am

#768480
RE: Exporting to a fixed length FF with varying record lengths

You bet, Jeremy... thanks for the feedback. Just remember... if you have lots of data, BCP with a format file will absolutely scream compared to this concatenation method.
--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)

January 16, 2008 at 12:27 am

#768479
RE: Performance of Scripts in SQL Server 2000

Crud... guess I need to start another rant! This forum won't allow me to post a "backslash-n" even in the code window. Line 188 of the BCP format...
--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)

January 16, 2008 at 12:16 am

#768476
RE: Performance of Scripts in SQL Server 2000

Well.... I should have known better... as soon as I saw that it was a Government agency, I should have known that the record layout they provided wasn't going 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)

January 16, 2008 at 12:08 am

#768474
RE: Tracking Illicit Users

David.Poole (1/15/2008)
LICH (1/15/2008)
Also "Analyser" should be "Analyzer"
Not if you're British it shouldn't.
Well, at least not until we've had a couple of "P's & Q's" 😀 Got beer? :w00t:
--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)

January 15, 2008 at 7:12 pm

#768433
RE: Some are just awful...

Of course... but I guess I'd rather keep it professional (or at least try to salvage some semblance of professionalism on my part after my initial outburst) by not citing...
--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)

January 15, 2008 at 7:05 pm

#768430
RE: returning data for a given month

That would be the one... they're pretty smart making it a new datatype... will actually keep 23:59:59.997 code from breaking... unless it's used on the wrong column type.
--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)

January 15, 2008 at 5:57 pm

#768419
RE: LTRIM linked field

Heh... glad someone occasionally gets a laugh out of those... 😛
More on the serious side... the "Bat with a nail in it" is actually a metaphore for what I do...
I'll...
--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)

January 15, 2008 at 5:24 pm

#768414
RE: Exporting to a fixed length FF with varying record lengths

Right idea but no need for the loop...
SELECT CAST(varchara AS CHAR(10))
+ CAST(varcharb AS CHAR(255))
+ CAST(varcharc AS CHAR(50))
...
--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)

January 15, 2008 at 4:58 pm

#768408
RE: New Company, new DBA Tools budget, can you recommend any?

GSquared (1/15/2008)
A bat with a nail? How primitive! I want a taser, preferably with a laser-sight on it (even if it doesn't work at a distance)! I...
--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)

January 15, 2008 at 4:45 pm

#768404
RE: Query for work shift differential

Wouldn't this be easier?
SELECT CASE
WHEN @Nbr > 0 THEN @Nbr
...
--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)

January 15, 2008 at 4:41 pm

#768403
RE: Updating values in one table from another table

Govind (1/15/2008)
Thanks Charlie! Yes, ofcourse this works.. But, here am looking to move the things fast.. There are 56 columns each in both the tables and I need to update...
--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)

January 15, 2008 at 4:34 pm

#768399

Viewing 15 posts - 52,906 through 52,920 (of 59,098 total)