The problem may be the reports on SSRS are being deployed to a Web Server and not Web Service. In Visual Studio deploys reports to Web Service. See...
Hi There can be Tons of issues related to performance especially HIGH CPU. I am formally documenting them here with a methodology.. See if this...
It can be the case when you have Auto Shrink for the database enabled or some shrink activity going on for the database. we tried to explain how...
Different options: * Report Builder of Reporting Services * Excel (Local .cub file or Server)
Hi Guys, Sorry to pitch in late... but both of these errors are not related. See the time stamps!!!! 2009-05-27 15:43:51.32 spid140 Invalid buffer...
Only way to kill it using Kill UOW (unit of work) which is listed in syslockinfo.
Use SSIS Transfer Login Tasks to transfer logins
Even with data drive subscription sending mails with excel is possible
Use Subscriptions or Data Driven Subscriptions with which mails can be sent in desired formats (like excel, tiff, pdf).
Though CU typically contain all the previous CU fixes when service packs are released the story changes. Say you are in CU 10+ in SP2, if you apply...
Before adding RAM to server, what were the objectives and reasons for adding RAM. Was High CPU the reason for adding RAM. If that is the reason, then...
High CPU can be caused by Hash / Merge Joins, Compilation / Remcompilations which can be due to more records and may be related to lack of indexes as...
Do antivirus use SQL Server in the back end to store virus definition. MSDE and others.. Where are you getting this error and when are you getting...
Yes this is set by default in sql server 2000.
Have you tried using CTE (Common Table Expression) if it is SQL Server 2005.. They may be of bit help here.
But you will have to be aware of the implications of it. Since a new log file is being built for the new database the recovery process will not occur...
Please go thru this http://msdn.microsoft.com/en-us/library/ms345193.aspx
Yes it can. For SQL Server there is a SQLRES.dll that does ISAlive and LooksAlive Test. IsAlive test connects to SQL Server and AFAIK, runs select...
Memory bottleneck should be understood from 2 aspects Is Physical Memory on OS not sufficient: For this Check in Perfmon Available MBytes (Memory)....
Instead of Google search for statistics in SQLBooks Online it has more information in it.. or refer this link...
Separate names with a comma.
