Jeff Moden

Forum Replies Created

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

RE: New Database Options

xsevensinzx - Friday, November 16, 2018 8:39 PM
You have Polybase...
...{snip}...
where all you need to focus on is the INSERT and NEVER 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)

November 17, 2018 at 12:59 pm

#2013870
RE: Do you use custom schemas?

Jonathan AC Roberts - Saturday, November 17, 2018 5:59 AM
Jeff Moden - Friday, November 16, 2018 3:38...
--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 17, 2018 at 12:54 pm

#2013869
RE: Do you use custom schemas?

fahey.jonathan - Friday, November 16, 2018 3:12 PM
Jonathan AC Roberts - Thursday, November 15, 2018 10:18 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 16, 2018 at 3:38 pm

#2013832
RE: The Top Rows

Heh... no trip up for me and no real thinking. Training from the Navy helped a lot... "If you don't see something familiar or you don't have a clue 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)

November 16, 2018 at 3:35 pm

#2013831
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

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