The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available:
SQL SERVER – Find All The User Defined Functions (UDF) – Part 2
Few days ago, I wrote about SQL SERVER – Find All The User Defined Functions (UDF) in a Database. Regular reader of this blog Madhivanan has suggested following alternate method to do the same task of finding all the user defined functions in database. USE AdventureWorks GO SELECT specific_name,specific_schema FROM…
Read More
SQLAuthority News – Download SQL Server 2017
This was a very old blog post and I have decided to re-write this as it was no longer useful. In this blog post, we will learn about SQL Server 2017. Here is how you can download SQL Server 2017 related material.
SQLAuthority New – SQL Server 2008 Books Online CTP (February 2008)
Download a Community Technology Preview (CTP) version of the documentation and tutorials for Microsoft SQL Server 2008. SQL Server 2008 Books Online CTP (February 2008) Reference : Pinal Dave (https://blog.sqlauthority.com)
Read MoreSQL SERVER – UDF to Return a Calendar for Any Date for Any Year
It gives me great pleasure to write articles like today’s one because I have received great comment from one of regular reader who has taken UDF written by me and created another UDF using that UDF which enhances functionality of it. I had written previous article about SQL SERVER –…
Read MoreSQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”
In SQL Server 2005 while testing Indexes I had created a table with one non clustered index only. I did not create any clustered index on table. After that I ran SELECT statement, it gave me following error. I was very surprised when I looked at error. It says Msg…
Read MoreSQLAuthority News – Download SQL Server 2008 February CTP (CTP 6)
SQL Server 2008 February CTP (CTP 6) has been released. Download from here. It will direct you to page which is dated November 2007. Continue with November 2007 which will take you to February 2008 CTP 6 Download page. Reference : Pinal Dave (https://blog.sqlauthority.com)
Read More
SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string
Jr. Developer asked me other day how to escape single quote?
User can escape single quote using two single quotes (NOT double quote).
SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.
There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.
This message is displayed when DBCC command is ran for any database. It is harmless and displayed for information purpose only. For each database DBCC commands displays number of rows and number of pages it is using. DBCC CHECKALLOC is exception for this messages.
SQL SERVER – Index Reorganize or Index Rebuild
Recently, I have received one question quite often about when to Index Reorganize and when to Index Rebuild. I have already written about this topic earlier but it seems that many are unable to search it. SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script…
Read More