Inside the Optimizer: Constructing a Plan - Part 4
The final part in a series by Paul White exploring the internals of query optimization. Learn how
We Are Not Alone
Today we have a guest editorial from Robert Pearl that talks about the SQL Server community, and how you can get involved.
Conditional report rendering based on render formats for SSRS Reports
When using Report Manager, users can export reports to different formats like PDF, XLS and others. When reports are exported to other formats they also include all of the content from the report, but rendered to the format of the report output. There maybe scenarios where you would not want a particular part or component of report to appear in these other report formats. A practical example of this could be that you want to display images when the report is displayed in HTML, but not when the report is exported to a PDF format. In this tip we take a look at a new feature in Reporting Services that allows us to control these items without having to create multiple report versions.
SQL Saturday #52 - Colorado
A free one day training event in the Denver Tech Center on Sept 25, 2010. Come learn about SQL Server and how to further your career at this one day event.
Social Engineering Dangers
Social engineering is one of the most effective ways to hack information out of a company. Steve Jones looks at this technique and a recent contest at DefCon that featured social engineering.
Ways to minimize sort operations
In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.
Issuing Current Time Increments in StreamInsight (A Practical Example)
The issuing of a Current Time Increment, Cti, in StreamInsight is very definitely one of the most important concepts to learn if you want your Streams to be responsive. A full discussion of how to issue Ctis is beyond the scope of this article but a very good explanation in addition to Books Online can be found in these three articles by a member of the StreamInsight team at Microsoft, Ciprian Gerea.
SQL Saturday #49 - Orlando
A free, one day training event taking place on October 16, 2010 in Orlando, FL.
Inside the Optimizer: Constructing a Plan - Part 3
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
More Than SQL
Today Steve Jones talks about the upcoming SQL Saturday #52 in Colorado, and how it's encompassing more than just a day of SQL learning.
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat Kantor BCA KCU KUDUS Telp:0817839777
WhatsApp: 0817839777 Jl. Jend. Ahmad Yani No.91, Magersari, Panjunan, Kec. Kota Kudus, Kabupaten Kudus,...
Alamat Kantor BCA KCU SEMARANG Telp:0817839777
WhatsApp: 0817839777 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers