SQL Server 2008 has introduced a new way to store data for columns that contain excessive NULL values called Sparse Columns. What this means is that when you declare a column as Sparse and any time a NULL value is entered in the column it will not use any space. Is there a way to identify what columns would make a good candidate for this without having to analyze each column individually?
Virtualizing SQL Server has pros and cons. Learn the performance impacts of virtualization on SQL Server I/O, RAM and memory to decide if it is a fit for your SQL Server system.
Looking for free SQL Server training?
Join over 250 SQL Server professionals in Tampa on January 24th, 2009 for SQL Saturday #10. Featuring 6 tracks and more than 36 SQL Server presentations, it's the biggest and best free SQL event available. Visit www.sqlsaturday.com to see event details and to register.
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
Tagging has become a new hot action for many people on the Internet, especially in the Web 2.0 social networking world. Steve Jones comes to a revelation about tagging and metadata.
This week Steve Jones sees a lot of people talking about challenges in their career.
This week Steve Jones sees a lot of people talking about challenges in their career.
This week Steve Jones sees a lot of people talking about challenges in their career.
This Article shows a method to audit ETL-Processes to be able to retrace processes and affected data.
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers