The HierarchyID Datatype in SQL Server 2008
This article examines one of the T-SQL changes coming in SQL Server 2008: The hierarchyID.
2008-03-25
21,098 reads
Articles
Views and Horizontal Partitioning
Jambu Krishnamurthy brings us a look at the various options you have available with views and some of the techniques you can use to build a better database by incorporating them in your design.
2008-03-25 (first published: 2007-04-12)
9,937 reads
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
38 reads
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
40 reads
Bad Automation
Coming up with ways to do things automatically with software can be a boon to productivity, but not every idea is a good one.
2008-03-25
31 reads
Column-Store Databases and DW Appliances
With data volumes exploding, conventional enterprise data warehouses are fast running out of headroom. Data warehouse appliances are starting to fill the gap, but the emerging category of column-oriented databases may offer a better option. The key to success is matching your application to the right product.
2008-03-25
2,032 reads
Dynamic Search Conditions
ow to write a stored procedure that permits users to select among many search conditions, using both dynamic and static SQL.
2008-03-25
3,820 reads
2007 Tech Salary Survey Results
Dice.com recently completed a salary survey for 2007. If you didn't participate, Steve Jones summarizes the results for DBAs.
2008-03-24 (first published: 2007-04-03)
10,150 reads
Name value pair (EAV) model
Entity-Attribute-Value model (EAV) is used interchangeably with name for name value pair. This article will try to address advantages and disadvantages of EAV modelling
2008-03-24
7,232 reads
Ready Made Code Snippet Tool Box Courtesy of SCOM
Cracking open the default management packs in SCOM unlock a vast code library for custom automation and monitoring of SQL Server instances.
2008-03-24
7,173 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers