All About Execution Plans
If you’re attending the PASS Summit this October, I’d like to make a suggestion. The Summit itself is only three...
2011-08-03
872 reads
Detecting Fake Reviews
I saw this write up about Cornell coming up with a way to detect fake online reviews with about 90%...
2011-08-03
867 reads
Updating Views
Written by Ian Treasure
Gethyn recently posted on deleting from a view. He used a common situation where several tables are...
2011-08-03
10,165 reads
Rant: Security Isn't Sexy and It's a Shame
I grew up immersed in security. My father was a US Marine and going on and off base meant... security....
2011-08-03
1,237 reads
SQL Saturday #79 South Florida
SQL Saturday in South Florida is quickly approaching in just 2 short weeks. As usual, if you are in the...
2011-08-03
663 reads
Applying a Snapshot -AltSnapshotFolder Parameter
Did you know a snapshot can be applied using the Distribution and Merge Agent –AltSnapshotFolder parameter? This means that after...
2011-08-03
567 reads
Awesome new features in SQL Server 2011 “Denali”: IIF and CHOOSE functions
SQL Server 2011 “Denali” introduces two new features for flow control which may help you to keep your T-SQL cleaner than...
2011-08-02
643 reads
SQL Server Functions- An Introduction
SQL FUNCTION: -
Function in a database can be defined as the code segment consisting of a logical group of SQL...
2011-08-02
2,996 reads
I deem September 2011 – SQL Server Month
If you haven’t visited the SQL Saturday website you should take a look. There are SEVEN events planned during September around...
2011-08-02
560 reads
PowerPivot Gallery Error Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’
Oh no you, you got the Could not load type ‘Microsoft.AnalysisServices.SharePoint.Integration.ReportGalleryView’ error!!! What to do now? Why did you get...
2011-08-02
1,071 reads
Blogs
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...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
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