Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,116 through 14,130 (of 59,101 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, October 12, 2017 11:24 AM
Things need tuning for sure, though this is a third 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)

October 13, 2017 at 9:30 am

#1963592
RE: Scalar function syntax error

Luis Cazares - Thursday, October 12, 2017 9:15 AM
saintor1 - Thursday, October 12, 2017 9:01 AM
--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)

October 12, 2017 at 11:53 pm

#1963493
RE: Can't zero pad a variable

Phil Parkin - Thursday, October 12, 2017 9:04 AM
Jeff Moden - Thursday, October 12, 2017 8:54 AM
--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)

October 12, 2017 at 11:41 pm

#1963491
RE: Compression Script on existing tables in databases that handles the alters and indexes and tells how much savings?

quinn.jay - Thursday, October 12, 2017 8:19 AM
Jeff Moden - Wednesday, October 11, 2017 2:35 PM
--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)

October 12, 2017 at 10:59 am

#1963438
RE: Can't zero pad a variable

Phil Parkin - Thursday, October 12, 2017 6:01 AM
Jeff Moden - Wednesday, October 11, 2017 8:10...
--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)

October 12, 2017 at 8:54 am

#1963388
RE: What Pizzas do DBA's prefer?

Ed Wagner - Wednesday, October 11, 2017 8:04 PM
There are so many good types of pizza out there that it's hard 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)

October 11, 2017 at 11:43 pm

#1963312
RE: expecting ID or quoted_ID. Help!

p.s. You might want to exclude system databases from the return just to be safe.
--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)

October 11, 2017 at 11:14 pm

#1963310
RE: expecting ID or quoted_ID. Help!

Michael_O - Tuesday, October 10, 2017 9:32 AM
Thom A - Tuesday, October 10, 2017 9:01 AM
--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)

October 11, 2017 at 11:02 pm

#1963309
RE: Indexing strategy on a highly transient table

ScottPletcher - Tuesday, October 10, 2017 11:46 AM
giles.clapham - Thursday, October 5, 2017 10:43 AM
--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)

October 11, 2017 at 10:28 pm

#1963306
RE: Creating Stored Procedure

dreynolds 13587 - Wednesday, October 11, 2017 9:40 AM
If I understand your requirements correctly, this should do the job: Notice that 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)

October 11, 2017 at 10:12 pm

#1963305
RE: Having trouble displaying a date in a certain format...

chef423 - Wednesday, October 11, 2017 2:24 PM
Phil Parkin - Wednesday, October 11, 2017 1:25 PM
--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)

October 11, 2017 at 9:56 pm

#1963303
RE: Having trouble displaying a date in a certain format...

chef423 - Wednesday, October 11, 2017 1:34 PM
FORMAT(Invoice_Exceptions.DateTime, 'MM-dd-yyyy hh:mm tt')
Wow, I feel like a numskull, I swear 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)

October 11, 2017 at 9:54 pm

#1963302
RE: Can't zero pad a variable

Phil Parkin - Wednesday, October 11, 2017 2:25 PM
ken.trock - Wednesday, October 11, 2017 2:18 PM
--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)

October 11, 2017 at 8:10 pm

#1963297
RE: Order of Indexed columns - does it matter

Also, check the execution count of the INDEX SEEKS in the execution plan. If there's one for every row, that's a very bad thing performance wise.
Last but not...
--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)

October 11, 2017 at 8:03 pm

#1963295
RE: query format

Now to ask the hard question. Do you understand the code well enough to do it again for something else on your own?
--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)

October 11, 2017 at 7:59 pm

#1963294

Viewing 15 posts - 14,116 through 14,130 (of 59,101 total)