Jeff Moden

Forum Replies Created

Viewing 15 posts - 17,056 through 17,070 (of 59,101 total)

RE: Need query for After Trigger on update,delete

ScottPletcher (8/15/2016)
Jeff Moden (8/15/2016)
ScottPletcher (8/15/2016)
Jeff Moden (8/15/2016)
Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original 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)

August 15, 2016 at 4:15 pm

#1895540
RE: Tablix assistance please!

Apologies for missing your follow up posts on this. It IS a bit amazing to me that no one else picked up on this thread. I'll see what...
--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)

August 15, 2016 at 4:12 pm

#1895539
RE: Finding data that does not exist in another table

msmith-880862 (8/15/2016)
Thanks for the reply everyone. It looks like I can't do it with a view but I got some great ideas from everyone. Thanks again.
Just a...
--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)

August 15, 2016 at 4:05 pm

#1895538
RE: Rounding in tsql

CELKO (8/15/2016)
The ANSI/ISO standards define rounding as "implementation defined", so you have to be careful. Google scientific versus commercial rounding (I prefer this because it is more "set oriented" than...
--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)

August 15, 2016 at 3:45 pm

#1895535
RE: Problem to copy a column (tablix, subgroup?)...

I can't help because I don't even know how to spell "SSRS" but thought I'd take the time to "bump" this for you. Someone should be able to help...
--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)

August 15, 2016 at 3:42 pm

#1895534
RE: Stored procedures and Creating tables. (Problem).

ben.brugman (7/18/2016)
At the moment I am in a process converting a number of CSV files into XML files.
Heh... as one of my favorite comic characters is know to say...
[font="Arial Black"]GAH![/font]
--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)

August 15, 2016 at 3:36 pm

#1895531
RE: Need query for After Trigger on update,delete

Ed Wagner (8/15/2016)
ScottPletcher (8/15/2016)
Jeff Moden (8/15/2016)
Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original data lives...
--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)

August 15, 2016 at 3:28 pm

#1895530
RE: Need query for After Trigger on update,delete

ScottPletcher (8/15/2016)
Jeff Moden (8/15/2016)
Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original data lives 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)

August 15, 2016 at 3:27 pm

#1895529
RE: To Infinity and Beyond

Gary Varga (8/15/2016)
thisisfutile (8/15/2016)
Jeff Moden (8/15/2016)
From the Article:
The explosion in aircraft ...
Now, there's two words that should never be so close together in a sentence. 😀
...definitely stand out members...
Is that...
--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)

August 15, 2016 at 9:52 am

#1895481
RE: Writing Better T-SQL: Top-Down Design May Not be the Best Choice

Iwas Bornready (8/15/2016)
Sometimes that works and sometimes it doesn't. I've got examples where I had to break up an elaborate query into smaller steps to gain any appreciable speed.
I've done...
--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)

August 15, 2016 at 7:29 am

#1895447
RE: Need query for After Trigger on update,delete

Also, you should probably avoid auditing inserts. It's an unnecessary duplication of data because even if there's never an update, the original data lives in the original 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)

August 15, 2016 at 7:08 am

#1895442
RE: Bash for ETL pre-processing
David.Poole (8/15/2016)
What I see in corporate data defies rational analysis.
Data that should be on a strict need-to-know basis available for general consumption

Data that should be generally available locked up tighter...

--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)

August 15, 2016 at 7:04 am

#1895439

RE: SQL 2012 Grant execute rights to user on specific SQL Agent Job

joeroshan (8/15/2016)
You can try adding execute as owner while creating the procedure, so that the user can impersonate your permissions.

To run the job, probably.

--Jeff Moden

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)

August 15, 2016 at 7:01 am

#1895435

RE: How can restore deleted sql job

I'll also add that the idea of source control for jobs and all other code on your server should become a concern... right after you get your backups setup so...

--Jeff Moden

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)

August 15, 2016 at 6:47 am

#1895423

RE: To Infinity and Beyond

From the Article:
The explosion in aircraft ...

Now, there's two words that should never be so close together in a sentence. 😀

--Jeff Moden

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)

August 15, 2016 at 6:42 am

#1895419

Viewing 15 posts - 17,056 through 17,070 (of 59,101 total)