SSIS : Conditional Split optimization
I have built an enormous number of packages for this project over the past few weeks (just over 60) and...
2010-04-26
568 reads
Size of the DB limit has changed...
The cool update from SQL Server 2008 R2 is the possibility from Express Edition that changed the database limit from...
2010-04-26
737 reads
SQL Server 2008 R2 Books OnLine - available now...
SQL Server 2008 R2 is released on April 21st, 2010 and in parallel with this new release, now is available...
2010-04-26
2,941 reads
Speaking at Auckland, New Zealand SQL Users Group
On Tuesday Morning at 2:00 am EST time I will be speaking at the Auckland SQLUsers Group. This will be...
2010-04-25
550 reads
Need Data from a Mac: TransMac for Reading HFS Volumes a Lifesaver
Recently I was handed over a HFS volume to read from my colleague who uses his Macbook exclusively. We had...
2010-04-25
1,050 reads
A DMV a Day – Day 25
The DMV for Day 25 is sys.dm_os_memory_cache_counters, which is described by BOL as:
Returns a snapshot of the health of a...
2010-04-25
1,706 reads
Reporting Services 2008 R2 Report Parts
Reporting Services 2008 R2 has many new great features that I’ve written about lately (Data Bars and Indicators). Today I...
2010-04-24
1,343 reads
A DMV a Day – Day 24
The DMV for Day 24 is sys.dm_exec_requests, which is described by BOL as:
Returns information about each request that is executing...
2010-04-24
993 reads
Besides Being a DBA, Do You Also Happen to be an Exchange Administrator?
I know a lot of DBAs fall into the category of part-time DBAs, because they work in small IT shops...
2010-04-23
557 reads
SQL Server 2008 R2 Road Show Recap
This past week I had the opportunity to speak at three SQL Server R2 Launch events.I spoke in three cities...
2010-04-23
412 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