Contact Us

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “5” not found /] Course Description We provide students with the tools and techniques to write code for a broad range of requirements in SQL Server, all while optimizing performance. Students will analyze case studies, comparing several approaches for each one and choosing the best solution. The course is based on SQL Server 2012, but it is also relevant for other version

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “5” not found /] Course Description We provide students with the tools and techniques to write code for a broad range of requirements in SQL Server, all while optimizing performance. Students will analyze case studies, comparing several approaches for each one and choosing the best solution. The course is based on SQL Server 2012, but it is also relevant for other version

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course Description We provide students with the tools and techniques to write code for a broad range of requirements in SQL Server, all while optimizing performance. Students will analyze case studies, comparing several approaches for each one and choosing the best solution. The course based on SQL Server 2012, but it is also relevant for other versions.

The Advanced Programming in SQL Server course takes your programming in SQL Server to a new level. [table “1” not found /] Course Description We provide students with the tools and techniques to write code for a broad range of requirements in SQL Server, all while optimizing performance. Students will analyze case studies, comparing several approaches for each one and choosing the best solution. The course based on SQL Server 2012, but it is also relevant for other versions.

After my last post about monitoring deadlocks, I will now show a way to prevent deadlocks and unnecessary locks and to improve system performance. Introduction SQL Server has a lot of working mechanisms. The lock mechanism is one of the most important mechanisms. Its goal is to keep and secure the data reliability and consistency. This mechanism is very complex and depends on many variables. The mechanism is designed to let the system work in an optimal way. It is based on th

Sometimes we want to populate a table with random data, mainly for testing purposes. For example, let’s consider the following table: Transact-SQL CREATE TABLE Sales.Orders ( Id INT NOT NULL IDENTITY(1,1) , CustomerId INT NOT NULL , DateAndTime DATETIME2(0) NOT NULL , OrderStatus NVARCHAR(50) NULL ); GO 1 2 3 4 5 6 7 8 9 CREATE TABLE Sales.Orders ( Id INT NOT NULL IDENTITY(1,1) , CustomerId INT NOT NULL ,

Last month, in the SQL Server Users Group meeting, I presented a session called “Things You didn’t Know about SQL Server”. The first “thing” I presented was the result of casting (and truncating) a long integer value into a short VARCHAR type. The result is “*” (asterisk). For example, the result of the following batch is “*”: Transact-SQL DECLARE @Text AS VARCHAR(5) = 123456; SELECT @Text; GO 1 2 3 4 5 DECLARE @Text AS VARCHAR(5) = 123456; SELECT @Text; GO In the

I encounter too many databases in which numeric columns are defined as REAL or FLOAT. These data types are approximate, meaning they can only represent values approximately. They are meant to represent very large or very small numbers, and they should be used in databases where a very wide range of values should be expressed, such as scientific systems. In most cases, when we need to represent numbers, we actually need exact numbers, such as 15.873 or 98.2. Such numbers can r