Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,526 through 42,540 (of 59,067 total)

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
RE: Gain Space Using XML data type

Steve Jones - Editor (8/4/2009)
It's an interesting look from a developer point of view. Compared to the power and speed of the relational engine, I think space savings are a...
--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 3:54 pm

#1034549
RE: Gain Space Using XML data type

Paul White (8/4/2009)
This script is closely based on that in the article.
I would strongly encourage the author of this article to try it out 🙂
Nice idea for an article, but...
--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 3:51 pm

#1034548
RE: Uptime = Downtime? (Database Weekly, Aug 3, 2009)

umailedit (8/3/2009)
" It's why we win wars... "
We do?
I always thought in software it is a golden rule not fallacy. 'if it ain't broke don't fix it'. Maybe 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)

August 4, 2009 at 3:10 pm

#1034539
RE: Looking for advice on calendar scheduling

smunson (8/3/2009)
If you can supply some sample data and table structures (see Jeff Moden's signature for details on how to best do that), we can help you get the code...
--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 2:36 pm

#1034524
RE: Split a result by commas

purplebirky (8/3/2009)
in this table one column has entrys that look like : res1, res2, res3
well i need to split these out to return each on it's own.
purplebirky,
See the article 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)

August 4, 2009 at 2:18 pm

#1034518

Viewing 15 posts - 42,526 through 42,540 (of 59,067 total)