Useful T-SQL queries and scripts to work in SQL Server

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of...

Useful T-SQL queries and scripts to work in SQL Server

This post is about some queries and scripts that I use in my daily work on SQL Server. Some of them are self-explanatory, i.e. the name of the query/script...

How to Write a Better T-SQL Code

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are...

How to Write a Better T-SQL Code

Here are some basic guidelines that are good to consider when writing T-SQL (Transact SQL). These tips and hints are aimed for the beginner-level T-SQL developers. Always Use a...

Symmetric Except

The COUNT Function in T-SQL

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not return the desired result. For the big tables, the counting of the rows could cause blocking as well as take some more time.

Some New Cool Features in SSMS

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases...

Some New Cool Features in SSMS

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward. Vulnerability Assessment (active from SSMS 17.4) Right...

Using Time Zones in SQL Server

The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be...

Using Time Zones in SQL Server

The usage of time zones in applications becomes inevitable, especially with the globalization of the applications. Reports need to be run in different time zones. Services have to consider...