How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a...
2010-06-18
1,969 reads
Finding Duplicates
This is just a short post that uses a contrived example to demonstrate how to find duplicate records in a...
2010-06-18
1,130 reads
Learn SQL Server 2008 R2 with 24-HOP
Last month, the Professional Association for SQL Server (PASS) held its second 24 Hours of PASS, or 24 HOP for...
2010-06-18
416 reads
PASS Update #34 (The “Spring Event”!)
The minutes of the June 2010 Board meeting have been posted and if you haven’t read them yet, you missed...
2010-06-18
673 reads
SQL Spatial data for State/County shapes
I saw a Blog post by Grant Fritchey (Blog | Twitter) a couple days ago on using Geospatial data in SSRS...
2010-06-18
1,817 reads
June SCSUG Meeting Follow-up
This is a bit later than usual as the meeting was a week ago now, but I wanted to post...
2010-06-18
677 reads
Speaking and Presenting Tips - Handouts
I’ve given quite a few presentations, one keynote with another to come, and attended many more. I’ve read a few...
2010-06-18
1,201 reads
Building a PASS Voting Solution – Part 2
Yesterday I wrote about deciding to build a quick and dirty voting solution. Or to try to at least! Should...
2010-06-18
762 reads
Travel Tips from an Intrepid Traveling DBA
Recently, Buck Woody challenged myself, Paul Randal, and Brent Ozar to write a blog post on “How I Travel”. I...
2010-06-18
2,361 reads
Notes from the June 2010 oPASS Meeting
We had adjusted our meeting date to work around previous commitments for both Jack Corbett and I, and that may...
2010-06-17
552 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