Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,871 through 3,885 (of 59,067 total)

Reply To: SQL Files open in a new SSMS instance

evans911 wrote:
This is a recurring pain for many regardless of the version of SSMS! After struggling with this inconvenience for too long and striking out in Google, I found 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 21, 2022 at 1:19 am

#3986161
Reply To: show percentage between 2 fileds

Please consider the possibility of SQL Injection, especially on @Table2.

--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 21, 2022 at 1:03 am

#3986160
Reply To: When update table small number of rows it take too too much time how to handle ?

It looks to me like you're forming a ton of accidental cross joins in the form of many-to-many joins because of the insufficient join criteria of partid = partid.
--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 18, 2022 at 7:34 pm

#3985573
Reply To: Need some example or answer for this doc

Michael L John wrote:
Oh, great. So you found someone else's work to turn in as your own for a school assignment.
Heh... he's late. The document says that it was due in October...
--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 17, 2022 at 9:20 pm

#3985114
Reply To: IoT Pros and Cons

Ed Wagner wrote:
I think what concerns me most about the IoT is security. They have lightbulbs and thermostats that connect to your wireless network. They call to their home server 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 17, 2022 at 9:10 pm

#3985112
Reply To: Do You Still Use CHAR?

Thanks, Johan. That sounds like one of the many reasons why I stopped working in the front-end world. Having been one long ago, I appreciate what they actually have 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 17, 2022 at 4:07 pm

#3984983
Reply To: Are the posted questions getting worse?

Thanks for the explanation, Steve. I appreciate it.
But, aren't notifications working "just fine now"?
--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 17, 2022 at 4:04 pm

#3984982
Reply To: Are the posted questions getting worse?

If you've not had scale issues, then why all the business about limiting notations and shutting down notifications on old posts?
--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 17, 2022 at 5:03 am

#3984731
Reply To: Are the posted questions getting worse?

Steve Jones - SSC Editor wrote:
Asked the question as part of the triage and planning for this work about how many threads might be affected, or might be exceptions.
Perhaps you should read the article
--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 5:05 pm

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

Viewing 15 posts - 3,871 through 3,885 (of 59,067 total)