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...

Hello, my name is Tim and it is my first post on sql-server-performance.com I have a problem with the duration of a sql-query, but I don't know how I can optimize this. Here are the database-tables: Table1 (2.600.000 lines): A_CODE (PS,int, NOT NULL) B_CODE (PS,int, NOT NULL) C_CODE (PS,int, NOT...

Hi Everyone, The following article I read puzzles me regarding the Paging File, http://technet2.microsoft.com/windowsserver/en/library/00284c8d-7a42-40f2-8a01-8de61dccd8c91033.mspx?mfr=true. "... Under such circumstances, the effectiveness of this large of page file could be minimal, based on the...

True,but, I suspect If you would place your each table on separate file but the disk drives are not physically separate it wont help that much.

Welcome to Forum!! suggests to refer couple of articles http://support.microsoft.com/kb/323046/en-us?spid=2852&sid=539 & http://www.sql-server-performance.com/tips/transactional_replication_p1.aspx though it is for SQL 2000, you take help of it. Here is an article on Replication with Log Shipping...

Hello there, I'm searching for the best solution to scale out transactional replication with hundreds of publications, and that's the situation: we use transactional replication (push, no update) with almost 100 articles (tables and sp) on sql2k5. We've the online database, that expose a...

I dont think this will have any worst effect, SQL Server can handle terabytes of size and many concurrent user actions, you need to pay more attention to proper table and index design.

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...