Jeff Moden

Forum Replies Created

Viewing 15 posts - 46,021 through 46,035 (of 59,095 total)

RE: Where 1 = 1

Heh... But, it won't solve a bloody thing and it won't prevent the problems that you describe... people will simply get into the habit of adding WHERE 1=1 and still...
--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 9, 2009 at 4:41 pm

#924697
RE: Inserting a value in an ordered string

Ah... that's a slightly different story. Am I to assume that you want the digit to be inserted in the correct ascending numerical order... in other words, the 7...
--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 9, 2009 at 4:05 pm

#924677
RE: Cursors Be Gone!

Matt Whitfield (1/9/2009)
So, collectively we fixed a logic funny for you, and made it quicker to boot.
Go team! 😛
"Go Team" is right!
If I may, please consider what...
--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 9, 2009 at 3:59 pm

#924671
RE: Inserting a value in an ordered string

Heh...bwa-heh... BWAAA-HAAA!!! Hey, Sergei... STUFF it will ya? :P:D:)
Oh dear... couldn't resist the pun. Seriously, though... that's the answer... see here...
DECLARE @SomeExistingString VARCHAR(100),
...
--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 9, 2009 at 3:07 pm

#924641
RE: Are the posted questions getting worse?

Jack Corbett (1/9/2009)
Grant Fritchey (1/9/2009)
Jack Corbett (1/9/2009)
Steve Jones - Editor (1/9/2009)
I'm with Grant, heat, heat, heat.
I like skiing, but other than that, I'd like warm weather all the time.
Denver doesn'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)

January 9, 2009 at 2:46 pm

#924620
RE: Very new Newbie Needs Help with simple query

Yeah... that's one thing that Oracle does do better... some of the implicit conversions. If you look in Books Online (comes with SQL Server as the help system)...
--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 9, 2009 at 2:41 pm

#924613
RE: Virtualization forum section

It's there... just doesn't look that way because (sorry) ... it's virtual. 😛
Actually, it sounds like a good idea. The boys in ops just virtualized all of our...
--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 9, 2009 at 2:31 pm

#924606
RE: Look at the size of my BCHR

BWAA-HAAA!!! "I'll show you mine if you show me yours."
I've never looked, but I'm just betting that the BCHR is nearly 100% for cursors... 😉
--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 9, 2009 at 2:23 pm

#924600
RE: Where 1 = 1

GSquared (1/9/2009)
I've seen requests to Microsoft to make having a Where clause on every query be required, with the solution to unrestricted queries that they could have something like "Where...
--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 9, 2009 at 2:19 pm

#924596
RE: Grouping rows together

In that case... see this... especially the last part where the performance tests were done...
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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 9, 2009 at 1:55 pm

#924571
RE: SQL Server 2000 problem

EdVassie (1/7/2009)
I had this on a SQL 2000 box some years back. The ultimate fix for my problem was to add a -g startup parameter to leave more memory...
--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 9, 2009 at 1:48 pm

#924564
RE: Datediff not calculating corectly

I was just getting ready to comment on how much Lynn's complexion has improved. 😛 Barry still has to wear his helmet to hide his...
By the way... where'd...
--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 9, 2009 at 1:31 pm

#924548
RE: The New Year - 2009

BWAA-HAA!!! I guarantee Business Intelligence won't take off because it's an oxymoron... government gives 700 billion to banks and can't account for any of it... big 3 are going...
--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 9, 2009 at 1:28 pm

#924543
RE: Update table without cursors and Temp tables , in a single query

That's absolutely the way to do it... but, I'd be tempted to just drop the ID column and add it back in as an IDENTITY column. When you add...
--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 9, 2009 at 12:43 pm

#924502
RE: Auto Creation and Insertion Of Table Through Executing Procedure

If I read you right, you want to use the output of a given stored procedure as input to another table. There are several ways to accomplish that......
--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 9, 2009 at 12:22 pm

#924487

Viewing 15 posts - 46,021 through 46,035 (of 59,095 total)