The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available:
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.
SQLAuthority News – 2008 – Download – SQL Server 2008 Brochure
SQL Server 2008 Brochure is available to download. It contains many information like available Server Editions, Top New Features, New Available Technologies and additional resources.
SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes
I have received many emails that I should write more post like SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes.
SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.sql)
Just a day ago while playing with SQL Server I suddenly faced a new kind of error, which I have never seen before. This error happens when clicked on New Query in SQL Server Management Studio. Let us learn in this blog post how we will fix the error – cannot find template file for a new query.Â
SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution
ERROR : The query processor could not start the necessary thread resources for parallel query execution.