Even though that doesn't make sense but that's "BY DESIGN" SSMS 2005 to SSIS 2005 and SSMS 2008 to SSIS 2008. Lot of People have raised their concern...
Make sure any system copy job/backup job etc. (Third Party) is not running. I had seen this befoe and found that TSM was scheduled to run that time.
sometimes SQL Server perf counters does not load, you need to add manually; If the SQL Server counters are missing in action: a) From the output from...
wholly cow!!! 90 minutes for 50K rows. Check error log and windows event log for IO errors and memory warning messages etc.
Please post complete error message.
Your Objective " move data from 100s of tables in an operational database into an archive database" in an optimized manner. So, before jumping on any...
Dave- Did you find solution for this issue?
Good news for those using XML. Some XML performance related issues are fixed in this CU
You are good to go for installations. Analyze your applications memory requirements to add more. Capture these counters when your application is...
I have seen this behavior on SQL Server 2008 x-64 especially on Win-2003 clusters in CTP version. I hope this is resolved in RTM, not sure though:)...
I am trying to automate a solution using batch file and one of the things I need to do is give users rights "Logon as a Batch Job", in the local...
Its good to hear that problem is resolved. I didn't get this "I have already ran the alter database isolation command in my sqlserver 2005" Please...
Yes, 2008 link is throwing garbage. Earlier it opened fine now it seems to be some problem with link.
create the nosync subscription copy all the meta data from the source (including the new rowguid column, constraint, triggers, indexes, statistics)....
I don't see any issue.
Windows 2003 and before http://www.microsoft.com/windowsserver2003/technologies/clustering/resources.mspx#ENH Windows 2008...
You are using Standard edition of SQL Server 2005 (64-bit) where lock pages in memory cannot be set for sql server. My suggestion is to look at Page...
BTW- what service pack sql 2005 is running
Use hint in query to use Hash joins. However, hint usage is not recommended but if it improves performance than use it and change the code in future...
As you are using WIndows 2008/SQl2008 combination I would suggest you to use cluster validation tool to find out any configuration issues. Microsoft...
Separate names with a comma.
