(Derek E Wilson) Both T-SQL EXCEPT and INTERSECT are set based operators that combine multiple query results back in the same result set. EXCEPT returns the records from the query on the left that are not found in the right query. INTERSECT returns the distinct rows that are in both the right and

(Chris Webb) The most elegant way of modelling your SSAS cube doesn’t always give you the best query performance. Here’s a trick I used recently to improve the performance of a many-to-many relationship going through a large fact dimension and large intermediate measure group…

(Dattatrey Sindol) I have read the previous tips in the Getting Started with HDInsight series and I am eager to jump into the action and learn more about HDInsight. I would like to know what the prerequisites for creating a cluster are, how you create a cluster and the other aspects related to creat

(Thomas LeBlanc) Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder t

(Pinal Dave) A leap year has 366 days. A leap year has 29 days for February month. Suppose you want to find if year is Leap year or not, you can use many methods.

(regbac) I’ve written a few blog posts about Continuous Integration and database development using Visual Studio 2013 and Team Foundation Server.

(Ed Elliott) In the second part of this series on getting more agile and bringing our Sql Server development practices up to date I am going to talk about why you should get your database under source control.

(John Pertell) This is the third in a series of posts on administering SQL Server Report Services. In Part 1 we went over the basic installation of SSRS for native mode. Part 2 went over the components that were installed.

(Larry Leonard) If a database is using the FULL Recovery Model, it obviously needs to be doing log backups – otherwise the log will eventually fill the disk (your “eventually” may vary). If you don’t need log backups, change the database to SIMPLE Recovery Model and sleep easier at night.

(Joe Celko) A database must be able to maintain and enforce the business rules and relationships in data in order to maintain the data model. It does this through referential constraints. They aren’t complex, but are powerful, especially with the means to attach DRI actions to them.