Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,916 through 3,930 (of 59,098 total)

Reply To: SQL Log File Too Big

I know it was mentioned in the article but it needs to be stressed a bit. One of the biggest reasons for massive log file sizes IS index maintenance and,...
--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)

February 16, 2022 at 4:28 pm

#3984429
Reply To: slow update query

sqlfriend wrote:
table and script trigger attached.
Thanks
Where? I see no attachments anywhere on this thread,
--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)

February 14, 2022 at 10:21 pm

#3983593
Reply To: slow update query

sqlfriend wrote:
Also the trigger is to add logs to another table. This is usually used when user change address from user interface web site, so it is usually one record...
--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)

February 14, 2022 at 9:55 pm

#3983587
Reply To: Help SP Logic and performance

Bruin wrote:
Yes collation fix helped...
"Second, look at the stuff in the SELECT list and FROM clause... basically, it's all a repeat of the same thing with a different qualifier. 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)

February 14, 2022 at 9:47 pm

#3983584
Reply To: Communication link failure but only once per week

Which edition of SQL Server are you using and what are the parameters you're using for the "reindexing job"?
--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)

February 14, 2022 at 8:18 pm

#3983556
Reply To: Beginner Query SQL

The sample rate is at roughly a half second. It's hard to tell what the actual data is from the graphic you posted but are they actually recording the 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)

February 14, 2022 at 8:09 pm

#3983555
Reply To: slow update query

sqlfriend wrote:
I recently tried to run a update statemene with joins on a table that has 200,000 records. I suppose it should be very quick.
But it turned out it ran30...
--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)

February 14, 2022 at 7:55 pm

#3983551
Reply To: Help SP Logic and performance

Bruin wrote:
Big improvement, do you see anything else that could be tweaked?
Many thanks for suggestion.
Two way street, first... what does the code look like now that you've improved it?
[EDIT] Either...
--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)

February 14, 2022 at 7:45 pm

#3983550
Reply To: Problems connecting SSAS 2017 to msmdpump.dll

Post deleted. I missed the fact that the post I answered was a spam post.
--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)

February 14, 2022 at 7:13 pm

#3983532
Reply To: How to handle rolling back changes if there is an error?

You're using SQL Sever 2019... that means that there's little need to do such things using the likes of C#. Please see the following article and look for the 2019...
--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)

February 14, 2022 at 7:11 pm

#3983531
Reply To: Help SP Logic and performance

Try this as a start... How to Post Performance Problems , which might also give you a hint on how to start troubleshooting performance issues 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)

February 14, 2022 at 6:51 pm

#3983524
Reply To: Do You Still Use CHAR?

below86 wrote:
Jeffrey Williams wrote:
below86 wrote:
I didn't have any issues with CHAR columns lately, but we have had to adjust the size on our claim number(was char(8)) and policy number(was char(9)) sizes...
--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)

February 14, 2022 at 6:04 pm

#3983520
Reply To: Yearly Uptime of Four Nines

Heh... plenty of time each week to do index maintenance, right? 😀 😀 😀
After almost 25 years, I wish MS would finally study Peter Norton's works and write something much...
--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)

February 14, 2022 at 5:50 pm

#3983489
Reply To: Do You Still Use CHAR?

@rick,
I remember those days but that's actually a really bad example for system of today. Anyone that actually stores dates as a CHAR() in their normal database tables needs to...
--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)

February 13, 2022 at 5:19 pm

#3983061
Reply To: Do You Still Use CHAR?

Rick, please tell me that you're not advocating a "panacea length" for VARCHAR(N) where "N" is something like 256. Please tell me you're not advocating the NUMERIC(18,N) should be a...
--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)

February 13, 2022 at 1:39 am

#3982911

Viewing 15 posts - 3,916 through 3,930 (of 59,098 total)