Blog Posts

The CHECK constraints enforce integrity by limiting the values that are accepted by one or more columns. You can create a CHECK constraint with any logical expression that returns...

2016-06-13

10 reads

SQL Community n Speaking Assignments

by Nagaraj Venkatesan

SQL and SQL Only

Dear All,

It has been a while since I became less active on this blog. Reason for the same being that,...

2016-06-12

404 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para sql

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...

2016-06-11

408 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para 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...

2016-06-11

20 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para sql

The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...

2016-06-11

648 reads

The COUNT function in T-SQL

by Igor Micev

Si vis pacem, para 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...

2016-06-11

15 reads

Database Scoped Configurations

by Niko Neugebauer

Niko's blog

In SQL Server 2016, one of the key management improvement is a new feature that is called Database Scoped Configurations.

This...

2016-06-10

2,089 reads

How To Get A Free SQL Server Indexing Book – Week 2

by StrateSQL

StrateSQL

Free Book! Another free indexing books, more awesome! In last week’s post, I talked about how I’ve got a number of copies of Expert Performance Indexing for SQL Server;...

2016-06-10

12 reads