ramyours2003 (7/25/2012)

---

Hi ,

can any one answer this

Whenever a client/User requests to a Sql Server what exactly happens internally? which components will handle the requests and how...

+1 [SQL Pretty printer]

I am also using this tool. Once installed it adds into ur menu tab as SQL Beautifer. Check it out..its a cool tool 🙂

Ohk..got it now. Thanks

To post any performance related stuff, please check the article 'How to post performance problems - Gail Shaw]

http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Nice catch Sean 😀

Yup...I forgot that its table/SP

Thanks for correcting me 🙂

My question still remains unanswered, does someone has an answer to this please.

- Lokesh

Hi Gail

Just a quick one - Does lock escalation also depend upon the size of the table? Or it only depends upon the memory buffer allocated for holding locks?

Thanks in...

+1

Get in touch with some veteran from cobol team

I thought you will do that...here's is the query:

sp_msforeachdb 'select "?" AS db, name from [?].sys.tables where name = ''table_name'''

Replace your table name with table_name

Your question is not very clear. Kindly post DDL along with sample data.

To find the table/SP use sys.all_objects and to find if the table exists in any db use sp_foreachdb. I leaving this as a home work for you to come out...

Yes. That's true.

As persisted columns are used to define computed column they cannot be changed all alone.

One more thing: If I try to execute this code, why I am getting the error message two times?

Caution: Changing any part of an object name could break scripts and...

Though I got this correct, but I always thought you cannot remane (only) participating columns. Nice question 🙂