Eugene Elutin (4/24/2012)

khushbu (4/24/2012)

From BOL: http://msdn.microsoft.com/en-us/library/ms186939.aspx

nvarchar [ ( n | max ) ]

Variable-length Unicode string...

From BOL: http://msdn.microsoft.com/en-us/library/ms186939.aspx

nvarchar [ ( n | max ) ]

Variable-length Unicode string data. n defines...

Yea.. i know

nvarchar = 2(varchar)+2

But i was mainly looking for query.. since I have abt 800 tables and each table has 3/4 varchar columns, with each row count abt...

yea. we are talking about blocking..

We have many monitors in place and we have been able to drill down the procs involved, and digging more if we can get the...

Many thanks for the wonderful answers.

However I would like to know when we are trying to design a table, what should be preferred and why?

Thanks.

Yes, we are now planning to have server side trace.

However, just wandering if we can somehow find who did it last time.

sadly, we do not retain older trace files 🙁

Yea, we have many sa on the system.. thats the need... any other logging done somewhere..

Can someone please help me to get my doubts cleared..

Can someone please help me to get my doubts cleared..

Sadly, I did not save the error when we got it and logs have been recycled.. and since the problem was fixed i cannot repro it:(

You can check the Maintenance Clean Up task which will help you clean old files/backups

will it be treated as 2 differenet transaction?

not much..I think the SQL governor will govern them with the same set of transaction unless there is explicit BEGIN TRAN defined for...

It seems like a big database. You can also consider 3rd party tools like LiteSpeed which can help you backup/restore one table.

Ofcourse it is a license tool.

If licensing is problem...

there exists monitoring by using some 3rd party tools (which are great).

In addition a report is generated every 2 week to get short summary and inform management about stats and...

Sorry, we cant any jobs on the system.

(coz creation one requires a big long chain of getting approvals from everybody and it would never be approved just for single report)

Any...