Thanks for the reply andy. Each table has more than 11 Million records and daily I will delete almost 2 million from each table except for last night since it...

OK..Thanks

Thanks Paul. We dont have any applications on the Production Database Server except for SQL server. What was happening was some of the backup files were being moved to an...

Its a maintenance plan with full scan....I am running this on all the user databases and the biggest of them are

250GB and 80GB rest of them are like less...

No it was not blocked... it took around 3.5 hours to complete.

Thanks george...I will apply the patch on the my test, dev and staging before moving to production.

I have applied SP1:

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on...

Thanks George. The version of sql is SS 2008 R2 SE.

Thanks Peter, in my case the text qualifier was empty. But as I mentioned the strings got appended to the column names before and after in the advanced properties window...

Thanks for your reply. Right now SQL Server max memory setting is set to 25600MB and I want to change it to 29000 as I have ensured that there are...

Thanks

Lowell (4/20/2012)

---

Sapen (4/20/2012)

---

Lowell (4/20/2012)

---

i thought the catalog view he's refering to in the object Explorer returns the results of sp_tables_ex linkedservername , so whether the linked server is SQL Server,...

Lowell (4/20/2012)

---

Sapan i thought that the catalog gets populated with only the tables/objects of the default database assigned to the login you are using to connect with...so for example if...

Lowell (4/20/2012)

---

i thought the catalog view he's refering to in the object Explorer returns the results of sp_tables_ex linkedservername , so whether the linked server is SQL Server, Oracle, mysql,...

Sean Lange (4/20/2012)

---

Is there system documentation? I am not sure what you mean by you can't see the tables. I have a feeling you are talking about intellisense. Intellisense does...