Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,096 through 7,110 (of 59,102 total)

Reply To: Rolling Back One Bug for Another

roger.plowman wrote:
Steve Jones - SSC Editor wrote:
DevOps isn't related to cadance or QA/testing. It is related to learning to become better. Plenty of companies conflated the two and drove speed over quality (many still...
--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 19, 2020 at 2:39 pm

#3752905
Reply To: Error when copying pasting in Excel data to empty table

You do realize that your dates that you're copying from aren't dates, right? They probably the number of days since 1900-01-01 but they're not actually dates. I believe that's your...
--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 19, 2020 at 2:32 am

#3752771
Reply To: Rolling Back One Bug for Another

The big thing missing here is that there was no investigation as to why any of the bugs were released. There's something very wrong when this type of thing happens...
--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 19, 2020 at 2:09 am

#3752767
Reply To: Displaying Hierarchical Data

Heh... and the graphics I posted in a previous post certainly went south when they did the "improvements" for this site. Lordy.
--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 19, 2020 at 2:04 am

#3752766
Reply To: More Binary CASTing

Heh... one does have to wonder though, why anyone would use a max data type (LOB) for such a thing. 🙂
--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 19, 2020 at 1:37 am

#3752765
Reply To: Return code with stored procedure

Excellent. Thanks for the feedback, Michael.
--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 19, 2020 at 1:31 am

#3752764
Reply To: Cleanup Sysmail -items from msdb

Excellent. Thanks for the feedback, Bruin. I think I can speak for the others in saying that we're very interested in how your test turns out. My production system only...
--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 19, 2020 at 1:29 am

#3752763
Reply To: Cleanup Sysmail -items from msdb

To be honest, I think that all'y'all 😀 are making this a whole lot more complex than needed. The PK on the table is an identity column. That means 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)

May 18, 2020 at 7:33 pm

#3752683
Reply To: Return code with stored procedure

And, no... not as old as dirt. I'm older than a lot of the dirt I made in my garden. 😀 I've got sox older than some of your adult...
--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 18, 2020 at 3:37 pm

#3752626
Reply To: Return code with stored procedure

michael.leach2015 wrote:
Jeff,
Thanks for the link. Now I understand how to obtain the return code.
Here is the only part I don't understand. Using the code from my example, how might 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)

May 18, 2020 at 3:35 pm

#3752625
Reply To: Return code with stored procedure

michael.leach2015 wrote:
Jeff,
Thanks for the link. Now I understand how to obtain the return code.
Here is the only part I don't understand. Using the code from my example, how might 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)

May 18, 2020 at 3:31 pm

#3752604
Reply To: Memory Optimized tables for speeding inserts and updates

IMHO, memory optimized tables have a lot of baggage for something like this. How often will you need to do this? If it's once every 10 minutes, maybe. If it'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)

May 18, 2020 at 3:03 pm

#3752597
Reply To: Return code with stored procedure

You have to use RETURN somevalue or variable in the proc to get such a return.
See the following...
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/return-transact-sql?view=sql-server-ver15
--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 18, 2020 at 2:33 pm

#3752582
Reply To: How can I determine relationships or dependencies between tables or queries?

frank.kress wrote:
Hi Jeff
that's incredibly fantastic. That's exactly what I thought.
The system views such as: sys.sql_dependencies goes in the right direction but the tool from Quest is a real hammer.
And 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)

May 18, 2020 at 1:55 pm

#3752511
Reply To: Cleanup Sysmail -items from msdb

Maybe, but it shouldn't be for long unless you have a huge number of emails per day. Of course, you would have had the same blocking (short and sweet) 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)

May 18, 2020 at 1:49 am

#3752366

Viewing 15 posts - 7,096 through 7,110 (of 59,102 total)