Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,871 through 12,885 (of 59,099 total)

RE: Triggers or best option

Whatever you do, don't audit INSERTS. I'll be back to explain why after work tonight.
{EDIT} And don't use supposedly "portable" CLR triggers. They're horrible for performance because 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)

February 20, 2018 at 7:18 am

#1980451
RE: @@OPTIONS

Steve Jones - SSC Editor - Tuesday, February 20, 2018 6:09 AM
Apologies for the explanation. That is updated.
For the result set answer,...
--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)

February 20, 2018 at 7:11 am

#1980450
RE: Building Culture

xsevensinzx - Monday, February 19, 2018 8:59 PM
On my team, I am certainly trying to build a culture centered around being open,...
--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)

February 20, 2018 at 7:04 am

#1980448
RE: Issue with using Ola Hallengren Backup script

Apparently Ola's scripts are spot on in providing the errors that they did. Please see the following URL:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-backup-to-url#limitations
In particular, see the part where it says...
--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)

February 20, 2018 at 6:40 am

#1980443
RE: Issue with using Ola Hallengren Backup script

quackhandle1975 - Tuesday, February 20, 2018 5:44 AM
Is it the numbers that are wrong? I thought his script is saying if 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)

February 20, 2018 at 6:18 am

#1980434
RE: Issue with using Ola Hallengren Backup script

quackhandle1975 - Tuesday, February 20, 2018 5:11 AM
Thanks Jacob, that's a great spot! (It was my next thing to check).
I wonder if...
--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)

February 20, 2018 at 5:18 am

#1980422
RE: how to avoid special characters and spaces when update in sql server

Is your server/database or the column case sensitive or 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)

February 20, 2018 at 5:16 am

#1980420
RE: Need to get consecutive duplicate rows

Jacob Wilkins - Sunday, February 18, 2018 8:33 AM
Jeff,
I appreciate that (and hopefully this isn't coming off as violently defensive or anything...
--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)

February 19, 2018 at 8:15 pm

#1980374
RE: Need to get consecutive duplicate rows

Sergiy - Monday, February 19, 2018 7:55 PM
The request, and consequently all the solutions provided, are wrong.The nature of requirements has nothing...
--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)

February 19, 2018 at 8:07 pm

#1980373
RE: Adding multiple triggers to same table - Recommendations/Best Practices

RonKyle - Monday, February 19, 2018 6:20 PM
And I'm still having a really hard time understanding why someone would put 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)

February 19, 2018 at 7:27 pm

#1980370
RE: Performance improvement following a disable indexes, shrink, enable indexes - but why?

What do you mean by "pre-compacted"? If you mean you did a shrink-file or shrink-database, then don't bother because just updating stats on tables that have been logically inverted by...
--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)

February 19, 2018 at 7:08 pm

#1980369
RE: finding the right index

Jackie Lowery - Monday, February 19, 2018 4:14 PM
ScottPletcher - Monday, February 19, 2018 2:45 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)

February 19, 2018 at 5:36 pm

#1980367
RE: Adding multiple triggers to same table - Recommendations/Best Practices

SQL!$@w$0ME - Monday, February 19, 2018 4:19 PM
Oracle box has 99.99% availability. Thanks
K. Are you looking to copy all changes to 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)

February 19, 2018 at 5:29 pm

#1980365
RE: How to implement taking action based in column value?

Student031 - Monday, February 19, 2018 11:09 AM
The title might be a bit non-specific but I couldn't think of any better way...
--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)

February 19, 2018 at 2:23 pm

#1980350
RE: Adding multiple triggers to same table - Recommendations/Best Practices

RonKyle - Monday, February 19, 2018 1:39 PM
I'm not with Jeff on the "well designed triggers". Well designed triggers exist...
--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)

February 19, 2018 at 1:50 pm

#1980342

Viewing 15 posts - 12,871 through 12,885 (of 59,099 total)