Jeff Moden

Forum Replies Created

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

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
RE: Customize Software or Process

HighPlainsDBA - Wednesday, January 17, 2018 3:16 PM
Oh man, this is a good one. This is the problem that never seems 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)

January 17, 2018 at 4:46 pm

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

Steve Jones - SSC Editor - Wednesday, January 17, 2018 10:28 AM
Did you manually recreate them?
Nope. The system did when someone ran...
--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 11:44 am

#1976170
RE: Backups, Backups, Backups.......

I guess my recommendation would be... to educate the people involved as to what RPO and RTO actually means and what the impact to the business would be for (for...
--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:42 am

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

Steve Jones - SSC Editor - Wednesday, January 17, 2018 7:49 AM
Ignore these stats. If they are useful and always created, you...
--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 9:54 am

#1976150

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