Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,856 through 12,870 (of 59,099 total)

RE: Compression estimates

OnePunchDBA - Wednesday, February 21, 2018 7:13 AM
Good work but looks like you have reinvented the wheel, which does happen very often...
--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 21, 2018 at 7:31 am

#1980614
RE: How would you lock down a SQL DBA to have local admin on the SQL box

ffarouqi - Tuesday, February 20, 2018 1:53 PM
I would like to know if we can create a separate group or what permissions...
--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 21, 2018 at 6:55 am

#1980608
RE: Auditing

This is not a trivial task. Start here.
https://www.red-gate.com/simple-talk/sql/database-administration/auditing-ddl-changes-in-sql-server-databases/
If that is insufficient for some reason, then buy a product such as Apex.
--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 21, 2018 at 6:40 am

#1980606
RE: Triggers or best option

Now, I told you that story to tell you this one. Consider the links that Evgeny Garaev provided above. The cool part about the Temporal Tables is that they auto-magically...
--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 9:10 pm

#1980579
RE: Triggers or best option

Jeff Moden - Tuesday, February 20, 2018 7:18 AM
Whatever you do, don't audit INSERTS. I'll be back to explain why after work...
--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 8:53 pm

#1980578
RE: Get date for iteration of a DOW

Take your time. You can't think if you're in a rush. Put it up for a couple of days and come back to it.
--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:31 pm

#1980577
RE: Get date for iteration of a DOW

It's broke...
DECLARE
@Year
SMALLINT
--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 2:58 pm

#1980558

RE: SQL Server 2012, on production database only 1 CPU used out of 4 CPU

santosh.mane - Tuesday, February 20, 2018 12:18 AM

Hi,

We have SQL Server 2012, on production database only 1 CPU used out of 4...

--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 2:42 pm

#1980554