SQL Server

Error:

SQL Script to list all the columns of a table with the Schema Information

If you are looking for a SQL Script which will display a list of all columns in a table and also the Schema Information, you can use the following Script.

Working with the DataTime datatype in SQL Server can be very frustrating at times Especially, when you use them in your where clause. For example If you want to list all records within a certain date range, you might end up retrieving incorrect rows.

If you come across some strange differences in your SQL Server or SQL Management Studio in comparisons to what others are using, you are sure to be tempted to want to check you version number to make sure if you have the latest version with all the latest Service Packs Installed.

I have been using Service Broker recently and found it exciting and useful. It seems like a cool feather in SQL Server. I use the SQL Dependency class in my .Net Windows Service to listen for the Service Broker Notification. When there is an Insert to the tables in my database the Service Broker sends me a Notification which alerts my Windows Service Application to Query data from the table and do the processing. It works very well.

Here is the SQL Script to find the duplicate rows in a table in SQL Server

How to check if Broker Service is enabled in SQL Server?

To Verify if the Broker Service is enabled on SQL Database, run the following Query:

The Dangers of Poor Quality Data

Many statistics demonstrate the high cost of poor quality data. The Data Warehousing Institute (TDWI) estimates that poor quality data costs US companies $611 billion per year due to revenue losses and productivity problems. Some examples of the issues that create this negative impact in enterprises include:

Is there any performance difference between using CHARINDEX vs LIKE in Where Clause?

Method  1:   Using the Select INTO Statement