Viewing 15 posts - 1 through 15 (of 24 total)
Good job Arshad. Really liked the article. Keep up the good work.
May 20, 2011 at 6:19 am
What is the database log file size then? I mean just the Ldf file size?
Also check if there is any error in the application which is retrying to finish....
June 5, 2008 at 4:35 am
I think its the transaction log file which is increasing. Check if the log file (.ldf) file size is increasing. If this is the case, check how frequently you take...
June 5, 2008 at 4:10 am
Below are the steps
1) Install SQL Server 2005 as a different named instance. (If you have done it then you can ignore this step.)
2) Once installed, install the latest...
January 30, 2008 at 5:47 am
Same here. Why MS is releasing a new version when 2005 have not captured the industry.
July 11, 2007 at 12:09 am
Agree with Sugesh. And if you are planning to do it from sql server, then use xp_cmdshell to execute the above commands.
But you will require sysadmin fixed role to execute...
July 10, 2007 at 10:46 pm
Are you sure that you are trying to run SQL upgrade advisor to SQL 2000 instance?
July 9, 2007 at 11:29 pm
For fixed set of tables, Trigger is the only way dear. By the way why are you so controvert for triggers? If they are properly used then there is no...
July 9, 2007 at 7:55 am
But the question from Rahul says that he not able to see the values while tracing. :s.
Rahul, Trapping the older values thru profile is certainly not possible.
But the 2...
July 9, 2007 at 6:43 am
As you said it was fine before, it might be because of some error in the application... which is causing the same process to re-execute again and again.
July 9, 2007 at 6:03 am
Don' know why my previous is not appearing so reposting it again. I am sorry if later it appers twice.
1) Connect to the server where you want to...
July 9, 2007 at 5:27 am
There can be other reasons for the tempdb growth. I will insist to check all your database queries.
Extensive use of group by or order by can also lead to...
July 9, 2007 at 5:23 am
1) Connect to the server where you want to trace.
2) In the general tab, select SQLProfilerStandard.tdf as template file name for trace. (by default this is the one selected)
July 9, 2007 at 4:37 am
We can see the values in profiler. Please tell us what steps you have performed to execute the profiler. What all rules you have applied?
July 9, 2007 at 4:16 am
Stop the trace and click on the Edit icon on the top. Move your mouse over the icons on the top of screen and click on the icon having tool...
July 9, 2007 at 3:48 am