Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,346 through 39,360 (of 59,072 total)

RE: Attribute to identify system databases

Steve Jones - Editor (3/13/2010)
... and if MS listens, I hope we get a tempdb for each db
Lordy, I hope that doesn't happen. Imagine trying to correctly size all...
--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)

March 13, 2010 at 5:22 pm

#1133264
RE: Are the posted questions getting worse?

WayneS (3/13/2010)
Paul White (3/12/2010)
Jeff Moden (3/12/2010)
We're rootin' for ya!
* snigger *
See the entry for root here
Isn't it amazing how one perfectly innocent term in one culture means something completely different...
--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)

March 13, 2010 at 5:13 pm

#1133263
RE: select random records but for each category

They key to simplicity (and, therefor, future maintainability) for this problem is that you have to know how many of each vehicle type to return BEFORE you try to select...
--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)

March 13, 2010 at 9:45 am

#1133221
RE: select random records but for each category

Paul White (3/12/2010)
As far as I can see, the previously posted code doesn't meet the requirement to select a minimum of three rows, a maximum of 25, and 10% of...
--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)

March 13, 2010 at 8:58 am

#1133214
RE: How to select in this case - very complex SQL

Please read the article at the first link in my signature below. You'll get better help. A description of what you want to actually accomplish would also be...
--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)

March 13, 2010 at 8:42 am

#1133212
RE: CURSORS

gilbert delarosa (3/12/2010)
Each of my clients has its own database with all of the same obects. I often have to query data for all clients for internal reports. I have...
--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)

March 12, 2010 at 9:44 pm

#1133123
RE: Attribute to identify system databases

{Edit} Didn't see Paul's post... Paul has it 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)

March 12, 2010 at 9:38 pm

#1133120
RE: Is it possible...

Steve Jones - Editor (3/12/2010)
I don't think there's a way to be sure of the last date, but you can disable logins and then see if someone complains.
Heh... disable 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)

March 12, 2010 at 9:32 pm

#1133118
RE: Query timeout, High DiskIO & low page life expectancy

Please see the article at the second link in my signature line below. 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)

March 12, 2010 at 9:30 pm

#1133117
RE: Eliminating Timeouts

sqlislife (3/12/2010)
How can a midsized company such as ours go about eliminating timeout caused by users. Is it possible? Anything causes timeouts from jobs running simultaneously as server requests to...
--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)

March 12, 2010 at 9:28 pm

#1133114
RE: Manipulate Date Output

monitor89 (3/12/2010)
I have YYYYMMDD stored in dob column in table h.
The line below gives me MMDDYYYY
substr(h.dob,5,2) || right(h.dob,2) || left(h.dob,4) as Birth_Date,
What should I change/add to insert slashes into 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)

March 12, 2010 at 9:24 pm

#1133113
RE: sql server stored procedure

r.vijaykanth (3/12/2010)
i want to create a stored procedure
which takes tablename as input and returns table data as out put
Why? What is the business reason for this?
--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)

March 12, 2010 at 9:21 pm

#1133112
RE: DBA Won't Allow Alter Table for Identity Insert

What is the nature of the data where you'd want to insert directly into an IDENTITY column?
--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)

March 12, 2010 at 9:13 pm

#1133109
RE: Are the posted questions getting worse?

Lynn only needs 37 more posts to become to only the 4th person to ever break the 10k post mark in the history of SSC. C'mon Lynn! We'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)

March 12, 2010 at 8:52 pm

#1133107
RE: Are the posted questions getting worse?

Lynn Pettis (3/11/2010)
CirquedeSQLeil (3/11/2010)
Jeff has quietly passed the 20,000 pt mark. No fanfare???
Congrats Jeff.
[font="Comic Sans MS"]Congratulations on passing 20,000, Jeff!![/font]
Heh... sorry I'm late for the party! 😛 ...
--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)

March 12, 2010 at 8:47 pm

#1133106

Viewing 15 posts - 39,346 through 39,360 (of 59,072 total)