SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Terry's Business Intelligence

Terry is a BI Developer in London, focusing on DataWarehouse design and Reporting using SQL Server SSIS/SSAS/SSRS.

Archives: June 2013

Client Pressures and Code Quality

In my experience, code quality always trumps urgency because when code has been released that has questionable quality, it is inevitable that bugs appear and the project takes longer than it should. In my case, because the code belongs to a 3rd Party vendor, this frustrates the developer, business users…

Read more

0 comments, 420 reads

Posted in Terry's Business Intelligence on 9 June 2013

SQL Query Result Order

Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is not guaranteed. SQL Server decides which is the best order to return the query. This is based on factors like whether indexes are used or data fragmentation on the physical…

Read more

1 comments, 623 reads

Posted in Terry's Business Intelligence on 5 June 2013

SQL Logical Query Processing Order

This probably applies more to beginners or people who have been using SQL for a while but have been wondering why sometimes the query works in a certain way and sometimes it didn’t. Before I read the book for the exam 70-461, I found it relatively easy to just plonk…

Read more

2 comments, 477 reads

Posted in Terry's Business Intelligence on 3 June 2013