solved!

1st friday : (SELECT DATEADD(DAY, DECODE(EXTRACT(DOW FROM START_DATE), 0,5, 1,4, 2,3, 3,2 ,4,1, 6,6, 0), START_DATE) third_friday FROM (SELECT date_trunc('month',current_date) START_DATE))

2nd friday : (SELECT DATEADD(DAY, 7 + DECODE(EXTRACT(DOW FROM...

If you add the clustering before you add the data, make sure that you use WITH(TABLOCK) on the INSERT INTO statement to help take advantage of "Minimal Logging", which is...

Oh no.  You've miss understood a bit.  I wouldn't force a GUID out of row.

I'm not sure that I follow you regarding the comments column. The Comments column is a varchar(100). That the UpdatedBy column is a huge source of fragmentation is not...

Sounds like a typical generic post as a precursor to SPAM.  "Santa is watching"!

It's just an INSERT for C.R.U.D.  I suspect that the inset is sometimes being blocked or failing DRI (FK's) or some other constraint and it's simply not being reported.  The...

I Have created table along with trigger but the problem is its logging all system events. I want  only the users accounts who are logging into the database (DataMap)

Step...

I would not move a comments column to its own table.  That requires two tables and the comments table is going to frag like crazy just as it would if...

Here's another one, by Jack Worthen.  It's a bit more to the point.

https://jackworthen.com/2018/12/20/creating-a-logon-trigger-to-track-when-a-specific-account-is-connecting-to-a-sql-server/

Here's a "leader" article on the subject from MS.

https://docs.microsoft.com/en-us/sql/relational-databases/triggers/logon-triggers?view=sql-server-ver15

I'm finding all of this via Google.  You...

Here's a link about things that you can to do with login triggers and the like.  One of the things is to audit logins.

https://www.sqlshack.com/an-overview-of-logon-triggers-in-sql-server/

Note that if you're doing this...

I have this task to find all SPs, FNs, and VWs where particular string occurs in definition of the object. In 300 databases in a huge server.

How do you...

Unless this is a prelude to SPAM, your post is a bit contradictory.  You say you read a job description and also say that that it matches your abilities and...

Thanks for the feedback, Dave.

Just as an update, please see the following presentation where I destroy the myth of Random GUID Fragmentation and pretty much waste what people have been using as supposed "Best...

At $7K per core for such a license and the number of cores you have, you should spend a relatively tiny bit more and get yourself up to 512GB of...