I had a very interesting situation at my recent performance tuning project. I realize that the developers there were running very large dataset queries on their production server randomly. I got alarmed so I suggested their developer not to do that on the production server; instead, they could create some alternate scenarios where they could synchronize database and query on the same server. The production server should not be used for development work. It should be queried with proper methods (queries, Stored Procedures, etc.), supporting production application.
SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the Views Part 2
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… Note: I have updated the title based on feedback of Davide Mauri (Solid Quality Mentors). Thank you for your help. Let’s see another reason…
Read More
SQL SERVER – Does Order of Column in WHERE Clause Matter?
Today is a quick puzzle time. Let us learn about – Does the order of column used in WHERE clause matter for performance? Let us learn today.
SQLAuthority News – Download Microsoft SQL Server Migration Assistant
SSMA for Oracle v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2. SSMA for Access v4.2 Microsoft SQL Server Migration Assistant (SSMA) is a toolkit…
Read MoreSQLAuthority News – Feedback Received for Virtual Tech Days Sessions on Spatial Database
I recently got opportunity to speak at Virtual Tech Days on August 18, 2010 on the subject Spatial Database. The event was heavily attended by enthusiasts world wide. I delivered session the on the subject of Spatial Database and it was great fun to deliver the session. I have delivered…
Read MoreSQL SERVER – ORDER BY Does Not Work – Limitation of the Views Part 1
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… Recently, I was about the limitations of views. I started to make a list and realized that there are many limitations of the views. Let…
Read More
SQL SERVER – Computed Columns – Index and Performance
This is the last article in the series of the computed columns I have been writing. Here are previous articles. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER –…
Read More