opc.three (9/4/2012)

---

You can output is as XML in grid view so it will appear as a link:

SELECT YourColumnName as [processing-instruction(x)]

FROM YourSchemaName.YourTableName

FOR XML PATH('');

Then click the link to see the entire...

ariel_mlk (9/4/2012)

---

Hi people,

I'm tunning a database and i've stumbled by some hierarchy queries, on the good old form of ID, ParentID, to work out the hierarchy the previous developers...

I did however find a bug in my code. You should change the final query to be this.

select *

from cteAgg

join tally on tally.N >= cteAgg.MinItem and tally.N <= cteAgg.MaxItem

I...

I am not sure how else I can say this....SSMS does NOT...

No...

That is why you can't see all the data. There is an option to increase this but still...

Lynn Pettis (9/4/2012)

---

Sean Lange (9/4/2012)

---

sivajii (9/4/2012)

---

it read this

http://www.sqlservercentral.com/articles/Indexing/68439/

here i didn't understand

if there is an simple example means i can i understand easily

select * from sys.indexes

select *...

So how do you know there is only 43,600 characters? Are you looking at...

sivajii (9/4/2012)

---

it read this

http://www.sqlservercentral.com/articles/Indexing/68439/

here i didn't understand

if there is an simple example means i can i understand easily

select * from sys.indexes

select * from sys.index_columns

...

bindish (9/4/2012)

---

Hi,

I have one table with one field called "vLargeData varchar(max)" datatype. I am inserting data into table and that data size is 115000. After inserting when I am checking...

Nice job posting ddl and sample data. The description was a little confusing but after a few reads I think I understood it.

This can be accomplished using a combination of...

PiMané (9/4/2012)

---

Hi,

I'm analyzing an existing app from a client that uses a lot a SP that has inserts on a temporary table to process the data.

Are temporary tables better than...

You could just add some simple datepart logic.

declare @RunDate datetime

set @RunDate = '8/31/2012' --this would be getdate() in your code

select MONTH(@RunDate), MONTH(@RunDate + 1)

Then don't run your code when they...

Lynn Pettis (9/4/2012)

---

Sean Lange (9/4/2012)

---

If performance is a concern you should take a look at the link in my signature about splitting strings. Depending on what you are using for...

That is because your where clause is not sargable. That...