What is logged in the SQL Error log for both (and previous) backup runs? Look for something similar like "BACKUP DATABASE successfully processed 3824 pages in 0.376 seconds (79.440 MB/sec)."...

In general the I/O is the limiting factor with backup operations. Does the size of the backup file differs much between the last and the previous one? Did you specify...

Can you show us the PARTION FUNCTION and the PARTION SCHEME (preferable by posting the DDL statements)? Without the definitions it is not possible for us to help you with...

The main question is: what were the actions executed on the database during the growth of the LOG file? Active transactions prevent a log-backup from releasing space inside the LOG...

Does the database consists of multiple files and/or multiple filegroups? When you want to shrink databasefiles using the GUI it will default show only the first datafile of the PRIMARY...

Are you able to modify the [tblMonth] to a more general calendar table (like this sample[/url])? That will allow you to join the table and use it as filter on...

Don't forget to look at the "Notifications" defined in the properties of each jobstep. Besides using the profile (by calling the sp_send_dbmail) through code, it could also be defined in...

With NTILE you are able to split the selection in groups of three. With a CASE statement on this NTILE column you can move the specific rows to columns. The...

I guess the different results are because the [tempdb] is always using the collations as set at instance level. So as soon as the queryplan decides to use the [tempdb]...

Go back to the source ;-). Ask the one who gave you the RAR file to unzip it, restore the BAK and just deliver the...

The weeknumber is determined different around the world, mostly depending on what is considered as first day of the week. Check the LOCALE settings of both environments.

information: http://www.epochconverter.com/weeknumbers

HappyGeek (10/21/2016)

---

Is it possible to make contingency for when SQL sends a mail as a result of an alert but the mail server simply fails to deliver? I think I...

The query below shows information about how mail has been processed according to SQL Server (see [sent_status] column). But if the mail failed on the SMTP-server without a proper feedback...

Your answer is perfect if you need to filter for the past 24 hours. As...

BLandry474 (10/21/2016)

---

... Right now this is all done by 'eyeball' and I thought if I had a good query that could examine a column and its length, then be...