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;

😎

nazaninahmady_sh (9/3/2016)

---

Hi

I use sharepoint(2013),for this I have SQLServer(2014) in seprate server.Now I have to" update" SQLServer(2014) in server, I want to know that if there is any specific point in...

mah_j (9/3/2016)

---

Hi

I have a table with 11 G data space and 25,000,000 records.3 fields are configured for full text search, they are all nvarchar(4000) and the cataloge size...

Quick thought, add a test for the row in the table header template match, i.e changing

xsl:template match="oh"

to

xsl:template match="oh/q"

will eliminate the header for the "oh" if there are no "q" elements...

Another option is to use either sp_describe_first_result_set or the sys.DM... version of it.

😎