Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,376 through 9,390 (of 59,091 total)

Reply To: Dos and Don'ts of Dynamic SQL

TomD-982312 wrote:
Like the article. I'd like to point to the fact that "PRINT @sql;" is limited to 4000 characters, therefore I use "SELECT CAST('<root><![CDATA[' + @sql + ']]></root>' AS XML)".
So...
--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 6, 2019 at 7:41 pm

#3636630
Reply To: Status Update 2 May 2019

Thanks Steve.
--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 6, 2019 at 11:30 am

#3636351
Reply To: Fixate the Menu bar

How about we get things like attachments on the articles fixed first? That and continue to "fix the internet". I've come across many links in Google to posts on SSC...
--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:58 am

#3634887
Reply To: Maintenance Plan

Or create a third job that calls a new proc that calls the stored procedures that you're using in the other two jobs.
--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:49 am

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

Viewing 15 posts - 9,376 through 9,390 (of 59,091 total)