Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,981 through 43,995 (of 59,101 total)

RE: Are the posted questions getting worse?

RBarryYoung (4/30/2009)
Chris Morris (4/30/2009)
@Barry - get well soon mate, that sounds like some horrible stuff you're dealing with. You will be hugely missed while you're away for the op.
Thanks, Chris....
--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)

April 30, 2009 at 10:44 am

#986778
RE: How to split one mdf file into two

DKG (4/30/2009)
Of couse this is not a good practive to take backup on DVDs
I'd say the jury is still out on that one for smaller systems. With compression, you...
--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)

April 30, 2009 at 10:29 am

#986765
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Well stated... but doesn't that show that embracing OOP took even longer for most folks? 😉 I believe that was the real point trying to be made. :hehe:
--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)

April 30, 2009 at 10:26 am

#986760
RE: Performance issue with tally solution

Florian Reischl (4/30/2009)
Jeff Moden (4/29/2009)
http://www.sqlservercentral.com/articles/T-SQL/63003/
Thanks Jeff!
Great article! Am I allowed to refer to?
Greets
Flo
Absolutely.
I also have some code for you on cleaning a string. I've repaired the performance problem...
--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)

April 30, 2009 at 10:22 am

#986757
RE: UPDATE column with auto number depending on field value ?!

DECLARE @counter int
SET @counter = 0
UPDATE custom.table1
SET @counter = table1.number = @counter+1
Also, since you got that to execute previously, you may have to add an "anchor" column and it should...
--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)

April 30, 2009 at 10:18 am

#986754
RE: UPDATE column with auto number depending on field value ?!

m.berggren (4/30/2009)
Hi, i tried this one but i got some syntax errors again. It´s complaining about the "=" in row 4. Maybe beacuse this is written in Sybase (interactive 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)

April 30, 2009 at 10:16 am

#986753
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

greatheep (4/29/2009)
Unfortunately, it doesn't work out that way - we tried a single set based approach originally, and we almost always had the whole thing roll back due to concurrency...
--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)

April 29, 2009 at 11:59 pm

#986446
RE: Problem: Equal Checksums for different values

The problem is that CheckSum_Agg just does a simple XOR. You can cheat... it's no guarantee, but it's more likely to find something different...
DECLARE @CS1 bigint
SET @CS1 =...
--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)

April 29, 2009 at 11:41 pm

#986436
RE: Looping SQL Process To Select n rows from SQL Table

It would be a whole lot easier if you could use xp_CmdShell and BCP in a T-SQL loop. Are you allowed to use xp_CmdShell?
--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)

April 29, 2009 at 10:55 pm

#986418
RE: Sending Table to CLR stored procedure

Just curious... what will this CLR Stored Procedure do?
--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)

April 29, 2009 at 10:26 pm

#986415
RE: Performance issue with tally solution

Heh... oh my... someone is as crazy as I. Ya gotta be to know songs like 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)

April 29, 2009 at 10:20 pm

#986414
RE: Auditing Jobs in SQL

I ran into a server that had that many jobs, once. I disabled them all (except for know server maintenace) and would only turn them back on if someone...
--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)

April 29, 2009 at 9:07 pm

#986394
RE: UPDATE column with auto number depending on field value ?!

Bob Griffin (4/29/2009)
This logic would require some kind of looping to work. You also need a where clause in your update. Probably use a subselect for your...
--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)

April 29, 2009 at 8:58 pm

#986391
RE: UPDATE column with auto number depending on field value ?!

john.arnott (4/29/2009)
Now, if we're lucky, someone can help us figure out a single pass solution.
Use two counters and a case statement in the SET.
--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)

April 29, 2009 at 8:56 pm

#986390
RE: UPDATE column with auto number depending on field value ?!

m.berggren (4/29/2009)
DECLARE @counter int SET @counter = 1 UPDATE custom.table1 SET @counter = table1.number = @counter+1
The problem with that is that you've included the table schema in the set clause. It should...
--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)

April 29, 2009 at 8:54 pm

#986388

Viewing 15 posts - 43,981 through 43,995 (of 59,101 total)