Then you need to run an extended event session to capture the SQL statements during the load process.  You can then review those statements to see how they are updating...

One other point about AD groups...you can treat an AD security group as a 'role' in SQL Server instead of creating a role in SQL Server and adding the security...

How are these tables replicated/mirrored from the production system?  There has to be a process in place to insert/update/delete data - unless it is a 'full' refresh of the data...

You need to grant the users access to database mail - to do that you need to add the group to the msdb database and add them to the DatabaseMailUserRole.

Note:...

Why would you remove the PK constraint from a table?  That doesn't make any sense...

So - in your for-each loop all you are doing is creating the directory if it doesn't exist?  If so - then all you really need to do is move...

You can remove the CONCAT function or modify to use + to build that string.  That column isn't used.

I switched from Quest Litespeed back to native compressed - even on my 3TB+ system.  I...

Nothing - the hard-coded offsets are...

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

How are you determining what periods to include?  Are you looking for any charges that are due based on the current date - or something else?

Using what I previously posted...

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

Hi Steve, appreciate this article.  I realize it's getting close to a year old, so not sure if you will see this, but was curious about something...  It seems...

John,

I don't. MS has been very resistant to syntactic sugar, basically anything that isn't hard to program, they don't want to build and support. They think this is why...

How about something like this:

  Drop Function If Exists dbo.fnGetDates;
    Go

 Create Function dbo.fnGetDates (
        @fromDate...

If I am reading your function correctly - all it is doing is splitting the delimited string and returning the values as rows.  There is no reason to...

If I am reading your function correctly - all it is doing is splitting the delimited string and returning the values as rows.  There is no reason to do this...