Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 59,067 total)

Reply To: SET LANGUAGE failed because '' is not an official language name or a language alias on this SQL Server

txustopo wrote:
In case it is of help to anyone.
My problem was the case sensitive, ENGLISH or ITALIAN is not valid but English or Italian work OK.
Hi and welcome aboard. That's...
--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 7:45 pm

#4037821
Reply To: query perf issue

siri_28 wrote:
not like that. if the user comes back will provide the data.
But in general, it is obvious that when data is less and return rows from it will take...
--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 7:41 pm

#4037820
Reply To: Thoughts on how to pivot from a SQL Server DBA role to something more.

I'm not sure that I'd trivialize the roles of Data Scientist or Data Analyst like that. I know a whole lot of people that write some great T-SQL that would...
--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:29 pm

#4037780
Reply To: Best way to learn T-SQL for MS SQL Server?

"Best way to learn T-SQL for MS SQL Server"?
Start at the beginning. See the following link with the understanding that it does cover more than just T-SQL and some of...
--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:22 pm

#4037777
Reply To: How to handle sticks on column country1 and country2 columns ?

ahmed_elbarbary.2010 wrote:
my key is company and year and rev and not repeated
What, from your example code, would constitute "repeating data"? If the answer is "none of it", then we need...
--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:14 pm

#4037774
Reply To: want to know top 10 high memory queries

DesNorton wrote:
Try taking a look at theses 2 management views. Change the ORDER BY in your queries to get highest use per I/O, CPU, Memry sys.dm_exec_query_stats
--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:09 pm

#4037772
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

Viewing 15 posts - 3,436 through 3,450 (of 59,067 total)