Quick thought, the time calculation is not correct, the second result sould be 02:30:21 so there is an extra minute there in the results.

😎

Here are three different methods

USE TEEST;

GO

SET NOCOUNT...

You are merging into the LocDisplay table and that's where the error originates

😎

merge into LocDisplay as T

using (

select LocCode, PlaneCode, LocName, SomeCode

from [Loc] as S

cross apply (select distinct SomeCode from...

Do you have any index maintenance jobs running...

Can you please post the DDL (create table) scripts, sample data as an insert statement and the expected results?

😎

There is no problem attaching the SQL Server 2012 databases to the SQL Server 2016 instance, but once attached it cannot be reverted back to SQL Server 2012. Simply create...

That is a full backup of the operating system and...

skippyV (9/3/2016)

---

Excellent write-up! Thanks again.

So if I wanted to adjust the code and expand on the portion that builds the random value added to the base value, I could just...

Further explanation (comments in the code)

😎

-- Number of rows generated

DECLARE @SAMPLE_SIZE BIGINT = 4000;

-- First date or Start Date

DECLARE @StartTime DATETIME =...

You are very welcome.

The code uses an inline tally table (numbers table) to generate the initial rows, the iTally works on the principal of cross joining a seed table of...

AFIIK there are no known problems when updating SQL Server 2014 (i.e. SP 2) but it is always better to be safe and do a full backup both on OS...

Quick question, what is the relevant output of this query

😎

SELECT

OBJECT_NAME(SIDX.OBJECT_ID) AS TABLE_NAME

,SIDX.name ...

Quick thought, I find the population being less relevant than the nature of the major businesses, the greater the legislative constraints applicable to the businesses (i.e. SOX, BASEL etc.) the...

My 2 cents worth on this subject: it depends!

😎

Few quick thoughts:

There is no "one size fits all", it all depends on the subject.

As a general rule a table should have...

Quick suggestion (if I understood your question correctly)

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE BIGINT = 4000;

DECLARE @StartTime DATETIME = CONVERT(DATETIME,'2011-07-20 11:00:33',120);

DECLARE @EndTime ...

Can you post the full unedited output of

DBCC CheckDB ('DB_NAME') WITH NO_INFOMSGS, ALL_ERRORMSGS;

😎