Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,111 through 13,125 (of 59,099 total)

RE: SQL Server Unused Index Script

Steve Jones - SSC Editor - Thursday, January 18, 2018 9:36 AM
I am removing these scripts from the site. There do appear...
--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)

January 18, 2018 at 10:13 am

#1976373
RE: Are the posted questions getting worse?

ChrisM@Work - Thursday, January 18, 2018 8:05 AM
Jeff Moden - Thursday, January 18, 2018 8:00 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)

January 18, 2018 at 8:31 am

#1976337
RE: UPDATE() function in a trigger

Aaron N. Cutshall - Thursday, January 18, 2018 7:59 AM
Thanks for the warning Jeff. Fortunately, this trigger gets regenerated each time...
--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)

January 18, 2018 at 8:28 am

#1976336
RE: Formatted ASCII Results from a SELECT

I love it! Thanks for the article!
--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)

January 18, 2018 at 8:07 am

#1976334
RE: Are the posted questions getting worse?

xsevensinzx - Thursday, January 18, 2018 7:18 AM
Jeff Moden - Wednesday, January 17, 2018 6:50 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)

January 18, 2018 at 8:00 am

#1976331
RE: UPDATE() function in a trigger

Aaron N. Cutshall - Thursday, January 18, 2018 6:30 AM
Instead I turned to the COLUMNS_UPDATED() function and with some application of set-based...
--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)

January 18, 2018 at 7:47 am

#1976327
RE: SQL Server Unused Index Script

Sue_H - Thursday, January 18, 2018 7:01 AM
Jeff Moden - Thursday, January 18, 2018 6:14 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)

January 18, 2018 at 7:43 am

#1976324
RE: Anyone using Python?

Spam reported.
--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)

January 18, 2018 at 6:17 am

#1976312
RE: SQL Server Unused Index Script

Wow... this guy has no sense of right. Considering that he also copied the text of an article, it proves that his plagiarism is blatant and deliberate.
--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)

January 18, 2018 at 6:14 am

#1976310
RE: Update Statistics : _WA_Sys_0000000 ... Type

river1 - Wednesday, January 17, 2018 12:40 PM
Jeff Moden - Wednesday, January 17, 2018 11:44 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)

January 18, 2018 at 5:58 am

#1976306
RE: SQL Server Unused Index Script

ChrisM@Work - Thursday, January 18, 2018 4:35 AM
This one is also stolen. The entire introductory text has been lifted word...
--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)

January 18, 2018 at 5:34 am

#1976302
RE: UPDATE() function in a trigger

TheSQLGuru - Wednesday, January 17, 2018 8:12 PM
Just making statements of fact - nothing more sadly for you.
I think you should spin...
--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)

January 18, 2018 at 5:23 am

#1976300
RE: Compression estimates

Evgeny Garaev - Wednesday, January 17, 2018 8:23 PM
Jeff Moden - Wednesday, January 17, 2018 5:20...
--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)

January 17, 2018 at 10:44 pm

#1976266
RE: UPDATE() function in a trigger

TheSQLGuru - Wednesday, January 17, 2018 4:52 PM
Aaron N. Cutshall - Wednesday, January 17, 2018 1:17 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)

January 17, 2018 at 5:30 pm

#1976256
RE: Compression estimates

It'll be interesting to see someone's face when they run this code even on a giant database right after a service bounce. 😉 A little embedded documentation would go 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)

January 17, 2018 at 5:20 pm

#1976255

Viewing 15 posts - 13,111 through 13,125 (of 59,099 total)