Lookup the MERGE command.

Functions perform operations in a row by row manner as opposed to a set at a time. This is slow and not needed.

I am not sure how...

It may fragment some indexes and not others.  You certainly don't want to automatically rebuild every index.  Also, rebuild from smallest to largest of the indexes that do need...

A very good link has been provided.

If you have your log file on its own volume another thought would be , just to put it out there, a powershell script...

Few best practices to optimize SQL DB performance

- Reduce Table Size - Simplify Joins - Use SELECT Fields FROM Instead of SELECT * FROM - Use EXISTS() Instead of...

Since you are on 2017 pressumably , navigate to your database (in explorer) and drill down to the Query Store. There you will find the most expensive queries by cpu...

I cant even make sense of what the data is supposed to render to. I cant make out any columns in the desired output. Please put in time to present...

Please create a entity relationship diagram explaining what the tables are and what certain columns mean. and how they are related/joined.

Provide a simple case of input data and what the...

What section and step within the documentation are you at ? Is this transactional replication ? Is it push or pull subscription ? Where is the distributor  ?

"I'd like to create a column that will list every Monday (start of week) from the enrollment start date to the end date. If no end date, then it will...

I had a scary experience with CPU on a database server reaching 100% due to bad plans from badly written code. I have had all members of my team looking...

Test out the solution I provided with data that varies in the first few columns and adjust the pivot experssion as needed.

For dynamic SQL, try the following >

declare @sqlStart nvarchar(200)=
'Select *
FROM    (Select custID, staffId, jobID, dt, sum(units) as units      ...

One of my favorites was a project I did earlier in my career. What made it special was that I was learning as I went along and was given the...

Indeed from Microsoft Docs ---

"> 0 = FILLFACTOR percentage used when the index was created or rebuilt."

The key term to notice is 'rebuilt.' So...

Thank you for the article. This is nicely explained. However I have a couple of questions.

The basic template is

CREATE [OR REPLACE] FUNCTION function_name (arguments) 
RETURNS return_datatype AS...