Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,726 through 4,740 (of 59,089 total)

Reply To: Speeding up Query

As a bit of a sidebar, the TOP thing may have been someones attempt to "set a row goal" to trick the optimizer into doing a better job. The thing...
--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)

September 2, 2021 at 1:34 am

#3926131
Reply To: Reclaim disk space after truncate

kirti wrote:
Hello,
We have truncated a huge table (50+ million) rows in sql server which was created for testing purpose.
However the disk space is not released back.
Any pointers on how 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)

September 1, 2021 at 10:53 pm

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

Shifting gears a bit and speaking of the community on this site, someone made a new addition to Wiktionary a month or so ago. I'm sure that most of you...
--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)

August 31, 2021 at 3:01 am

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

My comment was to Grant and was meant as a general comment. If you'd like to quantify it, go back to the testing that I did that was mostly ignored...
--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)

August 31, 2021 at 2:58 am

#3925313
Reply To: Send private message to another site member

Thanks, Steve. I really appreciate it. Are there similar links for "followers" and "following"?

--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)

August 31, 2021 at 2:41 am

#3925310
Reply To: Send private message to another site member

That's fantastic. How do we read old messages? I'm not seeing it anywhere in my profile. It's entirely possible that this ol' brain forgot something so I'll ask, do you...
--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)

August 30, 2021 at 9:32 pm

#3925270
Reply To: Performance degradation with a particular stored procedure

tarr94 wrote:
I have noticed that rebuilding indexes on a couple of the tables referenced in that query statement can improve performance temporarily.
That causes a recompile of anything that uses...
--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)

August 30, 2021 at 4:57 pm

#3925169
Reply To: how can we use SQL server's log to trace user's operation?

Grant Fritchey wrote:
You can't really track user behavior through the logs. Without specialized tools, you can't view the information in the logs. That's really not what the logs are for. It'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)

August 30, 2021 at 4:49 pm

#3925165
Reply To: how can we use SQL server's log to trace user's operation?

892717952 wrote:
I set my sql server recovery mode as FULL,so all of the logs will be fully recorded. if so, how can I use the log to track if users'...
--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)

August 30, 2021 at 4:46 pm

#3925163
Reply To: which operations will use more CPU resource?

892717952 wrote:
in SQL Server, which operations will use more CPU resource? it seems that compilation and recompilation will lead to high CPU workload. are there any other operation will cause...
--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)

August 30, 2021 at 4:36 pm

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

Michael L John wrote:
I'm betting that SSC is not a great marketing tool for Redgate.
It used to be and could be/should be again.
--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)

August 30, 2021 at 3:14 pm

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

J Livingston SQL wrote:
Redgate has grown to be a very successful company with a declared profit of 9.7M GBP in 2019 Fin Year....so it's not like they couldn't afford to sort many...
--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)

August 30, 2021 at 2:02 pm

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

Michael L John wrote:
frederico_fonseca wrote:
Michael L John wrote:
I was on the Visual Studio marketplace the other day. Stumbled across this tool.
https://marketplace.visualstudio.com/items?itemName=MAQSoftware.SQLCodeCheck
I was hoping it would be a simple tool to root out basic...
--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)

August 30, 2021 at 1:54 pm

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

Grant Fritchey wrote:
J Livingston SQL wrote:
So, my personal and heartfelt request as a member of "the community that was", I'd love it if you and JLS (another recent revisitor) and a host...
--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)

August 30, 2021 at 12:37 pm

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

I new they were moving the Microsoft Feedback site from "user voice" to something else but all of my feedback links now lead to the following stupidity...
https://azure.microsoft.com/en-us/feedback/
Clicing on the...
--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)

August 30, 2021 at 1:15 am

#3924886

Viewing 15 posts - 4,726 through 4,740 (of 59,089 total)