Important: System Objects/Views/DMV/DMF
Important: System Objects/Views/DMV/DMF This is the some of the list of System Objects/Views/DMV/DMF. Catalog View: All system information is stored...
2010-06-17
1,018 reads
Finding SQL Server Client Ports
I saw a post recently asking if there was an easy way to find the port a client was using...
2010-06-17
1,588 reads
PASS Update #33
It’s been almost a month since my last update, too long! I’ve put up separate posts on my unplanned and...
2010-06-17
711 reads
Building a PASS Voting Solution – Part 1
Last year for the annual Board of Directors election we used Zoomerang as our e-voting solution. It’s not the worst...
2010-06-17
519 reads
Strange but True: Reporting Off of Cubes with Parameters Creates Hidden Datasets
I know, it is strange, but it is true...When you create Reporting Services reports that run off of an Analysis...
2010-06-17
1,005 reads
What is the Ideal SQL Server Test Box?
I’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL...
2010-06-17
427 reads
24 HOP Available
Just a quick note. PASS has made the 24 Hours of PASS available via streaming video. You can check it...
2010-06-16
487 reads
24 Hours of PASS Recordings Now Available
Our most recent 24 Hours of PASS celebrated the SQL 2008 R2 launch. 24 great sessions, 23 of which were...
2010-06-16
594 reads
My PASS Session Abstracts
The 1992 Dream Team
When you hear the phrase “All-Star Lineup”, what comes to mind? The New York Yankees? The 1970's...
2010-06-16
334 reads
So I Won't Be Going to the Summit This Year
As the deadline for abstracts to be submitted to the PASS Summit came due, I made the hard decision not...
2010-06-16
648 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