Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,676 through 9,690 (of 59,099 total)

RE: How Long is Too Long?

David.Poole - Saturday, March 16, 2019 4:08 AM
Many speakers are volunteers. Putting together a quality presentation takes time and effort that 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)

March 16, 2019 at 8:43 am

#2024693
RE: Date Range Consolidation Query

It's an older article but still one of the best ways to do such a thing as you ask. Please see the following...
https://blogs.solidq.com/en/sqlserver/packing-intervals/
--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)

March 15, 2019 at 6:52 pm

#2024673
RE: Dealing with Technical Debt

Steve Jones - SSC Editor - Friday, March 15, 2019 9:39 AM
Jeff Moden - Thursday, March 14,...
--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)

March 15, 2019 at 4:43 pm

#2024671
RE: Dealing with Technical Debt

xsevensinzx - Thursday, March 14, 2019 11:15 PM
It's often hard to do it right the first time. A lot of the large...
--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)

March 15, 2019 at 4:33 pm

#2024670
RE: Sql Query to find invalid SSN Numbers

Lynn Pettis - Friday, March 15, 2019 8:32 AM
roger.plowman - Friday, March 15, 2019 6:50 AM
--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)

March 15, 2019 at 9:35 am

#2024597
RE: How Long is Too Long?

As with all else concerning SQL Server, "It Depends". Some subjects can be adequately covered in a lightning round in only 10 or 15 minutes. Sometimes, even shorter. Other's aren't...
--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)

March 15, 2019 at 7:33 am

#2024563
RE: Removing tempdb files

frederico_fonseca - Friday, March 15, 2019 5:00 AM
Steve does mention the constraint on the answer "Note, if the file is not empty,...
--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)

March 15, 2019 at 6:54 am

#2024555
RE: Removing tempdb files

It'll be interesting to see how people answer this one because the correct answer won't actually work on a busy system because the file will not be empty.
--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)

March 14, 2019 at 11:56 pm

#2024530
RE: Building Better Stored Procedures

astruthers 75845 - Thursday, March 14, 2019 9:26 PM
Jeff,
Just tested, and stand by what I said.
-- Comments before Create\Alter statement
CREATE PROCEDURE sp_Bletch
@BrandID...
--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)

March 14, 2019 at 10:35 pm

#2024528
RE: DBA Job interview question thoughts

peter_parker - Tuesday, March 12, 2019 3:50 PM
Just out of curiosity how big a whiff would you consider not knowing the difference...
--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)

March 14, 2019 at 10:18 pm

#2024527
RE: The Soft Skill of Respect

What your great article ultimately describes (IMHO) is a properly implemented DevOps culture, which has been mistaken by most and demoted to mean a set of tools. I take 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)

March 14, 2019 at 9:50 pm

#2024526
RE: Sql Query to find invalid SSN Numbers

Sean Lange - Tuesday, March 12, 2019 1:03 PM
Jeff Moden - Tuesday, March 12, 2019 12:00 PM
--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)

March 14, 2019 at 9:34 pm

#2024525
RE: Sql Query to find invalid SSN Numbers

roger.plowman - Wednesday, March 13, 2019 6:49 AM
Of course, you could always take the brute force approach. 🙂
Create a table with all...
--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)

March 14, 2019 at 9:29 pm

#2024524
RE: Dealing with Technical Debt

Steve Jones - SSC Editor - Thursday, March 14, 2019 11:39 AM
There are definitely issues with management, but there is also time...
--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)

March 14, 2019 at 9:26 pm

#2024522
RE: Building Better Stored Procedures

astruthers 75845 - Thursday, March 14, 2019 2:24 PM
In your example, those notes that come BEFORE the ALTER\CREATE statement are lost.
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)

March 14, 2019 at 9:08 pm

#2024521

Viewing 15 posts - 9,676 through 9,690 (of 59,099 total)