you need 'tempdb..#xxx' when checking for object existence.

e.g. if object_id('tempdb..#xxx') is not null drop table #xxx;

other than the case above you do not need to reference tempdb.. and you...

You can review the SQL Server logs through notepad to see why SQL Server is not starting.  My guess is that you have added one or more trace flags incorrectly...

The first part of the problem is how you are generating the tally - you are generating too many rows.  The second part of the problem is the return from...

In your original post - you stated that the database engine was not used.  However, it seems it is being used - probably by SQL Server Agent and the MSDB...

What is the state of the primary database - not the secondary database?

Did you see what I posted?

The error tells you what the problem is - the database in production is set to single user.  After restoring the database in production - change it to multi-user: ALTER...

What about using a GIT repository?  You get the advantage of being able to search the code as well as versioning, branching, etc...

I start with how many full backup files I want to keep local to the system - then what process will be utilized and how will that affect the storage. ...

Taking Jeff's sample data and example using STRING_AGG:

   With ctePreAgg 
     As (
 Select CountryID
      ,...

• This reply was modified 5 years, 6 months ago by Jeffrey Williams.

It's a good question. I don't get to decide, the business do. The rules are arbitrary so I have to use a fixed table, in fact several. This (table...

Since a view is just a named query - it will be optimized into the outer query referencing the view.  If there are tables/views/columns that are not utilized in the...

You are welcome - which version did you end up using?

Look at the function STRING_AGG which should do exactly what you are needing.

You may be interested in this script: https://www.sqlservercentral.com/?p=3787591&post_type=ssc_script&preview_id=3787591

This script generates the calendar for a 3 year period - with the ability to restate the calendar - and generates the 4-5-4,...