Performance Implications of Nullable Columns
To null or not to null: that is the question. The specific focus here is performance implications of NULL versus NOT NULL columns.
2005-11-18
5,427 reads
Additional Articles
Monitor CPU Usage of All Running Processes - Part II
Part I of this article illustrated how to monitor CPU usage of running processes on a local machine or from a remote machine. This article illustrates how to monitor the CPU usage of different running processes on different machines and collect the information in a database.
2005-11-17
4,538 reads
SQL Server 2005 Learning Guide
It's been five years since Microsoft released a new DBMS, but both experts and users agree that this one was worth the wait. SQL Server 2005's enhancements and new features have made the system a much more attractive attractive option to both large and small shops. Nonetheless, upgrading to SQL Server 2005 is a serious undertaking, requiring extensive training, planning and testing. In this Learning Guide, you will find news, technical tips and expert advice to help address your questions and concerns regarding SQL Server 2005 and put you on the road to a successful upgrade.
2005-11-16
5,506 reads
Dynamic Management Views
The dynamic management views (DMVs) in SQL Server 2005 are designed to give you a window into what's going on inside SQL Server. They can provide information on what's currently happening inside the server as well as the objects it's storing. They are designed to be used instead of system tables and the various functions provided in SQL Server 2000. This article provides an introduction to DMVs and covers a few of the basic views and functions.
2005-11-15
2,315 reads
Data Rich, Information Poor?
Data, information, and knowledge. They're all different concepts and we sometimes lose sight of the fact that there are differences. This is a good look at the difference.
2005-11-14
2,393 reads
MDX Essentials : Set Functions: The DRILLDOWNMEMBER() Function
In this article, we will begin an extended examination of the MDX surrounding drilling up and down within our Analysis Services cubes. Comprising an analytical technique by which an information consumer can maneuver between summarized ("drilling up") and detailed ("drilling down") levels of data, drilling up or down occurs along the lines of drilling paths that are defined within the physical structures of our cubes. Often specified by the cube's dimensional hierarchies, these paths can also be based upon alternative relationships that exist within or between dimensions.
2005-11-11
2,036 reads
Bogus Resumes and Unblushing Lies
Simple Talk's newest commentator, Phil Factor, reveals the dark side of hiring database specialists: "Soon after he had been shown his desk in our crowded, open-plan IT office, he began laughing out loud, sporadically and inappropriately, while reviewing code. It wasn't my code, so I didn't mind."
2005-11-10
4,525 reads
Configuring the Pivot Component
Sometimes coincidences happen that make you sit back and say Hmm. Couple of days back Ovidiu, one of our senior developers, came by and asked me to blog about the Pivot transform. Then earlier today someone doing a high end POC down south need the same information.
2005-11-09
2,070 reads
Where does Access fit in Microsoft’s future?
Where does Access fit in Microsoft’s future? Before that question is answered, we should examine why it might be important.
2005-11-08
5,350 reads
Review of AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1
Now it's time to review yet another migration related product from AdventNet. It is called "AdventNet SwisSQL Sybase to SQL Server Migration Tool 2.1". As the name suggests, this migration product automates the conversion of Sybase ASE (Adaptive Server Enterprise) T-SQL stored procedures, inbuilt functions, triggers, tables, views, and other database objects to Microsoft SQL Server T-SQL.
2005-11-04
1,103 reads
Blogs
I recommend Smart Brevity (book) for communications
By Brian Kelley
Following the advice in Smart Brevity improves communication.
SQL Server 2025 Developer Edition – One size fits all
By John
Microsoft has released SQL Server 2025, bringing big improvements to its main database engine....
Monday Monitor Tips: Learning While Using the Tool
By Steve Jones
A customer was asking about what certain items in Redgate Monitor mean. They have...
Forums
Switch partition: NULL boundary id
I have table: t1 in schema1 with 19 billion records. I have another table...
Minimally Viable Security
Comments posted to this topic are about the item Minimally Viable Security
Encoding NULL
Comments posted to this topic are about the item Encoding NULL
Question of the Day
Encoding NULL
What is returned from this code in SQL Server 2025?
SELECT BASE64_ENCODE(NULL)See possible answers