Speaking for Baton Rouge UGs and SQL Lunch Next Week
I have been quiet over the past year trying to get acclimated to my new job and my new found work...
2012-02-03 (first published: 2012-02-02)
1,415 reads
Speaking for Baton Rouge UGs and SQL Lunch Next Week
I have been quiet over the past year trying to get acclimated to my new job and my new found...
2012-02-02
401 reads
SQL Stickers–Someone Should Build It
Here’s a niche idea that someone might have some fun with, build a site where someone can request some or...
2012-02-02
1,162 reads
A Script A Day - Day 2 - Database Mail Troubleshooting
Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...
2012-02-02
494 reads
SmartPaster
I recently discovered this great little free Visual Studio Add-in that allows pasting text as preformatted strings in VB or...
2012-02-02
830 reads
Introduction to XML DML (Part 3) - Using the modify() method: delete
This is the last part of a 3 part blog which will attempt to show some different ways of how...
2012-02-06 (first published: 2012-02-02)
10,327 reads
SQL Server – COPY TABLE from another SQL Server
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and...
2012-02-02
1,024 reads
SQL Server 2012 Virtual Launch
Microsoft organized a virtual event for SQL Server 2012 on March 7, 2012.
You can register the event by using the...
2012-02-02
930 reads
CHECKSUM vs HashBytes
Hashing can be useful in Data Warehousing as well It can give you the ability to break large problems into...
2012-02-01
30,494 reads
SSAS: Currency Conversion Using Measure Expressions
Currency conversions can be implemented several ways as part of a business intelligence solution. In some scenarios it may be...
2012-02-01
5,150 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