Yeah... that's what I thought.  First post was a "setup" for the spam.  I left the original post so that people can see what one of these setups looks like.

I agree that ChatGTP operates from a "consensus of opinion that exists in the internet".  While I'm equally impressed as Eric, that means that it's frequently seriously incorrect, just like...

This is the code which is creating the problem (bridgid is bigint ,remaks is varchar(250) status smallint) in both the tables mentioned below.

 INSERT INTO KKR
...

Previous post deleted.. I just realized that this is spam.

I also took a look at just one of the questions and answers (question 8)... I didn't look at all the...

• This reply was modified 3 years ago by Jeff Moden. Reason: Sudden realization of what this post really is

Good lord.

Thanks for the...

I don't have an answer. "Bumping" this bad boy for you.

That's handy, Michael, but we're not ready as a company to embrace the use of PowerShell.   I'm going to create a new table that we can refresh via a...

Hi, thank you for your replies.

We already have a legacy software to keep track of time/attendance. But it has some limitations.

It can monitor employee hours, absence , overtime, etc.

The...

Thanks Jonathan. A followup question, why shouldn't care about index fragmentation on indexes which has 1000-5000 page count ? I have read somewhere or some video, i dont remember. ...

Just to be sure....

For the love of all that is holy in SQL Server, do not give individual users privs to execute xp_CmdShell in an unsupervised manner.  Have them write...

Awesome and thank you kindly for the feedback.  Nicely done on your part, as well.

If this isn't a prelude to spam (like I think it may be), then don't target salary... target what you like to do because you're going to have to do...

Right - but only the checksum column is keyed. With the number of collisions in checksum I would think you would hit a point of maximum entropy in index...

I am skeptical that pre-fragmenting the index to 20% fragmentation with the 80% fill-factor is preferable to a relatively small amount of fragmentation that would result from changes to...