see if the snapshot folder is their and by any chance not deleted by anybody and it has a proper NT permission for the SQLServer Agent account....also check the snapshot agent job history for the exact error message which will help u rectify this issue

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

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

I have a table and there are two index. The first index is on Column1 and second index is on Column2. My query is below. Since my where clause is referencing two columns should I change or add an index so the index is Column1, Column2? Select * from MyTable where Column1 = X and Column2 = Y

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.

Fellow DB gurus, I have a interesting situation. I have a very large database which I need to load. It is several txt files containing a total of 250 million records totaling approximately 300GB. Loading this in the database is not the issue. The issue is, what is the best way to design the subsystem...