(Richard Waymire) In our first post about the error logs, we covered the version information for SQL Server. In this second part, we’ll keep going through the valuable information in the error logs that will help you better understand and troubleshoot issues with Windchill. We’ll focus on finding SQ

(Tapas Pal) As part of the SOX (Sarbanes-Oxley Act) regulatory compliance implementation, one of my banking customers asked me to encrypt their databasefor an already existing application. It was a business critical web application developed using Visual Studio 2005 (ASP.NET 2.0 framework) and SQL S

(Pinalkumar Dave) The title of this post is what I can express here for this quick blog post. I was asked in recent query tuning consultation project, if I can share my script which I use to figure out which is the most expensive queries are running on SQL Server.

(Ami Levin) In second part of this series on physical join operators we looked at the Merge Operator. In the final part of the series we turn our attention to the Hash operator.

(Matteo Lorini) Tempdb plays an important role on SQL Server performance. A tempdb database that resides on a slow set of disks or a tempdb database that has been sized incorrectly may have an overall impact on query performance. In this tip I will go over some best practices for performance related

(Suprotim Agarwal) I had recently written a query to Select the Latest Record based on a Condition in SQL Server. A SQLServerCurry.com reader Mazz wrote back asking how to use the same query to count how many times a student took an exam for each course. Here’s the modified query that works on SQL S

(Jani Jarvinen) Locking and transaction support is essential in any relational database supporting multiple users. Microsoft SQL Server has provided both of these features from the very beginning, and they are present even in the latest 2008 version. Even if you have used SQL Server before, there ar

(Anu Chawla) After you have your disk subsystem running for SQL Server and that computer is deployed into a production environment, how do you know you have the subsystem configured correctly? Monitoring of course! If you monitor by using Windows Performance Monitor, you can determine if you have th

(Ami Levin) In Part I of this series on physical join operators we looked at Nested Loops. We now turn our attention to the Merge operator.

(Don Jones) One of the biggest headaches “reluctant DBAs” have to deal with involves supporting SQL Server when it’s being used to maintain someone else’s application. What can you safely do without potentially breaking the app? (R)