Interacting with SQL Server from .NET is a radical change from the old OLEDB/ODBC method. Raj Vasant brings us some easy ways to work with parameters passed in with the ADO SQLCommand.
2007-11-09 (first published: 2006-03-22)
24,529 reads
This article discusses prioritizing code by age, using analysis tools and automation, looking at threats from multiple angles, and the importance of education
2007-11-09
1,458 reads
Find out how to update and tune table statistics in SQL Server to ensure data accuracy and boost performance. Learn auto and manual update commands.
2007-11-09
4,503 reads
ETL processing, generally involves copying/moving, transforming, cleaning the records/transactions from one or multiple sources. Most of the batch processing or warehousing projects involve such data processing in millions on daily/weekly basis. Typically, there is a Staging area and production area. Records are cleaned, transformed, filtered and verified from staging to production area. This demands SQL Set theory based queries, parallel processing with multiple processors/CPU. The article focuses on need of SQL Set theory approach and parallel processing while processing large volume of ETL records using programming approach.
2007-11-08
7,095 reads
Importing text files is a common task for DBA's and Developers, but what happens when the text file is not properly formatted?
2007-11-08
4,463 reads
After a gap of sixteen months, Lionel Clarke, the creator of the only 3-D maze game to be written in TSQL, returns with a new SQL puzzle. It is very simple. You have to move as much of the data as you can from the source tables to the destination tables.
2007-11-08
2,661 reads
SQL Server 2008's new MERGE statement allows you to insert, update, or delete data based on certain join conditions in the same statement.
2007-11-08
2,632 reads
With the tenth installment of his series on XML, Jacob Sebastian turns his attention to the art of namespaces and how you can avoid ambiguity in interpreting various elements.
2007-11-07
5,806 reads
Find pointers to optimize tempdb performance in SQL Server by striping and splitting across multiple files in SQL Server 2005.
2007-11-07
3,737 reads
SQL Server 2005 offers T-SQL language features that can improve your productivity.
2007-11-07
4,752 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