try below solu

http://forums.aspfree.com/microsoft-sql-server-14/collation-conflict-20773.html

ok check this link below

http://www.mssqltips.com/sqlservertip/2361/rebuilding-sql-server-indexes-using-the-online-option/[/url]

:w00t:

At any way you can follows basic rules to improve performance as

http://dba.stackexchange.com/questions/6441/cxpacket-waits-performance-tune-for-sql-server-2008

:w00t:

this link has all thing as i thought

http://support.microsoft.com/kb/968930/en-us

:hehe:

😀

i post you Guid with images may be easier to understand

http://www.mssqltips.com/sqlservertip/1220/sql-server-2005-upgrade-considerations-for-dbas-and-developers/[/url]

:hehe:

Thank you 🙂 for your answer ,You save my time as i have the same Questions

:hehe:

:w00t:

Try these important links below

FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005

http://support.microsoft.com/kb/915308

http://msdn.microsoft.com/en-us/library/ms178072.aspx

:w00t:

we are experiencing the following error when backing up :

A nonrecoverable I/O error occurred on file "" BACKUP DATABASE is terminating abnormally.

Reading some posts on this forum I can...

:w00t:

Hello I found you a good Article ,About your request

http://www.techrepublic.com/blog/datacenter/how-to-import-an-excel-file-into-sql-server-2005-using-integration-services/205

😀

I have no experiance at this field but show this link may help you man

http://www.pinnaclemanagement.com/implementing-your-enterprise-evms-microsoft-project-server-2010-and-evms-forproject-2010/350

check link pls

http://web.townsendsecurity.com/[/url]

:hehe:

😀

ok check links

http://www.google.com.eg/url?sa=t&rct=j&q=ms+sql+defragmenting+the+indexes+solutions&source=web&cd=5&ved=0CEIQFjAE&url=http%3A%2F%2Fwww.vldb.org%2Fpvldb%2Fvol4%2Fp1407-narasayya.pdf&ei=0SgqT-LRJIiF-wa4rqGPDg&usg=AFQjCNExIhOX4tNEne-VPLPOJZ0gJ3Lhrg

When should I do one over the other?

As noted above, an important factor is the amount of time it will take to complete each operation (usually...

:w00t:

Hello i suggest you to use Using TRY...CATCH in Transact-SQL to avoid any undesired results

show below link

http://msdn.microsoft.com/en-us/library/ms179296.aspx

:hehe:

:hehe:

Hello i think you didn't gave us enought info about your server specifications ,and ms sql version or confiq

At any way

hen you start SQL Server, SQL Server memory usage...

😉

Hello,Just i can suggest you some thing maybe useful to decrease execution time which :==>in table STAGE_RETURNS_CLS_TMP ,you can add new Boolean column to indicate if have relation to...