Getting Started With Hierarchical Queries Hierarchical queries return rows in the order that forms a hierarchical tree where each row is located at a certain level in a hierarchy, having a parent, children, or both. The best way to understand this concept is to build some hierarchical queries against database objects that permit it. For example, you might issue such...
Standard Members
Database Capacity Planning
Database Capacity Planning By Craig S. Mullins Most database implementations are anything but static. Once deployed, databases are queried, updated, loaded, unloaded, reorganized, and data is deleted and inserted from them on an ongoing basis. As the data composition of a database changes, it storage requirements will change as well. The DBA must be ever vigilant to plan for future...
XML Support and SQL Server (Part 3)
XML Support and SQL Server (Part 3) By Basit A. Farooq This article is the third part of the XML support and SQL Server article series. In this part, I’ll first talk about what fundamental problems we have in integration XML and SQL Server. Then, I’ll cover what storage options we have in SQL Server to store the XML data...
Working with PEX Framework
Working with PEX Framework Microsoft’s PEX Framework is an automated white box testing tool that can be integrated with Visual Studio. It has been developed by Microsoft research team and generates test suites with high code coverage. It can investigate and explore the managed code and suggest the tests which a particular test requires. PEX framework from Microsoft provides support...
SQL Server 2012 XML Optimization Tips
SQL Server 2012 XML Optimization Tips Consider using the XML data type. This data type is used to store XML documents in table columns or Transact-SQL variables. The XML data type can be used in variables, columns, or in stored procedure and function parameters. You can build, rebuild or drop XML indexes online. In SQL Server 2012, indexes that include...
Learning SSAS: Part III- Building Cubes
Learning SSAS: Part III- Building Cubes Hello and welcome to the third part of this series dedicated to learning SQL Server Analysis Services. In the first article I talked about the basics of dimensional modeling and business intelligence. Also, the reader was acquainted with the jargon associated with data warehousing. In the second article the reader learnt few things about...
Recoverability Trumps Performance
Recoverability Trumps Performance By Craig Mullins Many DBAs reading this article will look at the title and immediately think I’m wrong… at least initially. They’ll claim that managing performance is the most important thing they do, but they are confusing frequency with importance. Yes, DBAs confront performance issues more often than they build backup plans – and they better be...
Working with Parallel LINQ
This article reflects on parallel programming concepts, PLINQ, discusses the new features and enhancement to the Parallel Extensions Library, and reflects on how to implement declarative data parallelism in your applications using PLINQ. It also discusses the tips and techniques to better leverage the benefits of PLINQ. Single and Multi-threaded Applications Applications are either single threaded or multi-threaded. In a...
Tips for using SQL Server 2012 backup and restore
Tips for using SQL Server 2012 backup and restore Consider using page restores. SQL Server Management Studio supports page restores in SQL Server 2012. Now you can check database pages for corruption and restore selected corrupt pages from a database backup and subsequent log backups. Use the Database Recovery Advisor to construct restore plans that implement optimal correct restore sequences....
Learning SSAS-Part II: Data sources, Data source views
Learning SSAS-Part II: Data Sources, Data Source Views Welcome to the second part of the Learning SQL Server Analysis Services series. In the first article of the series you learnt the basics of business intelligence and data warehousing. You also understood about various terms like cube, dimension and facts. Now it is time to use this understanding and apply it...