Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,106 through 9,120 (of 59,067 total)

Reply To: Notification of zero records in a table

Budd wrote:
Sounds like a great idea, thanks Jeff. I've never used synonyms, this should be fun 🙂
The NAME of the synonym would be whatever the original table was before you...
--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)

June 18, 2019 at 3:28 pm

#3654800
Reply To: Slower is Faster

BWAAA-HAAA! I've actually not heard that one before, David. I'm going to remember that one!
Shifting gears a bit and on the subject of people saying "There is no "I" in...
--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)

June 18, 2019 at 2:17 pm

#3654769
Reply To: Slower is Faster

Too funny.
On a similar note, I'm not one to use Hungarian Notation (Phil Factor calls it "tbl-ing") for object names but I ran into a bit of a dilemma quite...
--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)

June 18, 2019 at 1:57 pm

#3654757
Reply To: Slower is Faster

Phil Parkin wrote:
MVDBA (Mike Vessey) wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of...
--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)

June 18, 2019 at 1:43 pm

#3654751
Reply To: Slower is Faster

Heh... I was in the military a long time ago. I got used to strange names that had weird abbreviations. Even my Dad had to put up with some of...
--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)

June 18, 2019 at 11:34 am

#3654704
Reply To: 15466 error when executing xp_cmdshell with non sysadmin user

rVadim wrote:
Thank you, Jeff, very useful info.
Thanks for the feedback, rVadim.
--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)

June 18, 2019 at 11:20 am

#3654689
Reply To: Partition Corruption Impact on whole db

So... enquiring minds want to know... did the link help you or not?
--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)

June 18, 2019 at 4:38 am

#3654623
Reply To: Looking for Step by Step Instructions for SQL Server Loop using Powershell

sunshine-587009 wrote:
Hi! I'm no really sure I am doing this correctly. I am not running anything by database and already have an existing table. The first one attached is 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)

June 18, 2019 at 4:32 am

#3654621
Reply To: Notification of zero records in a table

Budd wrote:
There is a JAVA app that clears and reloads a staging table, but occasionally it fails to reload. So I am trying to figure out a way that will...
--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)

June 18, 2019 at 4:30 am

#3654620
Reply To: Slower is Faster

MVDBA (Mike Vessey) wrote:
while it's slightly off topic, I worked with a team that mixed the V model (kinda like waterfall) and agile.. it had an unfortunate nickname of "vagile"
What did...
--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)

June 18, 2019 at 4:25 am

#3654619
Reply To: How to find a set of sequential values within a list
If you're not using at least SQL Server 2012, the feature/syntax doesn't exist prior to that. You say you're using v17 but what is that for? SSMS? That's not what...
- This reply was modified 7 years ago by Jeff Moden.
--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)
June 18, 2019 at 4:15 am

#3654617
Reply To: Calculate last friday date with timestamp ssis

dallas13 wrote:
Mya be you have some different collation or timezone setting. Here is what I am getting. 6/14/2019 5:00:00 PM
My recommendation would be to rewrite it so that it does...
--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)

June 17, 2019 at 4:16 pm

#3654497
Reply To: How Do I resolve SSMS 'is busy" issue
five_ten_fiftyfold wrote:
So I come across this thread nine years and several iterations of SSMS after the event, totally fed up with having to restart SSMS repeatedly, often losing work along...
- This reply was modified 7 years ago by Jeff Moden.
--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)
June 17, 2019 at 2:10 pm

#3654442
Reply To: Watching Out for Deferred Name Resolution

Bryant McClellan wrote:
Perhaps for the same reason jackrabbits run in front of cars?
Heh... and squirrels. 😀
--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)

June 17, 2019 at 1:37 pm

#3654435
Reply To: Powershell script to get the local adminstrators liston multiple windows servers

To answer the logically next expected question...
https://www.google.com/search?&q=save+powershell+output+to+table+in+sql+server
Of course, I don't have a code example for this because I don't use PowerShell to do such things, especially since the list...
--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)

June 17, 2019 at 1:12 pm

#3654429

Viewing 15 posts - 9,106 through 9,120 (of 59,067 total)