In this blogI am going to write a function which returns the word count in sql server.

This post provides some guidance on improving the slow performance stored procedures.

This blog show you how to use the nhibernate connection and transaction instead of opening a new ado connection.

This blog exhibits Columnstore Index in SQL Server.

Sometimes this happens when you start Windows and Open Microsoft SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not ...

In this blog, you will learn how you can find all the months of a particular quarter.

In this blog, I am trying to explain how I solved "connection timeout" errors while executing SQL Jobs, which are part of primary node in "AlwaysOn" multi subnet AG setup

Some simple queries that might be helpful

Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure.

In this blog, I have added div tag in the stored procedure, as I used in ASP.NET html.

This blog enables you to find the list of tables used in the stored procedure, using types of joins.

In this blog, we will understand how to resolve "cannot connect to a local\remote SQL Server instance using SQL Server authentication with a error code: 18456".

Triggers are associated with the table or view directly.

We can remove Null values in Table data.

This blog acquaints you with aborting/ killing a long running stored procedure.

In this blog, I will explain how to check a specific word or character in a given statement using CHARINDEX() function in SQL Server. An alternative to CHARINDEX() is using LIKE predicate.

The "exists" condition is used to check if there is any table and stored procedure with that name.

By executing a SQL query, we can get detailed information about what date and time the table and stored procedure were created.

sys.objects has a big role.

This blog demonstrates why stored procedures are outdated.