Site: http://sqlblog.com/blogs/erin_welker/default.aspx Link: http://sqlblog.com/blogs/erin_welker/rss.aspx
by ErinW via Erin Welker on 1/17/2010 6:09:00 PM
I had intended to post this weeks ago. I guess I'm still postponing my New Year's resolution to stop procrastinating. We're organizing our first SQL Saturday event in Dallas on May 22nd, hoping to make it an annual event. It will be held at the Region 10 Education Center in Richardson, and we currently have 4 tracks slated: Development, Administration, Business Intelligence and Beginner. I'm particularly excited about the Beginner track since we so rarely find those at t ...
[ read more ]
by ErinW via Erin Welker on 11/15/2009 4:14:15 PM
I was preparing for my presentation at PASS and wanted to show some code for automating usage-based optimization. This is the process that allows for creating aggregation designs based on past query activity. I was surprised to find that there were no code examples posted on the web on how to do this, at least none that I could find. BIDSHelper and AggManager have similar functionality but, upon examining the code, they both use a more manual approach of examining each Dataset ...
by ErinW via Erin Welker on 2/8/2009 5:01:06 PM
It's been awhile since I've blogged. Every time it seems I'll get some spare moments, something comes up to direct my attention elsewhere. My current engagement keeps me busy and embedded in SQL Server 2005. Though I've presented on some of the cool features of SQL Server 2008, I feel I have very little new insight to publish on that topic that hasn't already been covered on this site. It occurs to me that I'm most readers are in the same position that I am. Unless ...
by ErinW via Erin Welker on 5/1/2008 1:46:41 AM
I'll admit that I haven't spent a lot of time in Reporting Services. And it's been quite awhile since I've written a report against an Analysis Services cube - since SQL Server 2000, in fact. I was kind of looking forward to using the MDX designer in Reporting Services 2005 but soon found it's limitations (which are well-documented). I needed to implement drilldown on the Account hierarchy, which required pulling the preceding parent levels in a parent-child dimension. Th ...
by ErinW via Erin Welker on 2/28/2008 4:19:32 AM
I just heard about this from Len Wyatt, who's a Principle Program Manager on the SQL Server Performance team. Microsoft and Unisys announced a record for loading into a relational database, using SSIS (SQL Server 2008) to load over 1 TB of data in under 30 minutes! The previous known record-holder was Informatica, who reported loading 1 TB in 45 minutes. Note that that this is not a TPC benchmark, since none exists for loading tools (yet). Len blogged about the details on the ...
by ErinW via Erin Welker on 2/10/2008 11:37:01 PM
Horizontal partitioning can be a great benefit to data warehouses, as it greatly facilitates the management of very large databases. Of course, querying on partitions can also have performance benefits, especially when only a small percentage of the database is queried and partition elimination can occur. SQL Server 2005, however, can have some unexpected behavior when querying few partitions. In SQL Server 2005, one thread is allocated per partition when multiple partitions are queried. These ...
by ErinW via Erin Welker on 1/20/2008 5:21:00 PM
Long gone are the days when you can reasonably expect to know all aspects of SQL Server at a deep level. When a new version starts to emerge, I try to put some scope around the features that I will dive more deeply into. I'm publishing my list here so that like-minded SQL Server enthusiasts may become aware of a feature or two that was lost in that one-page Powerpoint slide you see in most of the presentations on SQL Server 2008. Note: I put together this list during the s ...
The content of the postings is owned by the respective author. SQL Feeds is not responsible for the contents of the postings. This site is automatically generated and cannot be reviewed for abusive content. If you find abusive content on SQL Feeds, please contact us. Designated trademarks and brands are the property of their respective owners. All rights reserved.
