SQL Performance Archives - Page 82 of 100 - SQL Authority with Pinal Dave

SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY

November 24, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers. I ran following two queries and found that I am getting different result-set. When I carefully observed I found that actually the result was same but order of the…

SQLAuthority News – RML Utilities – Usage and Additional Help

November 13, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download

Yesterday I wrote about SQLAuthority News – Download RML Utilities for SQL Server. I received many emails where different developers requested how to find additional help regarding RML Utilities. Few users reported that they are not able to install RML Utilities because of some reporting service pre-requisite. If RML Utilities…

SQLAuthority News – Download RML Utilities for SQL Server

November 12, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Database, SQL Download, SQL Server Security

Note: Download RML Utilities for SQL Server by Microsoft The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see: Which application, database or login is using the most resources, and which queries are responsible…

SQL SERVER – Refresh Database Using T-SQL

November 7, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server DBCC, SQL Stored Procedure

Yesterday I received following questions on blog. Ashish Agarwal asked following question. Hi Pinal, Can we refresh a database (like we do by right clicking database node in object explorer and clicking on refresh) thru SQL Query? If yes, can you please tell me the query? Thanks, Ashish Agarwal Answer…

SQL SERVER – DECLARE Multiple Variables in One Statement

October 31, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL Scripts

Just a day ago, while I was enjoying mini vacation during festival of Diwali I met one of the .NET developer who is big fan of Oracle. While discussing he suggested that he wished SQL Server should have feature where multiple variable can be declared in one statement. I requested…

SQL SERVER – INNER JOIN using LEFT JOIN statement – Performance Analysis

October 25, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

Just a day ago, while I was working with JOINs I find one interesting observation, which has prompted me to create following example. Before we continue further let me make very clear that INNER JOIN should be used where it can not be used and simulating INNER JOIN using any…

SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations

October 22, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Database, SQL Download, SQL White Papers

Hyper-V in Windows Server 2008 is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering TCO and maintaining or improving Quality of Service. Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations…