Getting TEXT, NTEXT and IMAGE columns in Database
As per Microsoft documentation these types will be removed from future version
2017-06-02 (first published: 2017-05-31)
2,715 reads
Converting values into Rows
Script describe one of the way to divide values into rows by using any specified dividing value.
2016-11-15 (first published: 2016-11-04)
823 reads
Getting top ranked employee detail for each department
Using OVER clause with ROW_NUMBER() function to get top ranked employee detail as per each department.
2016-10-25 (first published: 2016-10-03)
750 reads
SQLCMD to export data in txt file
SQLCMD is one of many methods to export your database data to some text file
2016-10-12 (first published: 2016-09-27)
21,161 reads
Handling with currently running and blocking sessions
Checks currently running sessions and blocking queries with session information
2016-10-05 (first published: 2016-09-16)
783 reads
2016-07-05 (first published: 2016-05-26)
4,324 reads
2016-07-01 (first published: 2016-05-24)
635 reads
Getting LEAD and LAG values manually
LEAD and LAG functions are new in SQL Server 2012 , This short Script could be used to get these values in Earlier versions also
2016-06-28 (first published: 2016-05-18)
780 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
1,040 reads
Blogs
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
SQL Saturday Oregon & SW Washington 2024
By DataOnWheels
Wow I am so late in posting these notes! But this conference was amazing,...
Challenges Enterprises Face When Adopting AI
The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.
Forums
Sparse Column Storage
Comments posted to this topic are about the item Sparse Column Storage
The Managed Cloud Database Options
Comments posted to this topic are about the item The Managed Cloud Database Options
Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases
Comments posted to this topic are about the item Stairway to Snowflake Level 6...
Question of the Day
Sparse Column Storage
When does a column declared as SPARSE use no storage?
See possible answers