It goes without saying that computer running slow is a common problem we all face, a pestering one indeed! Last week, I had to format my computer as it was running at an annoyingly tortoise pace. After formatting it, I installed Visual Studio 2008. When tested Visual Studio 2008 worked all fine. However, when I attempted to install SQL Server 2008, I was confronted with an error about NET Framework 3.5 missing.
SQLAuthority News – Troubleshooting Performance Problems in SQL Server 2008
Troubleshooting Performance Problems in SQL Server 2008
SQL Server Technical Article
Writers: Sunil Agarwal, Boris Baryshnikov, Keith Elmore, Juergen Thomas, Kun Cheng, Burzin Patel
Technical Reviewers: Jerome Halmans, Fabricio Voznika, George Reynya
Published: March 2009
SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested
I’m pleased to inform you all that I’ve recently launched my personal website. It’s been a long time since I’ve been writing on my blog https://blog.sqlauthority.com, but I’ve been keeping my personal notes at my homepage http://www.pinaldave.com. I’ve completely rehauled the website to give it the much-needed makeover, right from…
Read More
SQLAuthority News – Microsoft Certification Exam – Discount Code
Note: I am republishing this blog post as the offer of this code is extended to April 30, 2009. Please note down this important code or share with your colleagues who are keen to take Microsoft Certification Exam. This unique code is only available through Microsoft MVP’s and only published…
Read MoreSQL SERVER – Poll Result – What is Your Favorite Database?
I previously posted a Poll about What is Your Favorite Database? I got great response from users. In fact, I received some of the best poll-related comments on this blog and they are worth reading. Let us check the result first. Here are the votes I received on different database.…
Read More
SQL SERVER – Check if Current Login is Part of Server Role Member
I often work on consulting projects with umpteen clients from across the globe. The nature of the works I usually receive necessitates me to take on the role of a system admin. Now, this role is trailed by come common issues. This article revolves around one such concern. Let us learn about Server Role Member.
SQL SERVER – Introduction to JOINs – Basic of JOINs
The launch of Gandhinagar SQL Server User Group was a tremendous, astonishing success! It was overwhelming to see a large gathering of enthusiasts looking up to me (I was the Key Speaker) eager to enhance their knowledge and participate in some brainstorming discussions. Some members of User Group had requested…
Read MoreSQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)
A couple of days back I had my computer formatted. I reinstalled it with Vista SP1 32bit. Subsequent to installing other indispensable software I tried to install SQL Server 2005 . However, it instantly displayed the following error message. The SQL Server System Configuration Checker cannot be executed due to…
Read MoreSQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
This post is about a riveting observation I made a few days back. While playing with transactions I came across two DMVs that are associated with Transactions. 1) sys.dm_tran_active_transactions – Returns information about transactions for the instance of SQL Server. 2) sys.dm_tran_current_transaction – Returns a single row that displays the…
Read MoreSQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
This article revolves around a trivial yet common issue. There might be a set of people for whom the current topic might appear to be insignificant. But I have been asked this question innumerable times, particularly from  people who are frequenting using forums or have blog related to storage and…
Read More