Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,466 through 3,480 (of 59,086 total)

Reply To: "Frankenrows"

julian.fletcher wrote:
We have about 160 instances of "WHERE (1 = 1)" or "ON (1 = 1)" in our code base and 950 of "CROSS JOIN".
The code base has about 2.6m...
--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 23, 2022 at 6:02 pm

#4037769
Reply To: LDF is not automatically shrinked with simple recovery mode

mnemonicator wrote:
Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have simple recovery mode. Problem is that transaction log file is not shrinked automatically, current size...
--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 23, 2022 at 5:38 pm

#4037745
Reply To: Server slowness questions

To seriously summarize, it looks like you have a bit of a hot mess on your hands and you have no clue as to where to even start looking. I...
--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 22, 2022 at 7:14 pm

#4037220
Reply To: Server slowness questions

I agree that MS says the 15 second warnings are only due to hardware. I have no actual written proof but we've tested. All our stuff is on some killer...
--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 22, 2022 at 7:06 pm

#4037219
Reply To: how to troubleshoot slow running stored proc

Run it manually once with the execution plan turned on.
Also, look into Brent Ozar's "First Responder Kit". It's free and the code is open for you to use to learn...
--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 22, 2022 at 6:43 pm

#4037216
Reply To: query perf issue

Let's see this simple query that you're talking about. See the article at the second link in my signature line below.
As for all the excuses you gave for their queries,...
--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 22, 2022 at 6:33 pm

#4037215
Reply To: How to check the load on sql server

bobrooney.81 wrote:
Anyone has any perfmon.msc file to measure how busy is my sql server?
I do... but PerfMon is a picky thing... what works on one box frequently doesn't work on...
--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 22, 2022 at 5:26 pm

#4037198
Reply To: How to check the load on sql server

bobrooney.81 wrote:
How can sp_whoisactive help?
Have you searched for it yet? No sense in me repeating something that's readily available. 😀 Reading about it is a lesson about SQL Server in...
--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 22, 2022 at 5:23 pm

#4037197
Reply To: High cpu of 90-95% on SQL Box

bobrooney.81 wrote:
How to identify if it is M.A.R.S and disable it?
There may be another way but we had our developers check the actual connection strings they were using. It was...
--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 22, 2022 at 5:17 pm

#4037196
Reply To: Job Interviews: What is Normalization?

If someone were to ask me what normalization is during a job interview, that would be one of the mental check-boxes that I'd check of for reasons why I might...
--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 22, 2022 at 5:59 am

#4037003
Reply To: Worst Practice - Spaces in Object Names
Just my 2 cents...
1. I hate anything that has to do with making me type something extra. And, no... I also don't use Underscores as a replacement character for spaces,...
--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 22, 2022 at 5:04 am

#4037001
Reply To: PLE counter

See the following article by Brent Ozar and the links he has for some of Paul Randal's articles on the subject.
https://www.brentozar.com/archive/2020/06/page-life-expectancy-doesnt-mean-jack-and-you-should-stop-looking-at-it/

--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 22, 2022 at 4:41 am

#4036997
Reply To: How to check the load on sql server

Save yourself some time... Look for Adam Machanic's "sp_WhoIsActive" code.
--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 22, 2022 at 4:40 am

#4036996
Reply To: High cpu of 90-95% on SQL Box

A single CPU going to 90-95% is expected. Are you saying that the total of ALL CPU's is what's going to 90-95% or just one now and then?
If so, check...
--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 22, 2022 at 4:36 am

#4036995
Reply To: Looking for some guidance on avoiding Scalar UDFs for DB lookups

Are Items A thru F all in a single parent-child table?
--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 22, 2022 at 4:17 am

#4036978

Viewing 15 posts - 3,466 through 3,480 (of 59,086 total)