Data Compression in SQL Server 2005 (Believe it !!)
That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.
2008-03-18
4,114 reads
Articles
Fire Drills
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-18
26 reads
Fire Drills
How often do you have those fire drills, testing what you would do in the event of an emergency. Would you be satisfied with a 30% success rate?
2008-03-18
32 reads
Screencast: Tracking memory with PerfMon counters
Learn how to use SQL Server PerfMon counters to track Windows memory. SQL Server MVP Kevin Kline explains the maximum numbers to watch for when using PerfMon memory counters.
2008-03-18
2,894 reads
The curse and blessings of dynamic SQL
How you use dynamic SQL, when you should - and when you should not.
2008-03-18
6,537 reads
2008-03-17
7,697 reads
Understanding DDL Triggers in SQL Server 2005
SQL Server 2005 includes a number of new security enhancements to aid the DBA in managing their SQL Server. DDL triggers allow you to trap all kinds of DDL events that occur on your server. S. Srivathsani brings us a look at these new events.
2008-03-17 (first published: 2007-07-04)
15,796 reads
Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-17
32 reads
Get Rid of the Indexes
An idea that could save time and resources for backup and recovery in SQL Server.
2008-03-17
29 reads
SQL Server 2005 Express Edition - Part 17 - Merge Web Synchronization
In this article, we will explore another variation of this mechanism, called Web Synchronization, with SQL Server 2005 Express Edition instances operating as merge replication subscribers connecting to a publisher via HTTPS protocol.
2008-03-17
998 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers