Dataset with Text or Stored Procedure
As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get...
2011-10-02
1,247 reads
SQL Saturday 97 has ended
Well it isn’t quite over for me just yet, I still have a flight home tomorrow and can’t wait to...
2011-10-02
480 reads
An Informal Compendium of SSAS Errors, Part 3: Unresolved Errors
This is the second in a series of posts on some SQL Server Analysis Services (SSAS) errors for which there...
2011-10-02
1,829 reads
Live Blogging SQL Saturday #97 Austin (hashtag #sqlsat97)
Hello and welcome to my live blog/recap of SQL Saturday #97 in Austin! Wes Brown and the crew from CACTUSS...
2011-10-01
502 reads
How to find out which Table is not having rows in SQL Server?
Introduction
Many times while tuning our production databases we might try to find out the list of tables not having even...
2011-10-01
2,344 reads
October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?
When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain...
2011-10-01
1,096 reads
24 HOP recordings
For all of you, that you have missed any session from the last 24 HOPass - you can check here
24 Session...
2011-10-01
1,169 reads
SQL Saturday 97 starts in 7 hours
I flew into Austin Texas today and got to spend time with a lot of great people. The journey started...
2011-10-01
531 reads
Come For The Education Stay For The Networking
OMG! SQLSATURDAY #97 IS HERE!
I am really excited about SQLSaturday #97! In just a few short hours we will be...
2011-10-01
756 reads
How to find a string value in all the string columns of a table/view in SQL Server ?
Introduction
I am sure many times we all might have come across situations where we need to search/find a string value...
2011-09-30
6,357 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