Blog

Top 8 Useful and Important Scripts in SQL - Part 1

Over the last few months, we have been writing articles to try to assist you in your SQL Server ventures. We have decided to compile a list of our top 8 useful and important scripts of the last couple of months. Please feel free to use this as a resource to improve your productivity. If you have other useful scripts that you want to share, please feel free to post them in the comments.

By Admin

Top 8 Useful and Important Scripts in SQL - Part 2

The following scripts result in a list of table and column names which contain the word "Product".

By Admin

Stored Procedures

A stored procedure is a group of Transact-Sql statements compiled into a single execution plan. Stored procedures offer huge benefits

By Admin

SQL and Transact-SQL

Transact-SQL (T-SQL) is Microsoft's enhanced version of the Structured Query Language (SQL). The Transact-SQL language was introduced by Sybase. It includes transaction control, enabling conditional processing, error handling, row processing, declared variables and more. When T-SQL is written and run, it can ultimately impact your server’s performance.

By Admin

SQL Index, SQL Index Types, SQL Index Best Practices

An index in a SQL database is similar to the index, or table of contents, in a book. The index in a book helps to quickly search for a particular topic instead of flipping through all the pages of the book. Likewise, when a database has large volume of data, then retrieving particular data from the database consumes more time and thus it becomes a performance issue. Creating indexes on the columns that are frequently accessed can be a good solution to retrieve the data quickly.

By Admin