SQL Server Nation
For all of your SQL Server needs.
BrandonGalderisi » All Tags » Beginner SQL (RSS)

Browse by Tags

  • 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: ,
Copyright SQL Server Nation 2010
Powered by Community Server (Non-Commercial Edition), by Telligent Systems