Exception from HRESULT: 0x800AC472

Time dimesions in SSAS

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Interesting Facts about execute command in SQL Server

Issue in accessing the sdf file - sql server compact edition

Issue in DB restore options in sql server.

How to disable and enable trigger on a table in MS- SQL

Checking status of Triggers (enable/disable) in MS-SQL

How to change the schema of a table in MS-SQL

Triggers are used to automate, implement business rules, enforce referential data integrity in database applications and they should be used wisely to avoid slowness.

To Get Accurate Records between two dates from the Table of MS SQL SERVER.

SELECT INTO Statement in SQL is used to copy data from one table to another and it can also be use in create backup of the table.

A rule in SQL is used to specify a restriction on the values for a column or a user defined value.

In this blog I will explain the steps involved to install SQL Server Compact 4.0 and the SQL Server Compact Toolbox add-in for Visual Studio 2010.

My point of view was to demonstrate how we can use SQL Server features to identify Leap year.

Creates a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources

Difference Between Isnull , case when and COALESCE

Use of Isnull function and nullif

Sql server using make Last day and First day of week and current week.

In this Blog, we will concatenate column values of Multiple Rows into a Single column in SQL server.