sam-433147 (10/22/2015)

---

hai,

how can i insert the declaration

<?xml version="1.0" encoding="UTF-8"?>

to my query?

declare @tbl table(Color varchar(20))

insert into @tbl(Color)

values ('Green')

insert into @tbl(Color)

values ('Red')

select Color

from @tbl Colors

FOR XML AUTO, ROOT ('MyColors'), ELEMENTS...

Self-join the character list cte is another option

😎

Quick question, is the new install running under the same credentials as the old one? Looks like a simple permission issue.

😎

Thanks for the question Junior.

Given the answers it could as well have been "Pick the combination of two correct dates";-)

😎

Quick solution

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @INPUT_STR VARCHAR(500) = 'WWWWWWHY DDDDDDDDDDDOOOOOOOOO YYYYYYYYOOOOOOOOOOOOOOOOOUUUUUUUUUU WWWWWWWWWWANNNNNNNNNNNNNTTTTTTT TOOOOOOOOO DOOOOOOOO TTTTTTTTHIIIIIIIIIIISSSSSSS??????????';

;WITH...

Quick suggestion, query sys.indexes to check if the columnstore index is disabled or not before attempting to manipulate the data.

😎

Quick thought and further on Jeff's fine answer, observing the wait stats during the operation usually gives a good indication of whether to alter the batch size or even change...

Another quick solution

😎

SELECT

MIN(T.hierarchyid) AS [hierarchyid]

,T.hierarchyval

FROM #test T

GROUP BY T.hierarchyval;

The two solutions posted are close in performance or rather lack there of,...

Did you just upgrade to Windows 10?

😎

My suggestion is somewhat different to the previous ones

😎

1) Safety measures first, Backup the database with verify etc.

2) Create a new file group, add a new data file to it...

Further on Luis's post, the NULL represents unknown or missing, in the realm of financial transactions that concept is somewhat irrelevant, unknown payment is equivalent of a 0 payment, if...

GilaMonster (10/15/2015)

---

BL0B_EATER (10/15/2015)

---

Do you think it is worth writing an article / blog on how you have used a particular feature (in SQL Server) to help you in your day...

I second Koen here, keep'em coming!

😎

There is nothing wrong with this DDL, works perfectly. Just a hunch, have you run DBCC CHECKDB on that database recently? Also is this script generated from the table set...

christophe.bernard 47659 (10/14/2015)

---

Hello Eirikur Eiriksson and Dean Mincic,

thanks for your time that's exactly what i want ..and now that's work ..

I don't know why the property of this object is...