SQL SERVER – A Simple Quiz – T-SQL Brain Trick

Today we are going to have very simple and interesting question. Run following T-SQL Code in SSMS. There are total of five lines. Three T-SQL statements separated by two horizontal lines. SELECT MAX(OBJECT_ID) FROM sys.objects ______________________________________ SELECT MIN(OBJECT_ID) FROM sys.objects ______________________________________ SELECT COUNT(OBJECT_ID) FROM sys.objects Now when you execute individual…
Read More

SQL SERVER – Next Version of SQL Server ‘Denali’ is Officially Named as SQL Server 2012

Recently I attended SQLPASS 2011 and it had few announcements and some of them really important. I am going to write in detail in future all the announcements. However, there is one announcement needs special attention and blog post. The official name of the next version of the SQL Server.…
Read More
All Articles safepeak2_2-600x400

SQLAuthority News – SafePeak version 2.1 for SQL Server Performance Acceleration

SQL
Safepeak

Couple of months ago I had the opportunity to share with my first look at SafePeak, a new and unique software solution for improving SQL Server performance and solving bottlenecks, accelerates the data access and cuts the CPU and IO of your SQL Server. SafePeak unique approach not just tells you about the problems but actually resolves them automatically and improves SQL Server performance and the performance of the applications dramatically. Let us read about Performance Acceleration.

Read More
All Articles sqlbasics-1

SQLAuthority News – SQLPASS – Today FREE 100 SQL Wait Stats Book Print Copy – Book Signing

“If there’s a book you really want to read, but it hasn’t been written yet, then you must write it.” ~Toni Morrison I wrote book on SQL Wait Stats. [Amazon] | [Flipkart] | [Kindle] I really wanted to learn about SQL Wait Stats. There was no real book available so I…
Read More

SQLAuthority News – SQLPASS – 100 SQL Wait Stats Book Print Copy Giveaway – A Book Every Minute for an Hour Tomorrow

“Appreciation is a wonderful thing: It makes what is excellent in others belong to us as well” – Voltaire “The greatest of all gifts is the power to estimate things at their true worth” – Francois De La Rochefoucauld Please Note: The date and time are Thursday 13 at 1…
Read More

SQL SERVER – expressor Studio 3.4 Rules Editor – ETL Graphical Coding Tool

New in the expressor Studio 3.4 release is the rules editor.  This graphical coding tool replaces the transform editor of earlier versions.  The rules editor works in concert with the newly introduced attribute propagation functionality to minimize the amount of data mapping and coding you need to provide.  The expressor…
Read More