Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,556 through 42,570 (of 59,102 total)

RE: help with pulling values for multiple dates...

quayludious (8/4/2009)
Is there a better way than using the inner joins?
If I'm reading your code example correctly, the answer is "yes, absolutely". Please post the code for the function...
--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 4, 2009 at 9:54 pm

#1034614
RE: Using CURSOR

Just don't get the idea that you can use any ol' index to do this... It MUST be a clustered index.
--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 4, 2009 at 9:46 pm

#1034611
RE: Using CURSOR

willian (8/4/2009)
Hi, thanks for helping!
This code will process each row using @RESULT from one line to another?
I need take the @RESULT from atual row and use it on the next...
--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 4, 2009 at 9:41 pm

#1034609
RE: Building an API

Heh... still on a roll, Steve. Keep it going. I am, however, glad you changed your shirt from the last time.
I can't get over how many people are...
--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 4, 2009 at 9:35 pm

#1034606
RE: Primary Key- char 12

pzmrcd (8/4/2009)
Hi
We have an existing application that uses a table with a Primary ket tat has been set to char[12].
This was developed many years back and due to the...
--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 4, 2009 at 9:26 pm

#1034603
RE: Date Range within a Date Range

aktikt (8/4/2009)
The only way I've seen the tally table work is against variables. What if the value is in a table instead?
I'm all ears for anyone who can solve...
--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 4, 2009 at 9:22 pm

#1034602
RE: removing duplicate row values

Take just five minutes to help us help you. Please read the first link in my signature below. Provide a CREATE TABLE statement and data like in the...
--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 4, 2009 at 9:18 pm

#1034601
RE: Stored Procedures

Ummmmm.... see if you like the random numbers this gives you... includes some with leading zero's but will always have 13 to 15 digits...
SELECT TOP 100000
...
--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 4, 2009 at 9:10 pm

#1034600
RE: insert non duplicates, am i missing something here?

The code you presented works just fine with no indexes except on the Email columns. In order for us to figure this out, you'll need to post the table...
--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 4, 2009 at 8:53 pm

#1034596
RE: PeopleSoft searches go from 4 seconds to 20 seconds

Do you do any other maintenance? Like rebuilding fragmented indexes and the 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 4, 2009 at 8:40 pm

#1034592
RE: How did good DBAs become good DBAs

As some have said, buy a copy of the Dev Edition of SQL Server. It's the same as the Enterprise Edition except for two things... the license says you're...
--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 4, 2009 at 8:38 pm

#1034591
RE: SQL Server DB Slowness, AUTOGROWTH issue?

Nothing else runs while auto-growth is occurring and, yes, it will make a given task or set of tasks seem very slow while auto-growth occurs.
--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 4, 2009 at 8:23 pm

#1034589
RE: Gain Space Using XML data type

Paul White (8/4/2009)
@jeff: Thanks so much - have you noticed how many of my scripts have at least a passing resemblance to some you have posted in the past?...
--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 4, 2009 at 8:11 pm

#1034585
RE: Are the posted questions getting worse?

Jack Corbett (8/4/2009)
Guess everyone knew Gail was gone. Not many posts in the corruption forums.
Somehow, that just doesn't sound right. 😛
--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 4, 2009 at 4:19 pm

#1034558
RE: Are the posted questions getting worse?

Bob Hovious (8/4/2009)
Or we could just go back to flat files. Screw relational AND hierarchical databases.
At least it wouldn't have tags in it. 😉 Well... unless...
--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 4, 2009 at 4:10 pm

#1034555

Viewing 15 posts - 42,556 through 42,570 (of 59,102 total)