Hi There I created the test below as a quick check of the servers committed write capability. This scripts runs acceptably fast on my laptop, (which is about 3 year old 7200rpm hard disk, 2.something GHZ pentium processor. 2gb memory. Windows XP 32 bit.) By comparision we have a 64 bit server that is...

I have a webapp in Asp.net 1.1 with SqlServer 2005 Express Edition. It's a typical small website with 1.000 registered users and 100 articles (most textual) published. This thing is on a Pentium 4 single-processor machine with 512mb of RAM which hosts both the SQL and the IIS. The site has only 600...

I have the following view's select statement - I have indexes on all the columns used in the joins and wheres and still - "select *" on this view is taking 2 minutes for getting 3493 rows. I see an "INDEX SPOOL" in the query execution plan. I broke it down to multiple views and...

I am seeing these errors as well. Does that mean the error never fired if in the LAST OCCURRED column it says NEVER OCCURRED? This would be a good sign right? Company is on SQL 7 For the top msdb and tempdb erros they have an Error of 9002 Thanks

Hi, I am using SQL Server 2005 Import wizard/DTS Package to Import one table data from X Server to Y Server. To Import 20 million records its taking almost >3 hours, when i am importing i observerd in Y Server -> Task Manager -> Network Utilization is 0.25% of 1 Gbps. If i am copying any fdata...

We are currently an IBM shop; however, IBM seems to not understand basic I/O configurations with SQL Server and I am pulling my hair one piece at a time. The particular database in question is a third-party product that is so poorly designed; however, my finance department just think its peachy. I just...

Hi! I have a join which looks something like this: SELECT ... FROM @memberselection t INNER JOIN order o ON o.member_id = t.member_id INNER JOIN transactions t ON t.order_id = o.order_id For a large set in @memberselection this takes forever. For a selection of about 1000 members, it takes 30 second...

Introduction: This article helps you to understand the fact that sys.dm_exec_query_stats returns incorrect CPU utilization when a query executes in parallel. The purpose of this article is to help you better understand SQL Server 2005 Performance Monitoring and Tuning. The purpose of this article is...

Hello everybody, Happy Holidays! I saw a post by evilDBA dated: "11-21-2007 4:57 PM " tha seems similar to what's happening to me, but my scenareo is a bit different. The Avg. Queue length is usuall close to 0.02, but sudden spikes occur (for about 15-20 sec). The server is a dedicated...

Hello, I have a project which is create surveys.. It has 65 Columns and 30.000 rows, with this structure queries are working very slow..You can create this structure as 6 columns 1.800.000 rows. Which one is the best for perfomance and easy to use for queries... Best Regards,