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

Tava (9/3/2012)

---

excellent, I got it working, created the Function & in the subquery now getting the results i wanted... really appreciate your help on this... no way i would...

Charmer (9/4/2012)

---

Mark Eckeard (9/4/2012)

---

If you need this added to a query where you don't always know the value, try this:

select replace(YourColumnNameHere, '.00', '0.00')

This worked when I tested it using this...

This is because your sql is timing out.

You can adjust the...

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 a splitter it may...