There is always more than one way to do one thing in any programming languages. In SQL Server there is always more than one way to achieve same result set. It is quite often I see that developers write subqueries in place of joins or joins in place subqueries.
SQL SERVER – Join Better Performance – LEFT JOIN or NOT IN?
First of all answer this question : Which method of T-SQL is better for performance LEFT JOIN or NOT IN when writing a query? The answer is: It depends! It all depends on what kind of data is and what kind query it is etc. In that case just for fun guess one option LEFT JOIN or NOT IN. If you need to refer the query which demonstrates the mentioned clauses, review following two queries for Join Better Performance.
SQL SERVER – 2008 – Update Resolving Conflict Between SQL Server 2005 and SQL Server 2008
I have been receiving many complains where user has installed SQL Server 2008 and when trying to install SQL Server 2005 after that installation never completed. Well, Microsoft has provided solution for this issue. Download the patch and install it first and then try to install SQL Server 2005 and…
Read MoreSQL SERVER – Identifiers As Valid Object Names
Previous I wrote blog post about SQL SERVER – Explanation and Example Four Part Name. It was explaining the new feature of SQL Server 2005 of Schema. Few days ago I received email from Chi-Ho, Min of Taiwan, he suggested that he was successfully able to use column without completely…
Read More
SQL SERVER – Is Cursor Database Object or Datatype?
Whenever we want to loop something we always look for logic like WHILE LOOP or FOR LOOP. Trust me on my word that both of them are cursor when it is about SQL Server.
SQL SERVER – Generate Foreign Key Scripts For Database
Regular reader of SQLAuthority.com blog Madhaiyan Seenivasan has send email with one very interesting script. This script generates all the foreign key addition script for your database. Many times there are situations where one need to drop all the foreign key and add them back. This SQL Script can be…
Read MoreSQLAuthority News – My Favorite Link of This Blog
I have written more than 500 article on this blog so far and the number is increasing. Many times I get this question, which one link do I click the most. It is very interesting for myself to read my previous articles, as I often like to read them and…
Read MoreSQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures
While playing with SQL Server 2008 I found new feature of “Row Constructors”, where I can load temp table from stored procedure directly. Look at the following SQL where I have to use OpenQuery from server to itself creating loopback server and execute stored procedure and insert into temp table.…
Read MoreSQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks
Read my article published at SQL Server Magazine Surface Area Configuration Tools Reduce Exposure To Security Risks [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – SQL Slammer (Computer Worm)
Just a day ago, while talking with my outsourcing team one of the DBA asked me question. Is there any virus associated with SQL Server? I really find this question very interesting as I did not know if there are any viruses associated with SQL Server. I searched Google for…
Read More