Don’t You Know Who I Am?
I’m happy to say that for most of you out there, the answer to this question is “no.” That’s as...
2012-05-16
835 reads
Suggestion: “USE” keyword with Linked Servers
Using special functions for querying and executing commands at linked servers is not very convenient, and sometimes even very problematic.
For...
2012-05-16
571 reads
Upgrading Packages to SSIS 2012
Many of you may now or in the future have the need to upgrade your SSIS packages to the new...
2012-05-16
26,086 reads
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...
2012-05-16
826 reads
Shredding a simple xml structure to a single row flat table
I was helping out a user on the forums the other day where they were asking questions about shredding an...
2012-05-22 (first published: 2012-05-16)
5,400 reads
Quick tip: sp_configure and sys.configurations
In order to query the configuration settings of a server you can run this sproc:
exec sp_configureOn a default install of...
2012-05-16
1,137 reads
Dell 12th Generation Server Cheat Sheet
Over the past several months, Dell has been rolling out a number of new 12th generation servers that all use...
2012-05-16
2,255 reads
SQL Rally 2012 Recap and Session Files
SQL Rally 2012 Recap and Session Files
Dallas Convention Center
SQL Rally 2012 was hosted by the North Texas SQL Server User...
2012-05-15
1,045 reads
Ad hoc query optimization in SQL Server
When ad hoc queries are executed in sql server, if it is executed without parameters, and it is simple, SQL...
2012-05-15
4,921 reads
Session Files from SQL Saturday #107 Houston
Session Files from SQL Saturday #107 Houston
Houston Skyline
SQL Saturday Houston was a great event hosted by the Houston Area SQL...
2012-05-15
1,266 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