Tin Pan Alley BBS > Home ( DNN 3.3.5 )

Do sub query expressions introduce a performance penalty on retrieving large data sets?

7/29/2010 9:35:19 PM

For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin

In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...

7/29/2010 9:35:19 PM

When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.

7/29/2010 9:35:19 PM

Calendar Tables

Learn how to avoid complex date calculations and increase performance using calendar tables in this article from Todd Fifield.

7/29/2010 9:35:19 PM

Extending Hierarchical Data Modeling Demonstrated in SQL

The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.

7/29/2010 9:35:19 PM

Raw Materials - Surface Area

Some surfaces are easy to overlook.

7/29/2010 9:35:19 PM

SQL CLR Data Types and Performance

Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.

7/29/2010 9:35:19 PM

Gathering Perfmon Data with Powershell

Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.

7/29/2010 9:35:19 PM

Top Ten Reasons to Attend the 2010 PASS Community Summit

There are some good reasons to think about attending the 2010 PASS Community Summit.

7/29/2010 9:35:19 PM

Configuring Alerts for Policy-Based Management

How can I receive notifications when the policies I have implemented have been violated so I don't have to manually look at each server?

7/29/2010 9:35:19 PM