DECLARE @Input Varchar(20)

SET @Input = 'Parthi'

SET @Input = @Input + '''s'

Select @Input

Escape a quote by doubling it.

Same way you'd index anything else. Normal index on the column. Is there some reason you don't...

No pages in the transaction log. The data file is divided...

syscolumns is a deprecated system view and will be removed in a future version....

But the update must still target a single table, ie with an updateable...

That select must return only one value. You're assigning the result to a single string...

Not just how far...

Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ It's really hard to talk about performance in abstract.

Are the indexes fragmented?

First execution of a query will...

Bitbucket did. What about his reply (which did answer your question on deleting records in related tables) was not sufficient?

Why? What's your goal, what are you trying to achieve?

Please run the following and post the FULL output. There's not enough information in what you've so far posted to make even an educated guess.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS,...

Not any update to a varchar, one that increases the size of the varchar, hence increasing the size of the row.

It's an option, just not a free one. Tradeoffs, just...

Would you like to expand on that? (details or example)

PAD_INDEX controls whether the fill factor applies to just the leaf levels or the entire index (leaf and non-leaf levels)

Johnc (11/27/2009)

---

What about free space? I assume SS allocates a default % headroom to each row to allow for growth and that the % is adjustable so we could reduce...

cute_lhen05 (11/26/2009)

---

Thanks for your help! it worked! however there's a message showing everytime the user creates a table like

"you are not logged on as the databae owner or system...