Hi,

The best way you can do is Try SQL Server Profiler, that is very useful to check database lock/trace or whatever you like to see the transactions.

Also when you create...

Hi,

Apurpa is right, you will need to purchase the license for SQL 2008. You can use MSDN version if you guy subscribe for MSDN otherwise Developer Version is the cheapest...

Hi Gail,

I have migrated 2000 database to 2008 and update the statistics once after migrate. Do I need to update the statistics everytime I rebuild the index or how often...

Hi Steve,

Thank You.

Hi Steve,

I am going to install SSMS 2008 on one of my Production Server this weekend. We already got SSMS 2000 installed.

About the SPK and Hotfix from Microsoft, shall...

Hi,

I run your script in my SQL server 2005 and returned with results. Can you please explain me what is the benefit to run the script on SQL Servers? If...

Brad (6/16/2009)

---

AWE is enabled, I didn't see anything in the boot.ini but MS says Server 2003 Enterprise has PAE enabled by default.

My remaining question is should I have...

Hi,

How to perform and check the Total SQL Memory Counter?

Thanks

Leo

Please check the following link...

http://www.mssqltips.com/tip.asp?tip=1268

that will tell you everything you need. I hope it helps.

By the way ..I still don't understand about '/3GB' in boot.ini coz..I got 16GB...

You won't find boot.ini sometimes, you need to go to contorl pannel\system\Advanced\setup and recovery\settings\then select EDIT to change the value of what you want.

I got 16GB on my SQL...

Hi Jeffrey,

Yes, it said 16GB and Enterprise Version (SQL 2000).

Thanks.

Hi,

Do you mean Archive Logs in SQL or ERROR Logs?

Hi EdVassie,

Thanks a lot.

Leo

Hi EdVassie,

You are right. I keep asking for more drives for my production Servers but Management Team said 'YES' but it was last 2 months ago I am still...

Hi Everybody,

My database Model is Set to Simple as we don't need to backup the Log. I got 2 Data File and 1 Log File. Log File size is reasonable...