Table Variables
New author Jambu Krishnamurthy brings us a look at table variables and how they differ from temporary tables in SQL Server 2000.
2006-11-21
16,949 reads
Articles
MDX Numeric Functions: The .Ordinal Function
In this lesson, we will expose another useful function in the MDX toolset, the .Ordinal function. The general purpose of the .Ordinal function is to return the ordinal value of a specified dimensional level.
2006-11-21
2,460 reads
A Transactional Replication Primer
Setting up replication can be fairly easy, but deviating from the follow-the-wizard approach can be tricky. New author Claudia Rego brings us a primer on setting up transactional replication without requiring an initial snapshot.
2006-11-20
8,587 reads
Data partitioning in SQL Server 2005 - Part III
Part III of the article series illustrates how to partition an existing table with data into four different file groups.
2006-11-20
3,077 reads
SQL 2005 Web Synchronization for Merge Replication
Web synchronization in SQL 2005 enables highly secure synchronization of your merge subscriptions. This feature has been in high demand for many years, and Microsoft has finally delivered. This feature is difficult to deploy, however, so Hilary Cotter provides a tutorial on how to set up this complex feature.
2006-11-17
2,451 reads
Moving Your Database to a New Server
As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.
2006-11-16
15,612 reads
Compress Binary Messages Using SQL
Data compression is a great method for maximizing data storage space and making data communication faster. However, compression and decompression of binary data sometimes can be quite tricky. Learn a few useful data-compression techniques.
2006-11-16
1,945 reads
Unit Testing With Visual Studio
Testing is an important part of programming and it is no different with SQL Server development. Longtime author Grant Fritchey brings us a look at the new testing features available in Visual Studio 2005.
2006-11-15
9,949 reads
E-Mail Functionality in SQL Server 2005
Sending an e-mail has become very important in any system for purposes such as sending notifications. SQL Server database has an integrated mailing system. With the arrival of SQL Server 2005, users now have the new functionality of Database Mail, which is different from SQL Server 2000 SQL Mail. The purpose of this article is to introduce Database Mail and highlight the advantages of using it over legacy SQL Mail.
2006-11-15
3,424 reads
A Special Announcement from Andy, Brian, and Steve
It's been five and a half years since SQLServerCentral.com was founded by Andy, Brian, and Steve. We've greatly enjoyed the time and we're looking forward to many more, but a major announcement today changing the way we will operate in the future.
2006-11-14
11,853 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers