SQL Server Archives - Page 339 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword

February 28, 2008

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

One of my friend sent me query asking me how to generate dynamic case statements in SQL. Every time he tries to run following query he is getting Error 156 : Incorrect syntax near the keyword. He was frustrated with following two queries. There are two different ways to solve…

SQL SERVER – 2005 – Licensing Model Compared to Other Database Products

February 24, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Best Practices, Data Warehousing, Database, DBA, Software Development, SQL Download, SQL Licensing

Yesterday on this blog I wrote about SQL SERVER – 2005 – Understanding Licensing Model. I have received many questions about pricing and comparing SQL Server with other RDBMS. One of the reason I like SQL Server because I am strong believer of licensed software usage and SQL Server is…

SQL SERVER – Find All The User Defined Functions (UDF) – Part 2

February 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

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…

SQLAuthority New – SQL Server 2008 Books Online CTP (February 2008)

February 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download

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)

SQL SERVER – UDF to Return a Calendar for Any Date for Any Year

February 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

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 –…

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”

February 19, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Index

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…

SQLAuthority News – Download SQL Server 2008 February CTP (CTP 6)

February 18, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

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)