BrandonGalderisi

BrandonGalderisi

Home

Syndication

Blogs

Archives

Sort by: Most Recent | Most Viewed | Most Commented

Development Environment Isolation

One of the challenges facing many development organizations is how to provide adequate development needs while providing enough isolation to prevent developer conflicts. Today's virtual technology provides the ability to spin up developer specific...

Published 17 Nov 2009 10:03 PM by BrandonGalderisi

Filed under: Intermediate SQL, Beginner SQL, Advanced SQL, Development, Virtualization
Using row_number() vs. a correlated sub-select

In this article, I will show you the differences in using the row_number() function versus a correlated sub-select for filtering data. One thing that I have seen frequently is the use of the row_number() function to limit result sets. While row_number...

Published 20 Sep 2009 11:40 PM by BrandonGalderisi

Filed under: Intermediate SQL, Beginner SQL, Advanced SQL, sub-select, row_number()
What are instances?

Any installation of SQL Server is an instance. There are two types of instances. Default instances and Named instances. Any one host computer may have many named instances of SQL Server but only one Default instance can exist. The Default instance of...

Published 27 Mar 2009 4:01 PM by BrandonGalderisi

Filed under: Instances, Beginner SQL
When ordering in a view doesn't work!

If I've seen it one time, I've seen it a hundred times. People trying to sort views by selecting 100 PERCENT in a view with an order by. Because after all, if you try to use an order by statement, without a TOP statement, you will get the following...

Published 15 Mar 2009 12:27 AM by BrandonGalderisi

Filed under: Views, User Defined Functions, Intermediate SQL, Table Valued Function, order by

BrandonGalderisi

Syndication

Recent Posts

Tags

Blogs

Archives

Development Environment Isolation

Using row_number() vs. a correlated sub-select

What are instances?

When ordering in a view doesn't work!