I was wondering if anyone had any suggestions as i've not seen
anything like the following before.
I have a 64bit sql 2005 with the latest service packs applied. The box
is an itanium box with 4 CPUs showing in task manager.

Why should I choose a composite index with two fields over two separate
indexes on the two fields? How does the

How to tell sql server the maximum size my temp table will grow so that it
does at most 1 memory allocation?

I have a CLR function thet returns IEnumberable (a table) and it has a
FillRow function. I am returning 10,000 integers from this function. Is
there any way that I can preallocate the resulting table or give SQL server
hint as to how many rows my function will return? It makes me ...

Hello NG!
Is it true, that SQL2005 holds distribution-stats for EVERY column on an
index, not only for the first?
If yes: Is there a reference (BOL) on that?

Is this the right query to run to get the  currently running execution plan
for queries
select query_plan from sys.dm_exec_requests
cross apply sys.dm_exec_query_plan(plan_handle)

I am a newbie when it comes to database performance. I have been tasked with
trying to improve performance on one of our primary DB servers. I am looking
at a lot of different things related to performance and at the moment was
trying to focus on indexing.

Is there a Microsoft article that anyone can reference that describes the
root causes and remedies of SQL level blocking?
Any help would be appreciated.

      we have SQL server problem , i don't what reason ? the server is down
, i need restart the server and the event is "Error :17803 Severity :20
State :12 Insufficient memory available " ? i check many option on server ,
but the problem is not fix ???? i try open the SQL ...

In some articles, it is mentioned that Hyperthreaded processors might have
negative impact on query performance and the SQL Server must be configured
to use actual number of CPUs for parallelism. Even once I encountered this
situation and problem eliminated by using MAXDOP option ...

I was pretty sure I saw it someplace in 2005 that there was a sql to list
the actively running stored procedure with its current parameters being run.
Is that not true ?

I have about 20 databases on a clustered SQL Server 2005 (9.00.3042)
instance.  They range from 1GB to 20GB and are growing.  They are all OLTP
DBs.  I have all the data files (including system database data files and log
files) on one drive and all the log files on another drive ...

i would like to get a step by step on getting these counters:
tempdb size (not the user_objets_kb+ internal_objects_kb+ version_store_kb  
freespace_kb)
, Version Generation Rate

I'm setting up a new DB and separating the log files to storage separate
from the data.  The data will be on FC storage.  Will the log files perform
optimally on FC or ATA?
Thanks in advance.

 Is there any way to see the stored procedure statistics ?? How many times
stored procedure used, so we can remove some of unused stored procedure.
Thanks