Benki Chendu (11/18/2016)

---

Hi All,

A customer of mine has huge number of sql 2012 databases but he doesnt know which data sits where. he needs me to help me in creating...

BWFC (11/18/2016)

---

TomThomson (11/17/2016)

---

BWFC (11/16/2016)

---

Sean Lange (11/15/2016)

---

Ed Wagner (11/15/2016)

---

Y.B. (11/15/2016)

---

Hey Brandie, cheddar is not better!! LOL (it's all personal preference of course)

That being said I did recently try an Irish...

WilburSmith (11/18/2016)

---

Hi,

I run into a problem while loading data into DataVault. I create my dv key with HASHBYTES('MD5', <business key>)

The load failed due 'Duplicate data' error and the duplicate key...

I'm not aware of any proper query re-writing tool that can handle anything more than relatively basic queries.

😎

If you can get the actual execution plan then that is a good...

Hi and welcome to the forum.

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

😎

an0nemus (11/17/2016)

---

We have a 2008 DB, with 3 client servers all on the same subnet as the sql server.

2 machines connect just fine, 1 machine throws this error on the...

Phil Parkin (11/17/2016)

---

Eirikur Eiriksson (11/17/2016)

---

The execution plan for my version...

bennylu (11/17/2016)

---

Thank you Eirikur. That was exactly what I looking for.

In terms of performance, Eirikur's solution performed better. It had less reads, most likely because it did not use a...

The execution plan for my version is significantly simpler (41...

Here is an alternative solution

😎

BTW, OPENXML is not better, stick to the XQUERY

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @XML_DATA XML = '

<Report MerchantID="123456">

<Requests>

<Request RequestID="4791333844346002104017" MerchantReferenceNumber="RA00042357770">

...

Brandie Tarvin (11/17/2016)

---

Beatrix Kiddo (11/17/2016)

---

It's in the link there.

CREATE OR ALTER (Yes, we heard you !!!) – New CREATE OR ALTER support makes it easier to modify and deploy objects...

You are very welcome.

😎

You should consider Jeff's fine advice, it is easy to incorporate into the solution.

Jeff Moden (11/16/2016)

---

If the input string is limited to less than 24 hours, the following makes life pretty easy and will also produce an error if someone entered improper information...

Ed Wagner (11/16/2016)

---

Eirikur Eiriksson (11/16/2016)

---

ramyours2003 (11/16/2016)

---

We need to collect the disk space utilization on weekly basis and we have 50+ servers . I need a report of all the...

ramyours2003 (11/16/2016)

---

We need to collect the disk space utilization on weekly basis and we have 50+ servers . I need a report of all the servers how much the...