pavankvnv (4/17/2012)

---

HI Muthu,

I ran the script and it created those two tables in master and msdb and executed successfully.

But fragmentation is not reduced. Please let me know how to put...

vanceprice (3/26/2012)

---

If we are running SQL 2008 and have "Auto Update Statistics" enabled, Do we need to update statistics in condition 2 or 3 of this script? Are there any...

What error are you getting?

natasha-501269 (3/8/2012)

---

I've got the following error when used your script in sql 2000. Any idea?Thanks

Server: Msg 1038, Level 15, State 3, Line 1

Cannot use empty object or column names. Use...

Welcome to T-SQL language.

Loop the sys.databases and...

shovankar (2/3/2012)

---

Hi Suresh,

Thanks a lot for your reply. I am using SQL SERVER 2008 ENTERPRISE edition with 32 GB ram. I was just wondering if any kind of programming...

Thanks Greg Shinder.I'll look into this.

I'm glad you liked it.

Try with in square bracket i.e. [dbname].

sorry for that confusion.

muthukkumaran Kaliyamoorthy (12/16/2011)

---

Guys,I'm bit late

If your log file grow in...

Guys,I'm bit late

If your log file grow in simple recovery...

Jeff,

It's an Excellent interview.

Wow...I love these lines.

beejug1983 (12/1/2011)

---

It is 32 bit, I read on MSDN if the PLE is more than thousand means there is much Memory for SQL Server to cache the data. But I...

beejug1983 (11/28/2011)

---

Hi,

I have a server of Windows Server 2003 R2 SP2 with 2 GB of RAM, In task manager more than 1 GB of RAM always shows for SQLServer.exe.

Is this...

bobw1776 (11/30/2011)

---

I haven't read through the above replies to check, but has anyone received the below error ONLY when the SP is executed against a CS collated DB? e.g....