One of my blog readers sent an email where he wanted my quick opinion about SQL Server cluster.
SQL SERVER – Convert Decimal to Time Format in String
A very strange question I received the other day in an email about how to convert decimal to time format string.
SQL SERVER – How to Create Linked Server to SQL Azure Database?
If you take the normal approach to create a linked server to SQL Azure Database, then you would end up in below error message.
SQL SERVER – Remove Duplicate Chars From String – Part 2
I have already made a post on SQL SERVER – UDF – Remove Duplicate Chars From String where I showed you a method of removing duplicate characters form alphanumeric string. The UDF uses WHILE LOOP to extract the numbers.
SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns
Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored procedure sp_special_columns customers today.
SQL SERVER – System Procedure to List Out Table From Linked Server
There is a system procedure named sp_tables which is used to list out the tables available in the CURRENT database of the CURRENT server. But did you know that there exists another system stored procedure that can be used to list out the tables of database available in the linked server?
SQL SERVER – How to Get Updated Link for Code and Database Samples?
Some emails, indeed triggers blog posts such as the one I received the other day about database samples.