How to fix when you can’t copy data when RDPed into a server
So you are RDPed into your SQL Server, and you are trying to copy a script from your desktop to the server, or from the server to your desktop. But you can’t for some reason. All you get is what’s in the local buffer. One option is to log out of the machine and log […]
Very useful little query to monitor the health of service broker
While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was. So I came up with this little query which is surprisingly effective. select far_service, state_desc, count(*) messages from sys.conversation_endpoints group by state_desc, far_service ORDER BY far_service, state_desc Hopefuly you find this helpful. […]
Very useful little query to monitor the health of service broker
While dealing with a SQL Server Service Broker issue I needed a quick easy way to see how backlogged the service broker was. So I came up with this little query which is surprisingly effective. select far_service, state_desc, count(*) messages from sys.conversation_endpoints group by state_desc, far_service ORDER BY far_service, state_desc Hopefuly you find this helpful. […]
Does your SQL Server database improve SharePoint performance?
This morning I posted by first article up on SearchWinIT.com called “Does your SQL Server database improve SharePoint performance?“. It is all about getting the most out of your SharePoint environment by getting the most out of your SQL Server. Denny