Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,576 through 10,590 (of 59,095 total)

RE: Off-site backups

PhilipC - Friday, November 16, 2018 5:49 AM
Would love to, only recently started in the organisation and they have heaps of 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)

November 16, 2018 at 8:51 am

#2013801
RE: New Database Options

Eric M Russell - Friday, November 16, 2018 8:13 AM
Jeff Moden - Friday, November 16, 2018...
--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)

November 16, 2018 at 8:46 am

#2013800
RE: New Database Options

Perhaps a bit deeper than just a database option, I'd like to see some table options that would give NoSQL a run for their money when it comes to ETL...
--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)

November 16, 2018 at 6:28 am

#2013788
RE: Off-site backups

2008 is now a decade old. Now would be a good time to do an upgrade.
--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)

November 16, 2018 at 5:46 am

#2013778
RE: Trigger on saving a stored procedure or function.

rchantler - Thursday, November 15, 2018 7:50 AM
We have an automated process that runs daily and checks all changed into VSS. ...
--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)

November 15, 2018 at 4:52 pm

#2013755
RE: Get Query used for update/insert/delete and log it with a trigger

Fair enough. What is the WAITFOR DELAY for? It's waiting for zero seconds.
Also, was the @Operation thing in the code I posted what you were looking for?
--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)

November 15, 2018 at 1:32 pm

#2013739
RE: so I am unemployed now

parsiporio - Thursday, November 15, 2018 9:59 AM
Burnsides - Monday, March 12, 2018 12:55 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)

November 15, 2018 at 12:17 pm

#2013732
RE: Get Query used for update/insert/delete and log it with a trigger

BTW... I believe that you'll find that capturing the query and saving it in the audit table will become a HUGE distraction not to mention a pretty good drag on...
--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)

November 15, 2018 at 12:09 pm

#2013731
RE: Get Query used for update/insert/delete and log it with a trigger

Here's what I typically preset triggers with.

--=====================================================================================================================
-- Presets
--=====================================================================================================================
--===== Exit early if no changes where actually made to the base 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)

November 15, 2018 at 12:06 pm

#2013728
RE: Parsing First and Last Names from Full Name

amy26 - Thursday, November 15, 2018 11:05 AM
Hi there! I have this code:

SELECT CASE WHEN CHARINDEX(' ',name) = 0...
--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)

November 15, 2018 at 11:59 am

#2013727
RE: how to find the lowest usage of a database

ScottPletcher - Thursday, November 15, 2018 10:21 AM
Jeff Moden - Wednesday, November 14, 2018 10: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)

November 15, 2018 at 11:45 am

#2013725
RE: Do you use custom schemas?

RonKyle - Thursday, November 15, 2018 8:30 AM
My...
--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)

November 15, 2018 at 9:16 am

#2013695
RE: How to study the layout of a database?

primitivefuture2006 - Thursday, November 15, 2018 8:26 AM
Jeff Moden - Tuesday, November 13, 2018 7:24 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)

November 15, 2018 at 9:04 am

#2013691
RE: Do you use custom schemas?

Shifting gears back to the subject at hand...
One of the things we use custom schemas for is to identify the expendability and life expectancy of 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)

November 15, 2018 at 8:37 am

#2013682
RE: Do you use custom schemas?

roger.plowman - Thursday, November 15, 2018 5:39 AM
I don't use schemas for a few reasons. First, why would you ever put multiple application...
--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)

November 15, 2018 at 8:06 am

#2013666

Viewing 15 posts - 10,576 through 10,590 (of 59,095 total)