Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,901 through 12,915 (of 59,099 total)

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
RE: Need to get consecutive duplicate rows

Understood and appreciated. But you're only focusing on what the OP asked. While that certainly sounds like the right thing to do, even the OP has made no guarantee 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)

February 18, 2018 at 8:24 am

#1980196
RE: Today's Random Word!

DesNorton - Saturday, February 17, 2018 11:59 PM
Jason A. Long - Saturday, February 17, 2018 6:03 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)

February 18, 2018 at 8:05 am

#1980195
RE: Show results based on String Search

shyamhr - Sunday, February 18, 2018 1:11 AM
I agree with you Jeff. I wish I could do that. Lol....
Heh... understood and much appreciated. ...
--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:01 am

#1980194
RE: XP_cmdshell DIR

Jeff Moden - Saturday, February 17, 2018 6:04 PM
SQL-DBA-01 - Thursday, April 23, 2015 9: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)

February 17, 2018 at 6:05 pm

#1980191
RE: XP_cmdshell DIR

SQL-DBA-01 - Thursday, April 23, 2015 9:55 AM
Can you please suggest all the files from one location to another using the temp...
--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 17, 2018 at 6:04 pm

#1980190
RE: Show results based on String Search

shyamhr - Saturday, February 17, 2018 2:26 PM
Thanks Jeff for the idea. I actually implemented the same idea you said. I penned...
--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 17, 2018 at 4:14 pm

#1980186
RE: Need to get consecutive duplicate rows

Jacob Wilkins - Saturday, February 17, 2018 2:33 PM
Jeff,
Well aware of that. It was not specified that an id of, say, 7...
--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 17, 2018 at 4:11 pm

#1980185
RE: Need to get consecutive duplicate rows

Jacob Wilkins - Friday, February 16, 2018 2:49 PM
I know the post is in a 2012 forum, but just in case, here's...
--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 17, 2018 at 1:44 pm

#1980180
RE: Need idea on exporting column data to separate file -ssis

Heh... they won't allow you to use xp_CmdShell because they think it's a security risk (it's patently NOT when used correctly) but they will let you call a C# script...
--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 17, 2018 at 1:09 pm

#1980177
RE: Show results based on String Search

shyamhr - Friday, February 16, 2018 5:10 PM
Hi Everyone,
I have a complex...
--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 17, 2018 at 12:37 pm

#1980176
RE: @@OPTIONS

Heh... although it certainly does return a single integer (which is the answer I chose based on a coin flip between A and C), answer C is actually much more...
--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 17, 2018 at 12:26 pm

#1980175

Viewing 15 posts - 12,901 through 12,915 (of 59,099 total)