Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,091 through 39,105 (of 59,098 total)

RE: Creating Indices on Temp Tables from Stored Procedures

The Dixie Flatline (3/26/2010)
If a report is run once or twice a day, and you can take the runtime down to 10 seconds instead of several minutes, is it really...
--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 4, 2010 at 1:53 pm

#1145506
RE: Options for dealing with table Contention

(Way too much code involved in modifying them and it's not mine, it's a third party vendor's)
My first inclination is to invite the officers of the third party vendor's...
--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 4, 2010 at 1:09 pm

#1145500
RE: Which value should we use as a PK auto incremented or padded value???

Paul White NZ (4/4/2010)
sumit.joshij (4/3/2010)
While maintaining a database which values should we use as a PK. is it preferable to use auto incremented or our self generated padded values
say...
--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 4, 2010 at 12:04 pm

#1145487
RE: Using second SQL server for running reports

keith.littlejohn (4/1/2010)
I am running SQL 2005 Ent edition. We have an application that runs on our SQL 2005 server and when users try to run reports off that database,...
--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 4, 2010 at 11:53 am

#1145486
RE: Foreign key constraints...WHY??

PaulB-TheOneAndOnly (4/4/2010)
david_wendelken (4/4/2010)
I start with the premise that the data is supposed to be valid. That's, on occasion, NOT a business requirement at all. (Sometimes the business requirement...
--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 4, 2010 at 11:15 am

#1145480
RE: DateTime input with time always at 00:00:00.0000

Paul White NZ (4/3/2010)
Paul White NZ (3/22/2010)
Same goes for the CHAR conversion (if done with a deterministic style) and FLOAT (2008 only).
^^^ Hey Jeff 😉 ^^^
Hey Paul...
-- Persisting whole_date2 only...
--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 3, 2010 at 11:20 am

#1145361
RE: Removing duplicates and keeping 1 record with no PK

lmu92 (4/3/2010)
olie480 (4/2/2010)
Jeff Moden (4/2/2010)
Deleting data that is supposedly duplicated by FirstName and LastName is a very good way to have a sudden and very unwelcome career change. There...
--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 3, 2010 at 11:19 am

#1145360
RE: Speeding up a fast forward cursor proc

Paul White NZ (4/3/2010)
Jeff Moden (4/2/2010)
Heh... jeez... doesn't anyone use a plain ol' zip file anymore? 😉
RAR is a great choice - after all, it doesn't take 10 minutes 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)

April 3, 2010 at 11:14 am

#1145359
RE: Output columns from lowest to highest in a pivot type query help

Garadin (4/2/2010)
I've read several of that guys articles, good stuff. 😉
Heh... thanks, Seth. Good finish to a long day.:-)
--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 2, 2010 at 10:31 pm

#1145220
RE: Selecting list of month numbers between two dates

Ok... thanks for the feedback.
--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 2, 2010 at 10:29 pm

#1145219
RE: The Missing Certification

Gosh... :blink: You would think that an MCM would be required to know how to distinguish between good code and bad code as part of some sort of "performance...
--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 2, 2010 at 9:28 pm

#1145212
RE: The Missing Certification

Heh... I just read Jason's blog about this thread and he talked a little about the price of getting an MCM.
Certification just shouldn't cost that much... it excludes...
--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 2, 2010 at 9:10 pm

#1145209
RE: Selecting list of month numbers between two dates

🙂
--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 2, 2010 at 9:03 pm

#1145204
RE: Output columns from lowest to highest in a pivot type query help

You'll need a bit of dynamic SQL to do what you want. Just so happens, I know a place that has an example...
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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 2, 2010 at 8:59 pm

#1145201
RE: very busy disk

Do you have a virus scanner running on the 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)

April 2, 2010 at 8:56 pm

#1145200

Viewing 15 posts - 39,091 through 39,105 (of 59,098 total)