It is now entirely plausible to practically track our every movement using nano sized RFID chips or "nano dust", of the type developed by Hitachi, each of which contain...

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

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

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

I'm getting old so I have to stay away from open flame to avoid gaslighting. 😀

Dammit... I made myself hungry typing that.

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

It's funny... every once in a while, I go back for a look-see... I'm quickly reminded as...

In all seriousness, what is it that you think you want to monitor and what benefits do you think it...

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

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 :

<li style="list-style-type: none;">

<li...

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,...

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

Couldn't help be reminded of the old saying: "You can...

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