Grant Fritchey (9/25/2009)

---

jcrawf02 (9/25/2009)

---

I got this picture in my head of Grant in mountaineering gear on the slopes of Everest as he passes...

Maybe we should make a forum in SQL Pass where the chapter leaders can exchange ideas? You know what I we like to have for our pass chapter? One single...

Thanks Grant, Alvin 🙂

Still a long way to go. I am getting lots of positive feed backs from the people who attend. They are coming up with new ideas and...

You can JOIN the tables and use Sum function.

Select a.col1, Case when (Sum(b.Col3) - Sum(b.Col4) < 0)

THEN 1 Else 0 END as ColName

from dbo.table1 as a...

Just as an update, we had our second Curacao SQL Server user group meeting. We had 15 members attending. It was pretty good. The presentation was well appreciated by everyone.......

Simple, I did not understand your Techinical jargon. :hehe: Sorry, did not read all posts. My apologies.

I knew that someone would jump in to this thread before I come back from lunch and couple of you guys did... 🙂

Put a DR Plan to do transaction log shipping for the DB. Once Transaction log is taken, it will make sure that it releases the space used in the log...

The drive that is getting full, Does it have the Log file or the data file? Do you have Transaction log back ups running? Do you have any back up...

Adi Cohn-120898 (9/24/2009)

---

I’m not sure that the schema locks cause blocking. As far as I know schema locks won’t let you modify the table’s structure but it doesn’t block...

I am not sure why you need to drop the indexes. You can try it without dropping indexes. maybe I am missing something here.

You could try Isolation level (Row level version[/url]). I am not sure if this will help or not because I have never tried running it with maintenance plan of...

Have you tried BCP?

When you are doing Update Stats and doing Index maintenance, it does a schema lock. That cause Blocking. That could be why you see that everything is hanging.

Are you talking about DDL commands?