Forum Replies Created
Viewing 15 posts - 31 through 45 (of 58,872 total)
-
Reply To: Learning to Grind
I think people have been going a bit nuts for the last 15 or so years and especially in the last 6 or so years. I just found out about...
-
Reply To: Are the posted questions getting worse?
Too much fun, Michael!
-
Reply To: The Random Rows
I have to disagree with the answer here. If you run the code more than once, it comes up with the same 10 rows. Therefor, they are NOT "random rows"....
-
Reply To: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner
MMartin1 wrote:Hey Jeff, was simply responding to the question on the scenario you posed.
Totally understood and I was just answering the new question.
Just to say it again, there is no...
-
Reply To: The Paradox of NOLOCK: How Dirty Reads Can Sometimes Be Cleaner
andrew gothard wrote:Try fixing things, rather than breaking them further.
Now that, I agree with!
A lot of people immediately respond with "Well, just turn on RCSI". Folks really need to be careful...
-
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,...
-
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...
-
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,...
-
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...
-
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... -
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...
-
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...
-
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.
Viewing 15 posts - 31 through 45 (of 58,872 total)