I'll have a look, can you get couple of data samples to work with, makes things easier as otherwise I would have to start guessing.

😎

I've done systems that to high...

Brandie Tarvin (1/22/2016)

---

Eirikur Eiriksson (1/22/2016)

---

Quick suggestion, change the #dbsize create script

😎

CREATE TABLE #dbsize

(

Dbname SYSNAME ...

Quick suggestion, change the #dbsize create script

😎

CREATE TABLE #dbsize

(

Dbname SYSNAME ...

er.mayankshukla (1/22/2016)

---

Hi All,

In one of the application, we have to restrict the developers from creating a table with unicode columns.

I was thinking if I can use Policy based management for...

Eric M Russell (1/21/2016)

---

Eirikur Eiriksson (1/20/2016)

---

...

...

Quite impressive, 28 operators in the execution plan, parallel execution, four full table scans and I'm now putting out the fire ignited by the CPU...

The quick suggestion towards a solution posted earlier was just that, less than two minutes of coding to demonstrate a method for identifying groups in sequences. Now with further 5...

Quick suggestion, a different and more efficient way of doing this

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_SIZE INT = 1000;

;WITH T(N) AS (SELECT N FROM ( VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS...

Quick thoughts, do you have an XSD for the XML? If that exists then it's normally the best starting point for modelling the database schema.

😎

Bulk loading the XML into...

Greg Edwards-268690 (1/21/2016)

---

Steve Jones - SSC Editor (1/21/2016)

---

Greg Edwards-268690 (1/21/2016)

---

It seems he has an elephant on the menu, and a 6 quart pot to cook it in.

But refuses to start...

Sergiy (1/21/2016)

---

MMartin1 (1/21/2016)

---

That would make sense since this table is a heap. The ID column is not really an identifyer in this situation. We are not recommending a practice of...

Here is how

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @TEST_STRING NVARCHAR(4000) = N'ABCDEFG?Ô?1234567Ò???HIJKLM]? ?NOP??60987654321';

;WITH T(N) AS (SELECT N FROM ( VALUES (0),(0),(0),(0),(0),(0),(0),(0),(0),(0)) AS X(N))

, NUMS(N) AS (SELECT TOP(LEN(@TEST_STRING)) ROW_NUMBER()...

Identify them or simply remove them?

😎

Quick suggestion

😎

select

A.a

,A.b

,DENSE_RANK() OVER

(

...

Roust_m (1/20/2016)

---

Hi,

I am planning to un-partition and decompress some large tables to be able to use standard edition of SQL Server.

Given that not clustered indexes get rebuilt when a clustered...

chuck.forbes (1/20/2016)

---

We're re-examining our database server security architecture, as we are starting to migrate our older databases to MSSQL 2012 and 2014. One of the Developers mentioned that a prior...