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,829 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)
767 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,849 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,745 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)
781 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,042 reads
Blogs
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Secure Your SQL Estate: Best Practices for Azure SQL Security
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Forums
What makes Monkey type's typing club apart from others?
Monkeytype Typing Club is a unique typing practice website that offers several features that...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Concerns over AI Chat Privacy
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers