As suggested it is not advised to shrink files/db always/regular and here is the good example given by Tibor Karasazi http://www.karaszi.com/SQLServer/info_dont_shrink.asp

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, suggests to refer http://www.sql-server-performance.com/tips/asp_sql_server_p1.aspx and http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45 before you go ahead.

Hi, Welcome to the forum!! yes according to the research paper it stands true to blob upto 1 MB of files, but then the hardware they have used to test stress would be different then yours, the scope of the application and its growth would be different. So, you have to test it with your available hardware...

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

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

You can refer http://www.sql-server-performance.com/tips/stored_procedures_p1.aspx , http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/performancetuningstoredprocedures/2505/ and http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1247499,00.html

Hi, First thing I would do is to identify if any long running queries and then check its execution plan and needed fine tune it.

You can perform the activity as said by Thomas, but this will take a time, if this is necesaary schedule this in off-pick hour to avoid any hassels.

Hi, If you need to replicate those data only for reporting purpose snapshot replciation will do(low latency) , else you can go with transactional replication. If your requirement is something that wants Offshore data to be merge with your US - OLTP database and vice versa then go for merge replication...