Quick question, can you post the DDL (create table scripts), some sample data in the form of an insert statement and the expected results?

😎

Quick suggestion, add a NOT IN clause to exclude the unwanted members

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @tt table

( TagId int, TagType int,...

Quick question, any indices on the table?

😎

Have a look at this thread from last year

😎

Brandie Tarvin (7/14/2015)

---

So I'm testing a quick bit of code on a dev version of our bigger reporting database and it found something on the first table it hit. Nothing...

Brandie Tarvin (7/14/2015)

---

Lynn Pettis (7/14/2015)

---

Eirikur Eiriksson (7/14/2015)

---

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...

...and SQL MCP => SSC 😀

😎

Lynn Pettis (7/14/2015)

---

Eirikur Eiriksson (7/14/2015)

---

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...

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...