Is it Monday?  It seems like Monday.

One of my DBA's set up a SQL account, with db_owner on a database in production.  The contractors have now raised havoc with...

Heh... "To err is human.... to really *&*&%^$%! things up, you need a computer". 😀

p.s. SQLProfiler isn't "dangerous".  People that don't know what they're doing with either SQLProfile or Extended Events are what's dangerous. 😀

Sometimes, even a good healthy dose of magic pixie dust can't break through a mountain of...

In a word, No. There are much better ways...

regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month

can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.

older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range

I can't reply...

I recommend that you don't make...

p.s.  I also notice in one of your previous posts above that the table has 4 non-clustered indexes... that's likely where the page splits are coming from.  Considering the very...

Yes. Its a small table.  Question is , when there is 0 rows in the table, and when we say SELECT * FROM <Tname> , why SQL Server is...

@eliob ,

Your post actually sounds like it was created by ChatGPT. 😀  And then we see the SPAM link that you included. 😀  So that others may learn, here's the...

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 2 years, 11 months ago by Jeff Moden. Reason: Sudden realization of what this post really is

Good lord.