Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,136 through 6,150 (of 59,072 total)

Reply To: How to minimize the SQL Server log growth

892717952 wrote:
Yes, the target table has a identity column, the said "disable" identity column means I set the identity column No under the table's identity specification.
actually, the indentity column is...
--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)

November 1, 2020 at 5:00 pm

#3803325
Reply To: How to minimize the SQL Server log growth

There is no "Disable" for Identity columns. Either it exists or it does not. The best you can do if it exists is to SET IDENTITY_INSERT ON when trying 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)

November 1, 2020 at 2:41 am

#3803232
Reply To: How to minimize the SQL Server log growth

You do realize that by setting your database to SIMPLE that you just broke your logfile chain if one existed, right?
Shifting gears back to the problem at hand.... what is...
--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)

November 1, 2020 at 1:43 am

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

I'm getting old so I have to stay away from open flame to avoid gaslighting. 😀
--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)

October 30, 2020 at 9:11 pm

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

Dammit... I made myself hungry typing that.
--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)

October 30, 2020 at 4:02 pm

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

Thom A wrote:
I must admit, I tire of seeing the same questions on SO day in day out at times, along with the lack of people that have heard of 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)

October 30, 2020 at 4:00 pm

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

Steve Collins wrote:
Someday maybe I'll revisit SO but for now I'm just sick of it.
It's funny... every once in a while, I go back for a look-see... I'm quickly reminded 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)

October 30, 2020 at 2:55 pm

#3802842
Reply To: Foglights

astrid 69000 wrote:
Hi,
We are looking into the monitoring software foglights? any thoughts?
In all seriousness, what is it that you think you want to monitor and what benefits do you think 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)

October 30, 2020 at 2:49 pm

#3802840
Reply To: How to improve the performance of insert?delete?update sql statement

As a bit of a sidebar, if you're updating the proverbial "millions of rows", it may be better to disable most (not the ones that are unique because they may...
--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)

October 30, 2020 at 2:35 pm

#3802836
Reply To: How to improve the performance of insert?delete?update sql statement
892717952 wrote:
as it was said in the title, which we should pay attention to when optimizing insert?delete?update sql statement? thanks
The following points is what I know :
--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)
October 30, 2020 at 1:56 pm

#3802830
Reply To: How to improve the performance of insert?delete?update sql statement

ScottPletcher wrote:
One thing to look out for is UPDATEs that significantly expand the size of varchar columns because that can cause page splits which can be a real performance issue,...
--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)

October 30, 2020 at 1:36 pm

#3802829
Reply To: Index question

Admingod wrote:
Table has around approx 2 million rows over a million column in the index has a single value and the top 3 values overall cover 3/4 of all records....
--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)

October 30, 2020 at 12:53 pm

#3802803
Reply To: Building Quality In

david.edwards 76768 wrote:
Jeff Moden wrote:
In other words, "Make it work, make it fast, make it pretty... and it's not done 'til it's pretty".
Couldn't help be reminded of the old saying: "You can...
--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)

October 30, 2020 at 2:09 am

#3802679
Reply To: Comparing consecutive datetime rows for schedules

Michael L John wrote:
There's a lot here. I'm not sure I am 100% clear about what you are looking for. I will take stab at what I think I understand you are...
--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)

October 30, 2020 at 1:13 am

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

Lynn Pettis wrote:
Steve Collins wrote:
My goal is to come up with questions
Weird, the message above is not the message in the email notification which is this:
My new goal is to come up...
--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)

October 29, 2020 at 9:26 pm

#3802621

Viewing 15 posts - 6,136 through 6,150 (of 59,072 total)