Jeff Moden

Forum Replies Created

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

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
RE: Transaction Log Growth

Mike Scalise - Monday, February 19, 2018 12:52 PM
Jeff Moden - Sunday, February 18, 2018 4:30 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 1:18 pm

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

SQL!$@w$0ME - Monday, February 19, 2018 12:12 PM
Do you think transactional replication is a good choice for 500 tables. Any performance impact...
--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 12:56 pm

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

RonKyle - Monday, February 19, 2018 7:07 AM
As for avoiding triggers, I think that too many people make the recommendation 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)

February 19, 2018 at 7:16 am

#1980269
RE: SELECT TOP X vs Offset Fetch? Want to limit query results but not force a sort and scan?

I also would NOT make a view of this. Rather, I'd create an iTVF as a bit of a "parameterized view" so that you don't have to change the actual...
--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:37 am

#1980253

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