Here is another option, no need to concatenate the key columns

😎

INSERT INTO [addb20].[Target_MergeAMD4_WithData].[dbo].[ConfigOption]

(

[Active]

, [ConfigOptionGUID]

, [ConfigOptionTypePropertyId]

...

Manipulating the CF files in T-SQL is not trivial, the internal format is a FAT format which can be slightly twisted to work...

Brandie Tarvin (11/14/2016)

---

AGGGGGHHHHHH!

I don't know if I'm having a language barrier issue with this vendor rep or if this person is truly this clueless.

VendorRep: Make sure to restore this copy...

You are very welcome.

😎

adb2303 (11/14/2016)

---

Hi,

Thanks for the response.

SQL Server version

Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) Mar 19 2015 12:32:14 Copyright (c) Microsoft Corporation Enterprise Edition...

adb2303 (11/11/2016)

---

Hi,

I have just upped the cost threshold for parallelism to 50 on two of our test servers:

SP_CONFIGURE 'advanced', 1

GO

RECONFIGURE WITH OVERRIDE

GO

SP_CONFIGURE 'cost threshold for parallelism',50

GO

RECONFIGURE WITH OVERRIDE

GO

SP_CONFIGURE

This took 4m33s...

Jose Marcelo Dias de Oliveira (11/14/2016)

---

Eirikur Eiriksson (11/12/2016)

---

Jose Marcelo Dias de Oliveira (11/10/2016)

---

Hi

I have the same behavior in 2 SQL Servers where Stolen Server Memory and Database Cache Memory counters...

A VSS file backup is not the same as an...

hurricaneDBA (11/14/2016)

---

Hi everyone

I hope you're all doing great

We've implemented SP 2013 using SQL server 2012 with file streaming enabled and RBS.

Now we have over 35 databases with...

Which is not...

Another thing to pay attention to is the cost of using COUNT, it implies that the whole table must be scanned and aggregated, much heavier on the database than using...

John Mitchell-245523 (11/14/2016)

---

Eirikur Eiriksson (11/14/2016)

---

John Mitchell-245523 (11/14/2016)

---

OK, this query will look at all columns with data length of 15 or more and show the number of values with the requested...

Here is a query I often use, adjusted to this requirements

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @PATTERN NVARCHAR(MAX) = N'INC[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]';

DECLARE @SEARCH_TEMPLATE NVARCHAR(MAX) = N'

UNION...

John Mitchell-245523 (11/14/2016)

---

OK, this query will look at all columns with data length of 15 or more and show the number of values with the requested pattern. Beware that...

You are very welcome.

😎