Often times we need to review the SQL Server instance configuration values while troubleshooting performance problems. What alternatives are available to capture this information? With all of the new views in SQL Server 2005, is one available with the configuration values, a description and the list of possible values?
2008-08-05
3,958 reads
2008-08-05
72 reads
2008-08-05
72 reads
2008-08-05
60 reads
Virtual database storage in SQL Server comes with flexibility of tiered storage and block storage. Get the pros and cons of virtual storage area networks.
2008-08-05
2,581 reads
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
2008-08-04
6,375 reads
When repeated SQL Server login failures occur, a DBA should investigate. It could just be someone repeatedly typing in the wrong password. Worst case is a virus attack flooding your network with connection requests. Receiving an e-mail while login failures are occurring allows DBAs to investigate and fix the issue as soon as possible. So how is DBA notified of login failures without flooding their inbox?
2008-08-04
6,362 reads
SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.
2008-08-04
3,369 reads
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
2008-08-04
75 reads
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
2008-08-04
67 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