Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than the allowable maximum row size of...

Lynn Pettis (7/14/2015)

---

I know that an OP posted a question with the following error:

Cannot create a row of size 8071 which is greater than the allowable maximum row size of...

Jeff Moden (7/14/2015)

---

That IS a good use of XML and, now that you've brought that bit of computational agony up, it's possible that I might do the same although I'd...

MarkThornton (7/14/2015)

---

Dear Eirikur,

Thanks for the suggestion. However, I make extensive use of Redgate's SQL Server Source Control, which will only work on one instance of Management Studio at a...

Quick suggestion, run an instance of ssms for each server.

😎

giri10488 (7/13/2015)

---

my sql server node was restarted & our colleague saying that sql server utilizing 95% memory & now i want detail about process which is running on that...

Lynn Pettis (7/13/2015)

---

OMG! How does Silver Spoon keep his job? Member of ssc for over 10 years and can't seem to do the simplest tasks without running to the...

mw112009 (7/13/2015)

---

create table abc( lab_id varchar(10), lab_time datetime, lab_name varchar(100) )

INSERT INTO abc( '10001' , '2015-07-13 14:01:023' , 'K' );

INSERT INTO abc( '10001' , '2015-07-13 14:01:023' , 'K' );

INSERT INTO...

robert.wiglesworth (7/13/2015)

---

Ok, yes, that's true. But what if I wanted to do something like this:

select * from #temp t where t.color in ('red','blue')

and still get record number 4 because red...

SQLRNNR (7/13/2015)

---

Maybe so, but look at the XML plans for the larger data set versus the small data set - same plan. By using the text() it eliminates that...

robert.wiglesworth (7/13/2015)

---

Consider the following data:

create table #test

(id int

,color varchar(20)

)

insert into #test

(id, color)

values

(1, 'blue'),(2, 'red'),(3,'green'),(4,'red,green')

In this example, if I wanted to run a query to select any records...

Mikael Eriksson SE (7/13/2015)

---

FYI: the plan will be identical regardless of what your...

Mikael Eriksson SE (7/13/2015)

---

//name and /STUFF_FROM_MSDB/SYSTABS/name/text() is not...

BG101 (7/13/2015)

---

Basically I need to get the SUM of the sum of three columns and all three columns have nulls. To make it more complicated, the result set must return...

TomThomson (7/13/2015)

---

Yes, quite so. 😎

Doing it...