I suggest to build a new SQL instance in a VM. Next set the instance specific settings (like sys.configurations kind of stuff, but also LOGINs and server-level permissions) to the...

It has been a while when I created the script below together with my co-worker. We used it to forecast growth of disk usage of which the measured values were...

Lynn Petttis has an article about common date routines:
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

The query below shows some (date/)time manipulations. Each column in the query is part of...

If you manually run a package from within Visual Studio (or SQL Server Data Tools) the execution is done in debug mode. Even after all tasks are finished the execution...

N.B. (12/16/2016)

---

First I want to apologize - this entire situation is the vendor's fault, and not something we can change.

I have a table where, depending on the value in one...

I'm not able to test because I don't have a computer at hand.

But is the 'testuser' account added as a user account to the test database?

Second I suggest...

It's a configuration setting. See this article... Configure the two digit year cutoff

You don't need to start from the beginning to put the database in stand-by mode again. You can just restore the file that was being restored when your SSMS stopped....

Audit has certainly it's purpose, but be aware it can generate a lot of data and it could be hard to filter out exactly what you need.

If you only need...

andrew 64169 (12/13/2016)

---

Hi All, i am hoping for some assistance with an rounding issue i have with my current trigger. any assistance would be greatly appreciated.

'BEGIN ' + #13...

First: with a REBUILD of the indexes the stats are updated also. Thus it is not necessary te run a separate UPDATE STATS again.

In your described situation if you need...

Determine your backup strategy by the requirement for the restore (RPO and RTO). How much data is allowed to be lost (= RPO) and how long is data to be...

And another article... Gotcha for Installing SQL Server 2016 and SSMS on Windows Server 2012 R2[/url]

Have you read this article? Fix: Windows 8.1...

From my own experience the MCSA is a certification that let people know yo have a general MS SQL data platform knowledge. Whether it is SQL2012, SQL2014 or SQL2016 is...