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)
1,589 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)
799 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)
646 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)
11,955 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)
710 reads
2016-07-05 (first published: 2016-05-26)
766 reads
2016-07-01 (first published: 2016-05-24)
592 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)
759 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
981 reads
Blogs
Built-in Duotone Image Filter, Editor Navigation via Persistent List View, and Other Block Editor Improvements
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
Are You a Diverse User Group or Event?
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
Daily Coping 18 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Extensive blocking from implicit transactions
Hello folks, We had an issue with blocking last week - LOTS of blocking...
Deceptive Visualizations
Comments posted to this topic are about the item Deceptive Visualizations
Argument syntax for SSIS Execute Process Task Editor
Hi, I'm trying to modify my SSIS packages to use sftp and since it...
Ask SSC