We have a rebate program where I need to calculate sales based on the date the customer joined the program. Ex: Customer A joins the program on October 5th,...

Thanks for your kind reply, I got understanding about how it works now.

Do you have any information on how to create jobs for taking the full backup+ transaction backup...

If you read the text in my post, I tell you.

Heh... and people wonder why data storage is exploding.  The only good thing about it is that it has only half the tag bloat of XML but, lordy, what a...

Taking full backups does not backup the logfile over time.  If you're in the SIMPLE recovery model, then the log file will be self truncating whether you take full backups...

Post withdrawn because I don't actually know much specifically about VEEAM and didn't want to provide any misleading info.

• This reply was modified 1 years, 11 months ago by Jeff Moden.

The only correct answer is "It Depends".  I recommend that you lookup what the abbreviations RPO and RTO are for starters.  Also, find and read up on the Full, Differential,...

I am a SS rookie.  To me it seems like running a query in parallel whenever possible is a great idea b/c that way more work can be done...

It would be interesting to know more about that.  Usually, it's a serious mistake that can be...

This reminds me of the good ol' days on these forums... thanks for the memories, folks.

If you install this DateRange function, this gives certainly the shortest SQL if not the fastest

select CONVERT(date, d.value) Date, 
   ...

IMHO, Steve Collins' post (with a tiny tweak (change fn.n to fn.value) in the 2nd bit of code) contains the winning entries for simplicity IF you don't mind any missing...

My opinion though - SQL Server and xp_cmdshell is an odd tool to use for downloading files from sharepoint... Powershell is a much better way to do it in...

I have a Job running a Maintenence Plan. The plan performs the Backup Database, Check database Integrity, Maintenence Cleanup and Reorganise Index tasks. Occasionally the Reorganise Index task fails...

I don't use Rubrik but any decent tool will turn off the "A" (archive)...