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,200 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)
784 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)
589 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)
7,665 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)
699 reads
2016-07-05 (first published: 2016-05-26)
722 reads
2016-07-01 (first published: 2016-05-24)
587 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)
751 reads
Table Comparison Procedure
Procedure to compare two tables , getting table names and rows to display
2016-06-07 (first published: 2016-05-06)
973 reads
Blogs
Daily Coping 29 May 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Custom Quarantine PoSh Prompt
By Steve Jones
Since I’ve been quarantined at home and working in my office, every day is...
TIL: Get-DbaErrorLog
By Kevin3NF
Ed: SQLDork is a Junior DBA on the team here, learning the DBATools in...
Forums
Daily Coping 29 May 2020
Today’s tip is today link your decisions and choices to your purpose in life....
Week Ending Thursday, can some one tweek my code?
What I have missed from this code? I'm trying to show the DateTimeRaised field...
The Matchbox Database
Comments posted to this topic are about the item The Matchbox Database, which is...
Ask SSC