Thank you David.

How about SQL2005 in your opinion? Should apply the same - static port with a high range?

David O (9/24/2008)

---

My shop has had problems with dynamic port assignment and binding in Sql 2000. Port conflicts can happen but you'll still be able to connect using...

I felt embarrassing to ask code from the others for this question. I thought or the others would think I am a lazy DBA 😉 not to write the...

Thank you. This is exactly what I want.

I like this part very much, plus your have comments in your code.

--Get Directory Names

CREATE TABLE #DIR_NAMES ( DIRNAME VARCHAR(300))

INSERT...

Worth a read: Online Indexing Operations in SQL Server 2005

http://www.microsoft.com/technet/prodtechnol/sql/2005/onlineindex.mspx

Need to estimate the space for reindex, etc...

Thank you all for help. I limited to the user tables only.

Here is the code with minor change:

-- SQL2005:

select o.name from sys.indexes i

inner join sys.objects o

on o.object_id = i.object_id

where...

Is it 8K page for each read or write? Please correct me if I am wrong.

Find a KB mentioned about this topic:

How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port

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

Then a further question:...

Thank you all for your response.

Cluster That Index! has detailed info about the "Problems with not having a clustered index". I can not find any article better...

Great info. Thank you Steve. I thought I should post this question on windows forums.

Good question. It is a reporting database. If no need to have a clustered index for whatever reason, why have a non-clustered index then? I remember it...

non-clustered and unique.

Additional info, it is a reporting database. The fragmentation is very bad.

Is the question clear?

"...can events be lost if you have disk space?" or "...can events be lost if you have disk space PROBLEM?"

This is not only for SQL2008 but also...

I did already. Without this fix,...