May UG Meeting
This is just a quick note to remind any interested parties that the May S3OLV meeting will be held this...
2010-05-11
473 reads
STS-132 NASA Tweetup or "I've Won A Golden Ticket!"
Note: This is a very non-SQL Server related post. If you don't want to read something personal about me feel...
2010-05-11
859 reads
Join the Community - AKA, "Where did he go, George?"
In recent days I've kind of dropped off the map with respect to SQL Server, including with the Security and...
2010-05-11
770 reads
Simple Production Script Auditing Best Practices: Including Query in the Result Set
To make it easier for others to audit the results of a script you have run on current production servers,...
2010-05-11
1,524 reads
Twitter is…
I think Twitter is a graffiti wall that emulates a series of hallway conversations near the world's largest food court.
2010-05-11
702 reads
Put your left LOB in, put your left LOB out…
It’s time again for T-SQL Tuesday and this month the topic is LOB, or BLOB data. You can read more...
2010-05-11
1,918 reads
Daily SQL Server 2008 New Feature – Day 4
Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply...
2010-05-11
412 reads
Is Pivot Worth it?
I’ve been trying to learn more about the T-SQL changes in SQL Server 2005/2008 over time. I don’t have requirements...
2010-05-11
676 reads
Notes from the May 6th, 2010 oPASS Meeting
We moved to Thursday this month to line things up so that Dean Richards from Confio could do a presentation...
2010-05-11
558 reads
SQL Server with MS Access .adp Project file
MS Access have a nice possibility if you want to connect with SQL Server databases and manipulate with data in...
2010-05-11
13,880 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