Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,756 through 52,770 (of 59,098 total)

RE: Performance of Scripts in SQL Server 2000

Whitt (1/23/2008)
Jeff,
Really sorry for the delay. I'm being shifted from fire to fire here. I haven't had time to run this as I've been moved to helping with...
--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 23, 2008 at 8:31 pm

#771135
RE: Listing gaps in numeric sequences

We'll I'll be... just tried the CTE equivelent of how I build Tally tables (NO, NO RECURSION PLEASE! 😛 ) on the same example data... it does surprisingly well! ...
--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 23, 2008 at 8:20 pm

#771132
RE: Listing gaps in numeric sequences

I gotta agree with Kenneth... and, I'll throw in that CPU time matters as well. I thought the example code I posted that didn't use a Tally table would...
--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 23, 2008 at 7:40 pm

#771125
RE: Extended Stored procedures - SQL 2000

Not only should you get the BIG Manager to put it in writing, but you should make a full backup of the 4 system databases, which includes the Master 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)

January 23, 2008 at 6:54 pm

#771118
RE: Issue with date field calculations

don't really see the point of an unique index with ignore duplicates on. Am I missing something?
It's a cheater method for removing dupes during a Bulk Insert or BCP.
...
--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 23, 2008 at 6:43 pm

#771116
RE: A Reporting System Architecture

It was, indeed, a good post!
Just an FYI... I'm not sure how to do it myself, but the hardware boys in our shop found out that the EMC Clarion is...
--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 23, 2008 at 6:35 pm

#771113
RE: Insert a string into a temp table

djiang (1/23/2008)
Hi Guys,
I'm trying to insert a string into a temp table. For instance I want a nvarchar(4000) string
@Ids inserted as separte Ids in a All_id table.
The user can 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 23, 2008 at 6:12 pm

#771112
RE: Do an UPDATE using a LEFT OUTER JOIN

From the description, the code looks correct... did you try 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)

January 23, 2008 at 4:40 pm

#771102
RE: What's wrong with this expression? (@[User::InsurerID] == 101 ? "47")

I guess I don't understand... if a conditional expression will always result in TRUE, why have the conditional expression to begin with? What am I missing here? Keep...
--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 23, 2008 at 4:29 pm

#771101
RE: Import from Flatfile with rows that have different format...

Nice reference link, Todd... thanks.
--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 23, 2008 at 7:28 am

#770906
RE: Listing gaps in numeric sequences

I was thinking the same thing... 😉
Also, Matt... your the Ninja on Regex... is there anyway to use Regex for such a thing as this import?
--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 23, 2008 at 7:26 am

#770902
RE: Stripping out double quotes (") in bulk insert

Very cool... with your great instructions, I'll just bet I learn something new! Thanks, Adrian...
I'll bet the OP will like it, as well!
I'll still take a brute force...
--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 23, 2008 at 7:11 am

#770896
RE: Listing gaps in numeric sequences

And, I haven't done the comparison lately, but I believe the first method I showed will be the pants off most outer join methods...
--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 23, 2008 at 7:06 am

#770891
RE: Listing gaps in numeric sequences

Absolutely agree... if the numbers table is large enough... if it's not, then you can do something like the following...
... Also, in 2k5, you really don't need a recursive CTE...
--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 23, 2008 at 7:04 am

#770890
RE: Deleting

Thanks for the feedback, Phil. Really appreciate your comments.
By the way (almost forgot)... they haven't fixed the code windows on this forum, yet. If you just copy 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)

January 23, 2008 at 6:51 am

#770874

Viewing 15 posts - 52,756 through 52,770 (of 59,098 total)