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,834 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)
826 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)
769 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,908 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)
789 reads
2016-07-05 (first published: 2016-05-26)
4,786 reads
2016-07-01 (first published: 2016-05-24)
647 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)
782 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,044 reads
Blogs
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Connect resiliently to SQL Server
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
Forums
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...
AlwaysON health check alerts
Comments posted to this topic are about the item AlwaysON health check alerts
Bat and SQL script to generate DB user permissions for all Databases in SQL server
Comments posted to this topic are about the item Bat and SQL script to...