This function is used to returns distinct values that are returned by both the query on the left and right...

2014-08-11

1,093 reads

Exception handling in SQL Server

by Vivek Johari

Vivek's SQL Notes

SQL server gives the exception/error handling mechanism which is similar to c#, Try..Catch block. In SQL Server, we can write...

2014-08-19 (first published: 2014-08-11)

10,257 reads

The Real Reason You Should Be a Proactive DBA

by Matan_Yungman

Matan Yungman

If you’re reading this, you probably think, like me, that SQL Server is an awesome product. One of the great...

2014-08-11

1,399 reads

SQLSaturday Baton Rouge Business Intelligence and Recap - 1 of 2

by Will Assaf

SQL Tact

(This is the first part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Been quiet on this blog...

2014-08-10

753 reads

SQLSaturday Baton Rouge Business Intelligence and Recap - 2 of 2

by Will Assaf

SQL Tact

(This is the second part of a two-part post on a SQLSaturday Baton Rouge 2014 recap.)
Out of a total of...

2014-08-10

576 reads

Clustered Columnstore Indexes – part 37 (“Deleted Bitmap & Delta-Store Sizes”)

by Niko Neugebauer

Niko's blog

Continuation from the previous 36 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Since the very first CTP beta, I have been asking for some...

2014-08-10

188 reads

My articles published on SSWUG.org from March 2014 to July 2014

by Basit Aalishan Masood-Al-Farooq

Basit's SQL Server Tips

The following is the list of my articles published on SSWUG.org from March 2014 to July 2014. To read these articles, you must have SSWUG.org standard-level membership. SQL Server...

2014-08-08

19 reads