tcronin 95651 (6/1/2015)

---

have 2008 r2 server have had some disk issues before. Today went off the charts. have Idera DM which usually gives me the info to help,...

I do know the fealing:-D

😎

Quick suggestion that fits the posted sample data

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.TBL_SAMPLE_DATA_012') IS NOT NULL DROP TABLE dbo.TBL_SAMPLE_DATA_012;

CREATE TABLE dbo.TBL_SAMPLE_DATA_012

(

Id ...

Very nice piece Jeff and a very good point.

😎

As a side note, I have not hindered or limited my children's access to any source of information, rather I've spent...

satish.saidapur (5/31/2015)

---

Hi Team,

I have installed SQL server 2012 STD successfully but i missed to add my ID as well as group ID while installing. So now...

You are very welcome.

One more thing, you should check that the data types in the XQuery output matches the destination, cannot do that for you as...

Jampandu (5/31/2015)

---

Hi Sir,

I need to extract values from XML column in table instead of variable.

Here I'm attaching the sql file for test data (some part of xml data). Could...

Finally it looks like your posts are back Jason, and good job on the sample and test code. The addition of the index does remove the primary sort but optimizer...

Fingers

Steven W (5/30/2015)

---

I started the shrink file last night but I forgot to script it and instead just hit the "OK" button. I see the task running in activity...

Zingiberaceae

A currently active thread: "I don't use any clustered indexes actually... all of mine are non-clustered..."

Sometimes I do wonder where things went wrong with MS and SQL documentation/references/best practices...

😎

That's not making things easier, may I ask why not?

😎

For clustered indexes (non-heap tables) No, for Non-clustered indexes Yes,...

Lynn Pettis (5/29/2015)

---

Eirikur Eiriksson (5/29/2015)

---

Lynn Pettis (5/29/2015)

---

We know that the Crystal Ball shows nothing but the clouds, but where is the silver spoon?

< rant >

I am still amazed at how...