Why does DBCC CHECKDB find corruption errors that disappear? Does tempdb really cause performance issues? Are there any drawbacks to using the FILESTREAM datatype? Paul Randal answers these reader questions and more.
SQL Server 2008 introduces " Policy Based Management " (PBM) as a way to better manage your servers. This was a feature that I really thought had, and still has a lot of potential for making the life of a DBA easier. The tagline for PBM is "manage...
Operations Manager has stacks of reports to help you monitor your applications' uptime, but reporting can be difficult until you understand all the different options, parameters, and the structure of the Operations Manager health model. Firstly, you need a clear idea about the way that your organization defines 'uptime', and only then you can start your reports. Thomas LaRock explains...
A follow-up on Adam Aspin's series about SSRS styles. I have emailed Adam the article because he suggested it would be good to have one here after his works get published.
In this new video, learn how to loop through your databases and tables. MVP Andy Warren shows how some system stored procedures included by Microsoft can push out the same code to a group of objects.
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
Working with others can be a challenge. This Friday's poll asks for those little annoyances in the workplace and how to deal with them.
I've been slowly looking at and experimenting with LinkedIn to see if it has value and if so, how to unlock it in a way that works for me. I mentioned it during my series on networking and since I've evolved a strategy that I think is interesting...
Using VB Script allows one to script out all the Sql Server objects in independent file.
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 UNISTR Escape
Comments posted to this topic are about the item Celebrating Tomorrow
Comments posted to this topic are about the item SQL Art: I Made a...
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