Jeff Moden

Forum Replies Created

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

Reply To: Interview question

Phil Parkin wrote:
I agree that this is a horrid idea.
Heh... yeah.. me too. I hate SSIS. 😀 😀 😀

Phil Parkin wrote:
It is, however, pretty easy to solve.
Totally agreed... write a good stored...
--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 4, 2019 at 12:11 am

#3634863
Reply To: Number of Mondays between two dates

Sergiy wrote:
Look at the progress we've got in SQL over the years! what used to be 13 years ago a short inline formula using system functions and integer arithmetic 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 4, 2019 at 12:01 am

#3634855
Reply To: Status Update 2 May 2019

It would be interesting to see what the backlogged items are and the expected fix release date.
--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:52 pm

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

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