Jeff Moden

Forum Replies Created

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

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
RE: Adding multiple triggers to same table - Recommendations/Best Practices

I guess I'd just combine trigger actions and keep the actual number of triggers to a minimum.
As for avoiding triggers, I think that too many people make 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:01 pm

#1980206
RE: Transaction Log Growth

Mike Scalise - Sunday, February 18, 2018 1:11 PM
Hi,
I am currently using Ola Hallengren's backup solution for my backups on a SQL...
--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 4:30 pm

#1980205
RE: Showplan

They don't have a "dev" server?
--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 3:19 pm

#1980203
RE: Today's Random Word!

Jason A. Long - Sunday, February 18, 2018 12:40 PM
Jeff Moden - Sunday, February 18, 2018 8:05 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)

February 18, 2018 at 3:15 pm

#1980202

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