Oh yeah... and big time!  There are many reasons why such a thing may happen.  For...

Your question is easy to ask and can take years to answer.

It sounds like you could stand a lesson on what an "Execution Plan" is.  Please see the following link...

I was running a SP and I got this.  This is the first time I have ever received this.  What does it mean?  How do I fix it so...

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 2 years, 2 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...