2009-02-20
3,426 reads
2009-02-20
3,426 reads
2009-02-05
4,436 reads
Don Schlichting compares and contrasts the various SQL Server 2008 Data Types. In addition, he explores which Data Types are the best solutions for specific situations.
2008-12-10
4,663 reads
This article describes how to work with large objects in SQL Server using the MAX Specifier
2008-11-05
2,455 reads
2008-10-02
3,547 reads
Our initial reason for looking at the money data type can be found within the Precision Considerations for Analysis Services Users white paper. In this white paper, we provide extensive examples of the types of precision issues when your SQL relational data source and your Microsoft® SQL Server® Analysis Services cube have different non-matching data types (e.g., if you query one way you get the value 304253.3251, but run the query in another way and you get the value 304253.325100001).
2008-10-02
2,761 reads
2008-05-29
3,927 reads
This is the third articlefrom Dinesh Asanka in the series on the new Data Types in SQL Server 2008. In this article the spatial data types are explored.
2008-02-22
3,730 reads
In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.
2008-02-20
4,301 reads
To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.
2007-12-26
3,745 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get...
Hi I have a clustered MS SQL server setup (2016, Enterprise, on AWS instance)...
We backup over the weekend our full backups to a backup server with a...
I updated my visual studio 2019 professional recently, and when I try to double...