• Home
  • Blog
  • About
  • Contact

"platform to share ideas and knowledge about SQL"

Data compression overview in SQL Server 2008

SQL Basic Raj Leave a Comment

I found the Data compression feature in SQL Server 2008 is very handy. This definitely helps in optimizing query performance in terms of I/O cost and additionally it helps in…

Read more »

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Categories

  • Data warehouse
  • How to topics
  • Index
  • Partition
  • Performance & Troubleshooting
  • quick bite
  • SQL Basic
  • SSIS

Topics

Compression Data warehouse Date DBCC DMV Error Handling Fact How to topics Identity Index JOIN OUTPUT Query Performance ROLLBACK SELECT SQL Server misc SSIS Table Table Partition Table Value Transaction TRUNCATE

Contact Us

  • Email
    contact@intellectSQL.com

Recent Posts

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

Site Links

  • About
  • Blog
  • Contact
  • Home
  • Privacy Policy

Contact

  • Email
    contact@intellectSQL.com

RSS blog – feed

  • Factless fact table
  • How to delete duplicate rows from a table in SQL
  • Impact of using local variable in Stored Procedure
  • Additive, non-additive and semi additive facts in data warehouse fact table
  • DROP multiple tables using a single DROP statement

About intellectSQL

intellectSQL is a platform to share ideas and knowledge about SQL, Data engineering, warehouse and more …

© 2025 intellectSQL
  • Home
  • Blog
  • About
  • Contact