In this tip we have a very simple data flow using a source query with a predictable duration. The data flow takes longer to process all the rows and even larger buffers didn't make the problem go away. What can be the cause of this and how do we solve this? Koen Verbeeck explains.
2014-05-08
4,049 reads
Robert Sheldon answers 12 questions about XML, including situations you would want to use XML, and how to do basic tasks.
2014-05-07
8,085 reads
Most DBAs, myself included, install SQL Server with the default server collation SQL_Latin1_General_CP1_CI_AS and all of our table columns get created using this default setting. This tip will look at the performance impacts of querying data with this setting as it compares to querying columns with the collation set to SQL_Latin1_General_CP1_CS_AS.
2014-05-06
4,752 reads
Kathi Kellenberger describes the basics of SSRS before showing you how to build quick, simple reports.
2014-05-05
3,936 reads
You may have cases where an ancient application is using an old login or the wrong password. SQL Server is great about auditing failed logins and recording that they happened; it is not so great, however, at providing enough information to locate them. Aaron Bertrand offers some help.
2014-05-02
3,423 reads
Sometimes, you just want to do a search in a SQL Server database as if you were using a search engine like Google. Besides the obvious Full-Text search, Phil Factor describes some of the techniques for finding that pesky data that resists the normal SELECT blandishments.
2014-05-01
8,755 reads
This article outlines the pros and cons associated with the different methods for moving SQL Server databases to new storage within a 15 minute timeframe.
2014-04-30
3,013 reads
Test-driven development is often taught using simple examples, such as calculating the scores for a game of ten-pin bowling. Using the same practice effectively on a real code base isn’t as easy. This article covers some of the questions that arise when dealing with larger code bases and changing requirements.
2014-04-29
5,710 reads
This article outlines how to measure resource usage, and use these measurements to develop quality metrics for Big Data applications.
2014-04-28
4,186 reads
Michael Sorens aims to make PowerShell a bit easier to get going with by providing a series of collections of general-purpose one-liners to cover most of what you'll need to get useful scripting done.
2014-04-25
6,795 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