Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,886 through 12,900 (of 59,099 total)

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
RE: Materialized views

I did a search of "Materialized Views Oracle" and got quite a bit of information about it. It does seem that materialized views in Oracle can do quite a bit...
--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:34 am

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

Ah... one more thing. If anyone suggests the use of "portable/universal CLR triggers", send them from the room because they have no clue what a horrible impact that will have...
--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 18, 2018 at 8:25 pm

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

I'll also add that you need to know how long you need to keep the audit data online, on disk, and on tape. If you can ever delete audit data,...
--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 18, 2018 at 8:17 pm

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

SQL!$@w$0ME - Sunday, February 18, 2018 6:10 PM
Thanks for positive response Jeff.Since the audit triggers are going to implement for multiple tables(over...
--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 18, 2018 at 8:04 pm

#1980215
RE: Database Taming

I look at it more like the Robo-Cop movies, particularly the one where Robo_Cop is "blessed" with a thousand directives (think "best practices") to get along with humans. In 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 18, 2018 at 6:09 pm

#1980213
RE: Training?

I'd go for professional training for Microsoft Certification. The SQL Cruise, PASS Summit, SQL Saturdays, and local PASS Chapter offering are all good but are very hit and miss whereas...
--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 18, 2018 at 5:49 pm

#1980212
RE: Need experts Advice

JoNTSQLSrv - Wednesday, February 14, 2018 10:13 AM
HI guys,
I need expects advice to do below things with great performance.
A Table...
--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 18, 2018 at 5:44 pm

#1980211
RE: Need experts Advice

Evgeny Garaev - Wednesday, February 14, 2018 6:37 PM
You can use NTILE to split rows between batches, more details here -...
--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 18, 2018 at 5:40 pm

#1980210
RE: Average number of records per hour per datetime range

robert693 - Wednesday, February 14, 2018 1:39 PM
Hi,
I have a DB with PATIENT_ID, ARRIVAL_DATE, DEPARTURE_DATE, and DEPARTMENT. I need to find 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 18, 2018 at 5:26 pm

#1980209
RE: Stored procedure not executing in Linked Server

For the love of all that is holy in the world of database security, stop using the SA account for anything. Setup a separate Active Directory service account and use...
--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 18, 2018 at 5:17 pm

#1980208
RE: SQL Server Audit log - statement empty

You'd likely get better responses if you clearly identified how you are capturing such information and which "logs" you're talking about.
--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 18, 2018 at 5:13 pm

#1980207

Viewing 15 posts - 12,886 through 12,900 (of 59,099 total)