shivrudra_2008 (1/7/2010)

---

Hi all

i have done all the necessary steps to open the DTS package (created in SQL server 2000) in sql server 2008 by http://msdn.microsoft.com/en-us/library/ms143755.aspx this help but still...

Check the server memory using the following query

select * from master.dbo.sysperfinfo

where counter_name like 'Target Server Memory (KB)%'

or counter_name like 'Total Server Memory (KB)%'...

recently we have upgraded the storage firmware as well to overcome any i/o related issues , increased sql memory as well, some times during peak hours we have db...

For example, the following conditions may occur:

1. SPID 55 wants to read a data page that does not exist in the buffer pool.

2. SPID...

sqlnsg (1/4/2010)

---

Hi,

Happy new year ! I have run the select statementand uploaded the output.txt , PAGEIOLATCH_SH and PARALLEL_PAGE_SUPPLIER (43D71784) , recently we have upgraded the storage firmware as well to...

klnsuddu (12/29/2009)

---

After reading this blog, I have deleted my Update Statistics maintenance job. Because, in my case, Update statistics is running...

Jpotucek (12/29/2009)

---

When migrating databases from SQL Server 2000 to 2005 using backup and restore, How do I verify that auto update statistics is turned on AND it is...

Go BOL--check the SERVERPROPERTY function.

Hope this ll give more info

EdVassie (12/29/2009)

---

For 64-bit Windows 2003, 2008 and above:

/3GB is not relevant to 64-bit, and is ignored if it is supplied.

/PAE is always on for 64-bit, and makes no difference if...

Just Goggling

S,Possible.

Edit:Confirmed.

Read the following MS article's

Note:

You must install the .NET...

How can u said no need ?

Always "it depends"

hi,hi,hi.......:-)

LOL...

ramyours2003 (12/28/2009)

---

as w e r experiencing space crunch we need to move on the database files in to the another drive on the same server to ensure the...