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
Madhivanan shared another way to find all the user defined functions in a database, using information_schema.routines. Here is his short script.
Installing SQL Server on Linux
Installing SQL Server on Linux involves supported packages, mssql-conf setup, service checks, and an understanding of Windows differences.
Reading the SQL Server Error Log Properly
Read the SQL Server error log for startup details and incident context, filter it with T-SQL, and cycle files without losing needed history.
SQL SERVER – UDF to Return a Calendar for Any Date for Any Year
Reader Dan Golden built on my weekly calendar function to create a UDF to return a calendar for any date for any year. I fixed a small first and last week bug.
SQL 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”
A SELECT on a table with only a nonclustered index gave Msg 0, A severe error occurred on the current command. Cumulative update 6 for SQL Server 2005 SP2 fixes it.
Rolling Back a Cumulative Update Safely
Rolling Back a Cumulative Update needs backups, setup evidence, a tested uninstall path, and special care for databases changed after patching.
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’.
DBCC shows Msg 2593: There are ROWCOUNT rows in PAGECOUNT pages for object. It is harmless and for information only. Here is what it means.
SQL SERVER – Index Reorganize or Index Rebuild
When should you use Index Reorganize and when Index Rebuild? I get this question a lot, so here is a pointer to my earlier post that explains both with T-SQL.