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)
815 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)
776 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)
540 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)
4,450 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)
690 reads
2016-07-05 (first published: 2016-05-26)
716 reads
2016-07-01 (first published: 2016-05-24)
586 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)
742 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
965 reads
Blogs
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
What's New in SQL 2019? at BRSSUG
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Forums
Identity column as Primary Key - good or bad?
I'm building a web app to maintain some data, which is mostly flat but...
Need of database
In order to structure and layout 50GB of data which includes pdf files, videos,...
list to table, versus delimitedsplit8k
Dear reader The list to table is build around a while loop, one item...
Ask SSC