SQL Server Nation
For all of your SQL Server needs.

BrandonGalderisi

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 environments quickly easily while providing the horsepower to mimic near physical environment capacity. I will leave the discussions over physical vs. virtual to discuss in another area, I will just talk about my recent experience, and how handling...

  • 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() has it's uses, using it to filter results is not necessarily one of them. There are several scenarios in which this is useful. Before setting up the test data and reviewing the results, I will explain a few scenarios that I have seen. Scenario...

  • 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 SQL Server does NOT have a name. It is not named the default instance, it just is the default instance. The default instance is accessed by entering in the machine name into the connection. Named instances are named and must be accessed with the instance...
    Filed under: ,

  • 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 error. Msg 1033, Level 15, State 1, Procedure vw_CF7D3A8E67D749B38ED6E6F579AB6FF3_3, Line 4 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified...
Copyright SQL Server Nation 2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems