rambilla4 (2/15/2010)

---

We have SQL server 2005 EE x64 with SP3 having BizTalk server 2006 R2 databases. I went through the below link to perform rebuild indexes

http://support.microsoft.com/kb/917845

and I'm rebuilding the Indexes...

What is the maintenance plan trying to do?

You might have that confused with how much RAM Windows Server 2003, Datacenter Edition supports - 64GB and...

Colin Betteley (2/12/2010)

---

I have found a number of articles stating that problems can be resolved by using sqlservr with various Trace Flags.

I have found the parameters for sqlservr by...

The following quote is taken from the Microsoft Whitepaper http://msdn.microsoft.com/en-us/library/cc966413.aspx

"Occurs when a task is waiting for a latch for a buffer that is in an I/O request. The latch...

What process are you using to copy the database between servers?

Would you not just install a Default instance for SQL server... The SQL Server instance is then referenced using the server name?

ashish.kuriyal (2/13/2010)

---

Hi All,

I was just wondering aout the question on tempdb which will somehow help me to track performance:-

1)do we need to create secondary file for tempdb?

2) if adding...

Michael Swart in this blog post adds to animals argument:

http://sqlserverpedia.com/blog/sql-server-bloggers/removing-columns/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed:+sqlserverpedia+(SQLServerPedia)&utm_content=Google+Reader

This suggests that an index or table rebuild is the way to claim the space back...

Hi Lynn/Jason

Thanks for your replies sorry it has taken me a while to respond...

Out of curiosity, do you regularly defrag your SQL server disks...I have sized my database files...

SQL_Lock is correct you need to restore to

backup take the final transaction log backup, if that is possible.

Copy the file over to the secondary server

and restore it to the...

I am in the process of watching/reviewing the recorded 'DBA' web casts. The few I have seen so far have been excellent and I'm definitely going to try and...

I'm not sure if I'm explaining...

If you copy the data from both tables to a new table, with a new name, what is the size of the new tables?

I''ll send you to Paul Randal's blog post here...

http://www.sqlskills.com/blogs/paul/post/checkdb-from-every-angle-emergency-mode-repair-the-very-very-last-resort.aspx

It may help, it may not, thats for you to decided.

What i don't understand is if you have setup a maint plan...