Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.
2007-11-14
6,185 reads
ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.
2007-11-14
1,887 reads
BI Architect Bill Pearson continues his subseries surrounding Caching Options, examining the use of Report Manager to configure Snapshot Caching.
2007-11-14
1,601 reads
From SQL Server trainer and guru Andy Warren, he are a few short nuggets that you might not realize about triggers.
2007-11-13
8,605 reads
Harness the power of SQL Server Management Objects to create, document, and manage your SQL Server databases.
2007-11-13
2,997 reads
This month's installment of "Developing a Complete SQL Server OLTP Database Project" covers MAC performance results, a summary of encryption findings, and comments on updating the SqlCredit code based on those findings.
2007-11-13
1,635 reads
This article describes how to call a web service to clean up address data from within a data flow.
2007-11-12
12,326 reads
SQLServerCentral.com is always looking for ways that we can provide you with better, more useful content to help you learn about SQL Server. We've got a new idea and we're looking for feedback.
2007-11-12
391 reads
Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_stats
2007-11-12
2,975 reads
I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary. I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass table variables (and the data in them) into stored procedures and functions.
2007-11-12
2,406 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