CLR is Common Language Runtime.
Here is the diagram which explains the architecture of the CLR.
SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2
Following error is very generic error and I have previously written SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use. Msg 3702, Level 16, State 3, Line 2 Cannot drop database “DataBaseName” because it is currently in use. One of the reader…
Read MoreSQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER
I have previously written SQL SERVER – 2005 – Find Nth Highest Record from Database Table where I have shown query to find 4th highest record from database table. Everytime when I write blog I am always very eager to read comments of readers. Some of regular readers are industry…
Read MoreSQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3
Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with alternate solution of the same problem. Khadar Khan came up with good solution using CTE SQL SERVER – How to Retrieve TOP and…
Read More
SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2 – CTE
Please read SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL before continuing this article. I had asked users to come up with an alternate solution of the same problem. In this blog post we will see solution with the help of CTE.
SQLAuthority News – Authors Most Visited Article on Blog
I received many emails regarding SQLAuthority News – 500th Post – An Interesting Journey with SQL Server. One of the email asked interesting question regarding my most visited article on this blog. It was interesting to know that reader wants to know which article I visit the most. Following is…
Read More
SQL SERVER – Find Nth Highest Record from Database Table
I had previously written SQL SERVER – Query to Retrieve the Nth Maximum value. I just received an email that if I can write this using AdventureWorks database as it is a default sample database for SQL Server 2005 and the user can run the query against it and understand it better. Let us see how we can find highest record from database.
SQLAuthority News – 500th Post – An Interesting Journey with SQL Server
I am very pleased to write my 500th post. After 500 posts, I still have same feeling when I wrote first post on this blog. I would like to thank my family for their continuous support in writing this blog. Most of all I want to thank all of YOU…
Read MoreSQLAuthority News – SQL Server 2005 is The Data Platform Leader
Questions I often get asked : How big is market for SQL Server? Is SQL Server industry leader? Does learning SQL Server technology will help future career? Why did you pick SQL Server as your expertise? I just love SQL Server. Let us read following article taken directly from Microsoft,…
Read MoreSQL SERVER – Simple Example of Cursor – Sample Cursor Part 2
I have recently received email that I should update SQL SERVER – Simple Example of Cursor with example of AdventureWorks database. Simple Example of Cursor using AdventureWorks Database is listed here. USE AdventureWorks GO DECLARE @ProductID INT DECLARE @getProductID CURSOR SET @getProductID = CURSOR FOR SELECT ProductID FROM Production.Product OPEN @getProductID FETCH…
Read More