Speaking at Space Coast SQL Users Group on Feb 9, 2012
I’ll be visiting the Space Coast group (http://spacecoast.sqlpass.org/) on Feb 9th to do a presentation on Professional Development Plans. I’m...
2012-02-01
727 reads
Blog Posts
SSAS: Currency Conversion Using Measure Expressions
Currency conversions can be implemented several ways as part of a business intelligence solution. In some scenarios it may be...
2012-02-01
5,066 reads
SSRS – Using Analysis Services Dynamic Management Views to Build Dynamic Reports
Dynamic Management Views are a very powerful tool that are part of Analysis Services in 2008 and 2008 R2. They...
2012-02-01
2,305 reads
Using the Error Output of the Derived Column
The other day I was building a simple data import package when I ran into a
common situation; invalid conversions in a Derived Column. The conversion
was taking an ISBN13...
2012-02-01
4 reads
Using the Error Output of the Derived Column
The other day I was building a simple data import package when I ran into a common situation; invalid conversions...
2012-02-01
721 reads
Using the Error Output of the Derived Column
The other day I was building a simple data import package when I ran into a common situation; invalid conversions in a Derived Column. The conversion was taking an...
2012-02-01
4 reads
Your Road to Becoming a DBA: Acquiring Experience is Key
Knowing precisely how to start on your next adventure is tricky. With so many options and decisions in front of...
2012-02-01
1,059 reads
App Domains and Their Uses
What is an app domain
An App Domain can be thought of as a kind of lightweight process. So What is...
2012-01-31
96 reads
2012-01-31
1 reads
2012-01-31
1 reads
Blogs
Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
Counting Groups with Window Functions: #SQLNewBlogger
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
The query processor ran out of internal resources and could not produce a query plan – When You’ve Managed to Confuse SQL With a Crazy IN Clause.
Recently I received a cry for help over Teams. The issue was that an...
Forums
WhatsApp +52 6643030891 Get A1, B1, C2 telc zertifikat without exam
geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...
Get TELC Zertifikat B2 Without Exam in * Slovenia WhatsApp +52 6643030891
geotheexamscenter@yahoo.com Welcome to All German Certificates the best website which produces genuine German language...
Temporary Table Problem
Hello everyone, I hope you can help me. I have a table with measurement...
Question of the Day
Incremental Statistics
I have run this on SQL Server 2022 for the Sales database:
ALTER DATABASE Sales SET AUTO_CREATE_STATISTICS ON (INCREMENTAL = ON)I then run this in the Sales database:
USE Sales GO CREATE STATISTICS CustomerStats1 ON dbo.Customer (CustomerKey, EmailAddress) WITH INCREMENTAL = OFFThe dbo.Customer table is partitioned. How are statistics created? See possible answers