Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,391 through 9,405 (of 59,099 total)

Reply To: Ignoring Divide by Zero

I guess the real key here is that if you're dividing by zero, there's something wrong with your data, your code, or both. I've never ignored divide by zero errors...
--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)

May 3, 2019 at 11:34 pm

#3634842
Reply To: t-sql 2012 string together names separated by a comma

Now that you have an answer, do you know how it works and why it could fail?
--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)

May 2, 2019 at 4:33 pm

#3630550
Reply To: Powershell Robocopy Help.. -second attempt to post(?)

Just ran across this. Yeah... you file path has spaces in it, as well, and so it needed to be quoted. I got into the habit of automatically encapsulate such...
--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)

May 2, 2019 at 4:32 pm

#3630546
Reply To: Are the posted questions getting worse?

Luis Cazares wrote:
Have you ever encountered some code that makes you feel that you need wine instead of coffee to fix it? Or is it just me?

I'm working on a code...
--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)

May 2, 2019 at 2:03 pm

#3628072
Reply To: A Self-Serve System that Allows Developers to Refresh Databases (Part 1)

I had similar issues and the single user thing seemed to handle that. You DO have to be careful to not lose the single user connection or those service logins...
--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)

May 2, 2019 at 1:57 pm

#3627954
Reply To: A Self-Serve System that Allows Developers to Refresh Databases (Part 1)

Heh... there must be a disturbance in the force. I've been asked to do something similar about 2 weeks ago. Because I have to kill a bunch of data and...
--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)

May 2, 2019 at 1:43 pm

#3627685
Reply To: Date Format (mm/dd/yyyy hh:mm), no seconds or milliseconds

Rohit Machhi wrote:
select FORMAT(Convert(datetime,GETDATE (),103),'MM/dd/yyyy HH:mm')

While that's incredibly simple, as it was designed to be, FORMAT has been tested and documented as being 44 times slower than even poor renditions. Until...
--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)

May 2, 2019 at 12:51 pm

#3626819
Reply To: Today's Random Word!

Ed Wagner wrote:
below86 wrote:
Ed Wagner wrote:
Ray K wrote:
Sean Lange wrote:
Ed Wagner wrote:
Eirikur Eiriksson wrote:
Lamb
Leg
Up
Shot
Top
Gun
Gatling
Warthog
--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)

May 2, 2019 at 3:32 am

#3608693
Reply To: NULL Storage

I'm not sure how any of that was misleading. I did state that the 8096 included the row header and did state that SQL Server uses the number 8060 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)

May 2, 2019 at 3:30 am

#3608552
Reply To: Add\Modify Index on Large Table.

Rechana Rajan wrote:
Jeff Moden wrote:
There's a difference (to me, anyway) between a table that suffers a whole lot of INSERTs and a table that suffers UPDATEs. Run logs (with only one exception...
--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)

May 2, 2019 at 1:13 am

#3607165
Reply To: Add\Modify Index on Large Table.

There's a difference (to me, anyway) between a table that suffers a whole lot of INSERTs and a table that suffers UPDATEs. Run logs (with only one exception that's 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)

May 1, 2019 at 3:31 pm

#3601962
Reply To: Add\Modify Index on Large Table.

Rechana Rajan wrote:
I have a very huge table (60GB) used for logging purpose(100 of records logged every second). Now the developers have added a new update script as procedure which is...
--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)

May 1, 2019 at 1:42 pm

#3601453
Reply To: SQL VIEW works on its own but not when combined

thenewbee wrote:
Thanks all once again.. How can I attach the execution plan

Ya know... since they've updated this forum to new software, that's a really good question. I hope they fix...
--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)

May 1, 2019 at 12:20 pm

#3600922
Reply To: Using table for search and replace values

Apologies... it took longer to find than expected.

The following code makes up to 450 possible substitutions. Details are in the code. Please understand that I've not tested the method I...
--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)

May 1, 2019 at 12:59 am

#3587923
Reply To: Guest editorial: SQL Code Metrics

Heh... wrong color... it needs to be a Red Herring to chop down trees with. 😀
--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)

April 30, 2019 at 10:44 pm

#3580455

Viewing 15 posts - 9,391 through 9,405 (of 59,099 total)