Who Wants to Be Rich?
With all the concern over the economy lately, Steve Jones talks about about finances and tries to bring perspective to those of us in the real world.
2008-10-18
66 reads
Articles
SQL Server 2000 Useful Undocumented Stored Procedures
In this article, Alexander Chigrik looks at some useful undocumented stored procedures that shipped with SQL Server 2000.
2008-10-17 (first published: 2001-10-08)
30,227 reads
Who was that Affinity Masked Man?
Getting the number of processor cores that SQL Server is using is not as straitforward as it could be. Enter the affinity mask, bitwise operations and good old fashioned computer science.
2008-10-17
4,028 reads
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-17
516 reads
Enough - Database Weekly (Oct. 20, 2008)
The loss of data is getting ridiculous. Steve Jones wants companies and government to do something about it.
2008-10-17
782 reads
Introduction to New Data Warehouse Scalability Features in SQL Server 2008
This paper introduces the new performance and manageability features for data warehousing across all these components. All these features contribute to improved scalability.
2008-10-17
2,632 reads
Setting up a Two-NODE SQL Server 2008 Cluster from the Command Prompt - Integrated Installation
Part 1 of this series discussed how to prepare for SQL Server cluster installation on a two-node Windows Server 2003 cluster. This installment explains how to install SQL Server Database Engine on the cluster using the Integrated Installation option.
2008-10-17
2,079 reads
2008-10-17
4,719 reads
Row Count Transform - SQL School Video
Integration Services contains a tremendous number of ways to transform and work with data. MVP Brian Knight dives into the Row Count transform in this edition of SQL School. This shows how you can monitor the number of rows in a transform.
2008-10-16
3,460 reads
Scaling The Data Warehouse
Data warehouses aren't just exploding in size, they're also supporting more users and increasingly complex queries, all in shorter time frames. Here's how to make sure yours is ready to scale.
2008-10-16
2,707 reads
Blogs
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
Three Ways to Use Snowflake Data in Microsoft Fabric
By James Serra
Organizations increasingly want Snowflake and Microsoft Fabric to coexist without duplicating data or fragmenting...
Forums
You Have Homework
Comments posted to this topic are about the item You Have Homework
SSIS 2019 or 2022 - Microsoft Connector for Oracle
Hello all, I am having one heck of a time installing Microsoft Connector for...
bringing a .bak across the wire without rdp'ing or mapping into the sql server
hi, a peer of mine would like to be self sufficient in bringing small...
Question of the Day
The Query Optimizer and Page Density
If I have a fillfactor set to 70%, this reduces my page density to roughly 70%. Does this affect the query plans that the optimizer chooses?
See possible answers