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...

No, you can't skip the SP3 installation. It's a cumulative update upon the SP install.

As written on the Microsoft page:

Prerequisites

To apply this cumulative update package, you must be running SQL...

Sorry - previous post was duplicated

jay-h (12/2/2016)

---

Or we could go completely the other way.

As it is, the job system is an awkward fit into the SQL management world. You can do a lot with it,...

Because you already use MS Access as a sort of front-end, I wouldn't change it. Just upgrade to the latest version and fix some compatibiliy issues (if any). The number...

Below query will give you the desired results:

declare @table table (ID bigint,

Name varchar(50),

Address varchar(250),

RecDate smalldatetime,

PurPrice decimal(7,2),

PaidBy varchar(50)

)

insert into @table

values (1, 'Peter', 'Street 1', '2016-11-22', 100, 'PayPal')

, (2, 'John', 'Lane 1',...

You can start by running the Upgrade Advisor from Microsoft. Besides you can also run the profiler for a period of time that logs the "Deprecation Announcement" and the "Deprecation...