2022-04-27
398 reads
Data Compression
Estimating Data Compression Savings in SQL Server
This video demonstrates a set of queries for estimating data compression savings in SQL Server. It also covers how to make an informed decision on whether data compression makes sense for your data and workload or not.
2021-10-08
2021-09-10
500 reads
2021-09-03
487 reads
2020-11-24
505 reads
2019-03-25
190 reads
2017-11-13
940 reads
Data Compression and Snapshot Isolation
Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit
2014-10-02
3,663 reads
Demonstrating the Effects of Using Data Compression in SQL Server
How much space would compressing a particular index will save? How will this affect query performance? Derek Colley walks you through the effects of using data compression in SQL Server.
2014-03-25
4,651 reads
2013-01-30
2,194 reads
Blogs
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers