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 MoreSQL SERVER – Introduction to Performance Monitor – How to Use Perfmon
Yesterday I wrote about SQL SERVER – Introduction to Three Important Performance Counters. I received few questions about how to use Perfmon. Here is very brief introduction to Perfmon. There are three ways to launch Perfmon. 1) Type “start perfmon” at the command prompt. 2) Go to Start | Programs…
Read MoreSQL SERVER – Introduction to Three Important Performance Counters
Performance Counters are very important to evaluate. There are more than thousands of Performance Counters. Today I will cover three basic but very important Performance Counters. Processor:% Processor Time It reports the total processor time with respect to the available capacity of the server. If counter is between 50 to…
Read More