-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Yesterday in one of the SQL forums there was an issue which was reported by one of the user.The question was something like – ‘I accidentally deleted the only Login…
Most of the time we need to capture the potential hardware capacity of the server which hosts SQL Server and below TSQL will help you to do this. This script…
Today more and more systems are coming with NUMA Architecture and I came across this architecture when I was dealing with wait stats. So whats is NUMA or Non-Uniform Memory…
During Initial versions(RTM) of SQL 2008 and R2 I have observed multiple posts related to the error “There is insufficient system memory in resource pool ‘internal’ to run this query”.…
Finally I got hold of the much awaited SQL Server MVP Deep Dives 2.I had pre-ordered this book before PASS 2011 to ensure my copy. Top quality material delivered by…
Over the last 2 years I have been working with multiple clients and one of the common situations which I observed when dealing with prebuilt script(Application setup scripts) is having an…
Microsoft released SQL Server 2012 licensing data sheet and this article will cover the major details. Three main editions are – Enterprise – For mission critical application and large scale…
Recently there was an interesting question from one of the forum users ,the question was something like ‘How long the data collector jobs are scheduled to run when I configure…
Have you ever observed this behavior Under SSMS > right-click SQL Server Agent > Properties> History. Enable checkbox “Remove agent History Older than 4 weeks.”. Press OK. Everything is fine (no error…
Cloud & SQLSailor 