There is much sound advice suggesting that every table should have a clustered index, and that narrow, integer, ever-increasing columns, such as afforded by an IDENTITY column are the best choice. But is the sedimentary approach really the natural order of the day?
The second part of this series compares four methods of obtaining the total number of rows in a paged data set.
Understanding how to analyze the characteristics of I/O patterns in the Microsoft® SQL Server® data management software and how they relate to a physical storage configuration is useful in determining deployment requirements for any given workload. A well-performing I/O subsystem is a critical component of any SQL Server application. I/O subsystems should be sized in the same manner as other hardware components such as memory and CPU. As workloads increase it is common to increase the number of CPUs and increase the amount of memory. Increasing disk resources is often necessary to achieve the right performance, even if there is already enough capacity to hold the data.
Just because mistakes have become entrenched in the computer languages that we use doesn't mean we have to tolerate them
The NoSQL concept has been attracting a lot of attention in recent years, primarily due to big-name production implementations.
How important is your job to you? Today's guest editorial from Andy Warren asks the question of the professionals out there, some of whom do great work, but don't care about their jobs.
This is a major Business Intelligence community event for Developers and IT professionals that focus on building real-world BI solutions using the Microsoft Business Intelligence Platform tools and technology on May 22nd 2010! May 22 in Waltham, MA
Part III of our spatial data series, continues building a demo spatial data app and uses Reports Builder for detailed visual mapping.
Recent experts in Development techniques don't seem inclined to study the history of programming; There isn't that much that's new in the art of Unit Testing database development work
Geocode, look up postal codes, and perform validation for street address information natively T-SQL
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
I have 13 restricted views in my EDW DB. 6 of them are created...
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Comments posted to this topic are about the item Would You Retire Rather Than...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers