Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,096 through 4,110 (of 59,098 total)

Reply To: How SQL Server Can Just Go Faster

David Burrows wrote:
Jeff Moden wrote:
All that being said, I'm scared to death of moving from 2016 to 2019 next year and MS has done nothing to quell the ongoing fears associated 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)

January 16, 2022 at 5:39 pm

#3973689
Reply To: Where did the 'Insert Code' toolbar go?

Jeff Moden wrote:
Jeffrey Williams wrote:
Still no notification emails - at least I have not received any.
Same here as of this instant.
Yeah... absolutely confirmed. I'm definitely not getting any email notifications.
--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)

January 16, 2022 at 2:55 am

#3973573
Reply To: T-SQL Requires the Right Approach

rfulbrig wrote:
RBAR (pronounced "ree-bar", Row By Agonizing Row) development.
Heh... I kinda knew 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)

January 16, 2022 at 2:52 am

#3973571
Reply To: Change Invalid date to 1900-01-01 in sql CASE query

Adi wrote:
How do we add leap years in the following query along with the month of February?
CASE WHEN SUBSTR(RELEASE_DATE,1,4)<1900 OR SUBSTR(RELEASE_DATE,1,4)>9999 THEN '1900-01-01' WHEN SUBSTR(RELEASE_DATE,6,2)>12 THEN '1900-01-01' WHEN SUBSTR(RELEASE_DATE,9,2)>31 THEN...
--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)

January 15, 2022 at 5:05 pm

#3973506
Reply To: Run insert on N databases, and return name of databases where insert occurred

So, JaybeeSQL... enquiring minds want to know... why have you essentially deleted several posts with no explanation? You made the lessons taught in each post that follows one of 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)

January 15, 2022 at 4:53 pm

#3973505
Reply To: Choose to use '>=' or '>' LOGIC in WHERE Clause Using CASE Statement

ScottPletcher wrote:
Jeffrey Williams wrote:
Instead of using a CASE expression (as you were trying) - or stacked OR's: WHERE @mDepth > iif(@tDepth = 0, -1, @tDepth)
Consider: @mDepth >= 0 is equivalent to...
--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)

January 15, 2022 at 4:46 pm

#3973504
Reply To: T-SQL Requires the Right Approach

Nice article, Kathi.
Your description of "Some of the most problematic T-SQL code I’ve seen" is a perfect description for simple "RBAR".
And, I agree with Rick. The way SQL is taught...
--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)

January 15, 2022 at 4:17 pm

#3973502
Reply To: Where did the 'Insert Code' toolbar go?

Jeffrey Williams wrote:
Still no notification emails - at least I have not received any.
Same here as of this instant.

--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)

January 14, 2022 at 11:28 pm

#3973316
Reply To: Database doesn't decrease in size after shrinking .mdf file

Like I said earlier, the trouble with doing a single big shrink is you have no way of telling how far it's gone nor how much is left to do. ...
--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)

January 14, 2022 at 4:41 am

#3972992
Reply To: Database doesn't decrease in size after shrinking .mdf file
olegserdia wrote:
@Ant-Green thank you for the tip.
The code:
```
-- Shrink the mdf file. 
DBCC SHRINKFILE(N'FileName', 0, TRUNCATEONLY);
GO
```
After one of the replies I decided to shrink database (not file), using...
--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)
January 13, 2022 at 12:30 am

#3972592
Reply To: Moving DB file

Nita Reddy wrote:
I am trying to copy MDF and LDF file from one server to another.
Initial On primary the DB was on C drive and on new server I was trying...
--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)

January 13, 2022 at 12:09 am

#3972591
Reply To: Solarwinds DPA talk

To be honest, I've never used such monitoring tools even before the compromise. I've always been fearful of such tools because of they all insist that they need such high...
--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)

January 13, 2022 at 12:05 am

#3972590
Reply To: ownership chain

You've been here for more than 12 years. Please learn how to post code in a code window so that it's easier to read. Here's the key when you're creating...
--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)

January 12, 2022 at 11:46 pm

#3972581
Reply To: Complicated Insert SQL with Calculations

"It Depends", Joe. Why recalculate something perhaps thousands of times per day if the answer isn't going to change that day? It's called "caching" and it's a time honored method...
--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)

January 12, 2022 at 11:32 pm

#3972579
Reply To: The same value across 5 or more columns in a table , How can I write a query

jcelko212 32090 wrote:
>> I got a table with 5 integer columns and one varchar(100) column. <<
Where is the DDL? I guess you want us to do everything for you , including...
--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)

January 12, 2022 at 11:07 pm

#3972572

Viewing 15 posts - 4,096 through 4,110 (of 59,098 total)