This workshop is really very helpful. I had no idea that how to read the xml stuff through query but now I am very much clear about it.

Is there any...

Hi

In order to shrink database, you are using right command but the thing is tempdb uses some objects thats why there is a problems to shrink the tempdb. When you...

Hi,

I don't think it will affect on stored procedure performance, because stored procedure are pre-compiled although it may take to execute first time but after that it should not impact...

1- It is showing me total database size is 3809.25 MB

2- It is showing the available size 192.40 MB

3- Autogrowth property is enabled by 10 % of both log file...