One of the best advantages to having extra space available in the data file is that space can be utilized for index maintenance.  If you don't have enough space in...

If the transaction log had to grow during this process - you can find out what process initiated that growth using the default trace.  If there was no auto growth...

And here is one more method - using the second parameter of EOMONTH:

 Select *
      , fom_date = datefromparts(year(getdate()), dt.mth + 1,...

There isn't a need to build a tally table or calculate the month numbers.  That can be done simply using VALUES to return 0 through 11 or 1 through 12...

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

Amen -...

The application needs to pass the date/time as a datetimeoffset - but that won't provide you with the time zone.  All that gives you is the offset for that client...

If you can use VS to import the data - why do you need to use the import wizard?  BTW - the import wizard is not going to use a...

Thank you Michael, Jeffrey and ratbak.

@ Michael - thanks that makes more sense now, from your original post I was thinking I would see the parameter in plain text...

Look at the permissions on the folder and each report.  If the linked report is not inheriting from the parent folder - it may not have the correct permissions.  Since...

You might also want to look at Azure offerings - to see if those are workable and cost-effective.  Moving the database system and/or application servers to a centralized location is...

Unless you are performing multiple operations inside the loop - then there is no reason to begin/commit a transaction and really no reason to implement a try/catch.  Now - if...

In addition to Erland's comments - delete can be used to remove specific rows where truncate is all or nothing.  There are additional side-effects to be aware of with truncate...

The ideal solution would be to upgrade to Enterprise Edition - and then you could use a data-driven subscription.  Or you could build out a process using powershell to automate...

Those additional tabs are located under the Configuration tab.  Click on that - and you will see the additional tabs and be able to modify the settings.

With that said, there...

Homebrew01 - I have deleted the last "big" file but can try that if it does it again.

Micheal L John - no normal database activity. Nothing is purged unless...