Jeff Moden

Forum Replies Created

Viewing 15 posts - 286 through 300 (of 59,099 total)

Reply To: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner

MMartin1 wrote:
Jeff. I'll take a crack at your question:
In your example, are you assuming the date column is indexed and would be used? What if that is not the case,...
--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)

December 11, 2024 at 7:15 am

#4496453
Reply To: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner

Randolph West wrote:
Jeff, with RCSI enabled, it’s barely if ever necessary.
Agreed... all you have to do there is accept an extra 14 bytes per row and extra usage of TempDB. Since...
--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)

December 10, 2024 at 4:05 am

#4495774
Reply To: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner

rick-1071254 wrote:
On what grounds?
Uh, because the data is right, and the implementation is right.
You set up a straw man, where this condition applies, and you don't care about this,...
--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)

December 10, 2024 at 4:04 am

#4495773
Reply To: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner

The responses are as expected... some hardcore "NEVER"s.
To those people, I ask, if you want a simple report, say the number of products purchased by day for the previous calendar...
--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)

December 10, 2024 at 1:14 am

#4495722
Reply To: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner
With regard to the following code from the article...
```
CREATE PROCEDURE dbo.GetDashboardStats
AS
BEGIN
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT 
(SELECT COUNT(*) FROM Orders WITH (NOLOCK) 
WHERE OrderDate = CAST(GETDATE() AS...
```
--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)
December 9, 2024 at 1:46 am

#4495181
Reply To: Why Would You Do That?

It's gotten to the point where I evaluate changes by determining how much harm the change causes or how little a required change brings to the table compared to 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)

December 9, 2024 at 1:08 am

#4495171
Reply To: Which selection criteria is more efficient.
Just do a test.
```
SET STATISTICS TIME,IO ON:
Put code to be tested here.
SET STATISTICS TIME,IO OFF:
```
Do NOT use this method if any functions that contain the word BEGIN...
--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)
December 8, 2024 at 6:51 pm

#4495077
Reply To: Table Delete

Using YEAR and MONTH Functions:
I'm going to seriously recommend NOT doing it that way. Use the Date Range method, instead.
--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)

December 8, 2024 at 6:02 pm

#4495067
Reply To: NC index creation duration question

You do realize that the addition of the new index requires space that might not have been available and that dropping the first NCI made a bunch of space available,...
--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)

December 8, 2024 at 5:51 pm

#4495059
Reply To: Trigger After Update to Update the Updated Table

EDIT: Looks like Steve posted while I was working on replies. Leaving this reply here even though it overlaps with Steve's pose.
FOR and AFTER are identical in meaning.
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql#arguments
You're trigger 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)

December 8, 2024 at 5:42 pm

#4495054
Reply To: The Pervasive Nature of Open Source

From the article:
And most people rarely upgrade their OSS. They get something that works and don't want to change. I get that, as I feel the same way...
--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)

December 8, 2024 at 5:11 pm

#4495051
Reply To: DigitsOnlyEE and AlphaNumericOnly

ARM07470 wrote:
You can simplify the WHERE clause in AlphaNumericOnly and AlphaOnly by taking advantage of the fact that upper and lower case letters differ only by the 6th bit, which...
--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)

December 7, 2024 at 7:58 pm

#4494768
Reply To: DigitsOnlyEE and AlphaNumericOnly

I'm a little late here but great observation, Anthony. I'll have to give that a try.

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

December 7, 2024 at 6:57 pm

#4494731
Reply To: Blob Storage automated downloads

Brandie Tarvin wrote:
...even Microsoft stuff has to go through a testing / peep process here.
From the looks of things, MS hasn't done a good job on QA since 2017.
--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)

December 5, 2024 at 10:12 pm

#4493883
Reply To: How can I see a DEPENDENCY TREE for objects used inside SP1 Stored Proc, and for each object referenced further inside each object, etc.?

Does Example 7 of the following article do it for you?
https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

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

December 3, 2024 at 2:35 pm

#4492670

Viewing 15 posts - 286 through 300 (of 59,099 total)