Tips for Minimizing Deadlocks
Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.
Checkout my article (Tips for Minimizing Deadlocks) on...
2013-05-07
906 reads
Deadlocks are caused by poor database design, inappropriate isolation level, inefficient code etc.
Checkout my article (Tips for Minimizing Deadlocks) on...
2013-05-07
906 reads
Checkout the sixth part of my XML support and SQL Server article series here.
In this part, you will learn about...
2013-05-07
552 reads
In my previous article (Different techniques to identify blocking in SQL Server) on MSSQLTips.com, I discussed about locks and blocks,...
2013-04-24
898 reads
SQL Server uses indexes to sort and organize table data. It creates indexes based on ordering values from one or...
2013-04-24
779 reads
The public role is a special fixed-database role, which exists in every SQL Server database. The public role is different from all other database-level...
2013-04-24
11,140 reads
I received an email from friend today asking how he can see when statistics were last updated in SQL Server....
2013-04-15
3,442 reads
SQL Server stores all informational messages, warning messages, and errors in operating system and application log files. As a database...
2013-04-14
917 reads
Microsoft SQL Server provides DBAs and Developers with several index related dynamic management views and functions, which they can use...
2013-04-14
828 reads
As part of our SQL Server infrastructure consolidation project, it was decided to consolidate multiple companies SQL Server 2005 / SQL...
2013-04-09 (first published: 2013-04-02)
8,473 reads
As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges...
2013-04-04
4,894 reads
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
By John
Today is Christmas and while I do not expect anybody to actual be reading...
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
Comments posted to this topic are about the item UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A:
B:
C:
See possible answers