Exporting data to CSV file using SQLCMD/BCP
When it comes to exporting data there are different options available in SQL Server, such as SQL Server Integration Services,...
2012-03-27
4,850 reads
Inserting UniCode / Special characters in tables
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,921 reads
Off to Vegas for DevConnections
A few last minute prep items for DevConnections and I leave in a few hours for Las Vegas. My first...
2012-03-26
1,032 reads
SQL server 2005 Database Mail stopped functioning after installing Service Pack 3
Recently I have upgraded one of our SQL server 2005 instance to Service Pack 3 and later point of time...
2012-03-26
1,268 reads
SQL Server Parallel Data Warehouse (PDW) Appliance Update 3 (AU3)
In the next few weeks there will be an update to the SQL Server Parallel Data Warehouse (PDW) called “Appliance Update 3?...
2012-03-26
2,059 reads
SQL SERVER Replication – Troubleshooting Steps for Beginners
Few days back there was a replication issue in one of the QA servers. Since the DBA was out of...
2012-04-03 (first published: 2012-03-26)
5,447 reads
Backup script skipping databases – and the fix!
A real head-scratcher
I’ve been using my RYO Maintenance scripts for a little while now, and they’ve been working great. Almost....
2012-04-02 (first published: 2012-03-26)
1,959 reads
Stress Thoughts–Part 1
If I had to tell you that one thing I’ve gotten better at in the past 5 years it would...
2012-03-26
726 reads
Execution Plan for a User Defined Function
When you execute a multi-statement user-defined function you may see an execution plan that looks something like this:
It appears as...
2012-03-30 (first published: 2012-03-26)
8,349 reads
SQLSAT107
I was recently selected to speak at SQL Saturday 107 in Houston TX. I am really excited to be selected...
2012-03-26
550 reads
Blogs
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers