Thank you Jim for this detail steps procedure, it helped me to resolve my MySQL Migration to SQL Server.

Thank you again, great help.

Thanks

Nice script, Ian, Good job...............

My table is already compressed, is there way i can find out upto what extent it is compressed or how much it is compressed.

Thanks

I have made minor change to that code as shown below & shorten with few lines.

Create this store proc and schedule in SQL Agent Job for 10mins. it will only...

Hi:

how often do you see this this suspended state for log writer & checkpoint. As you knwo that they both are different.

what your SQL Server is doing when you see...

take the full backup & restore to the server which has good amount of disk space & move all files to the same file group & then you can run...

VMWare is good product but not for SQL Servers. I will prefer Microsoft Virtual OS 2005 rather than VM. As nobody knows better than Microsoft about there products. top of...

I came across this site, so i thought let me share with forum.

SQL job manager

View and manage SQL Server Jobs

Free for a limited time

http://www.idera.com/Products/SQLjobmanager/

i have question about linked server where it is configured for Sybase. my question is that i want to execute SYBASE storeprocedure (SP) with parameter from SQL Server Query Analyzer...

I have been really greatfull if this article was for Windows 2003 & SQL Server 2005. As SQL Server 2000 is set to expired APRIL 2008. So it was great...

Syscacheobjects queries buffer pool & not out side buffer pool. where MemToLeave is the region outside buffer pool. Syscacheobjects doesn't gets all information about 37 regions within Buffer Pool.

your DB is at full recovery mode. If you don't have enough disk space then i will recommend to make it BULK & then finally Simple. I hope this helps.

I came across this article which gives more information about "Multi Page Allocator"

http://blogs.msdn.com/slavao/archive/2006/03/14/551394.aspx

i hope this will help & make sense up to the extent.

4GB RAM: /3GB (AWE support is not used)

8GB RAM: /3GB /PAE

16GB RAM: /3GB /PAE

16GB + RAM:...

cntr_value is "Percentage of pages that were found in the buffer pool without having to incur a read from disk."

the query that you are running "select * from sys.dm_os_performance_counters where...