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,975 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,600 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
Access to SQL Server: Linking Tables
SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to
2006-11-17 (first published: 2005-02-23)
45,569 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,625 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,974 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
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I