When should you use a SQL CLR Aggregate? Lots of people have struggled with this one, but David Poole found a use, and has some interesting performance data analysis as well.
2014-02-05 (first published: 2010-12-29)
17,508 reads
The idea is to create a SQLCLR table valued function that returns all information on drives in a UNIX df-like style.
2010-09-21
9,870 reads
Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.
2010-07-21
8,067 reads
How is it possible to pass multiple parameters to a SQL Server 2005 CLR aggregate?
2010-07-06
2,370 reads
When looking for impending problems due to lack of disk space it's necessary to know how much space is available on each drive. There have been other tips written about how to do this, but in this tip I show you a way this can be done using SQLCLR.
2010-04-27
3,390 reads
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
13,441 reads
The inclusion of the CLR in SQL Server has been controversial, but some people have come up with great ways to take advantage of this feature. New author Anders Pedersen brings us a technique to export data from SQL Server into Excel using the CLR.
2009-12-02
21,664 reads
Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.
2011-05-06 (first published: 2009-03-03)
19,790 reads
If a column is normalized, but the user really wants to see the values as a short comma separated list, how can I write a query that produces the list? Concatenating the values in a column would be pretty easy if SQL Server had a concatenate aggregate function, which it doesn't. What's more, for efficiency sake it's important to write the reporting queries without using cursors.
2009-02-09
2,240 reads
Learn how to use SQLCLR to get file system information instead of using xp_cmdshell on your SQL Servers.
2013-11-22 (first published: 2009-02-05)
34,906 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 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