Parent-child dimensions in SQL Server 2005
Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.
2008-10-10
3,842 reads
Retrieving a hierarchy with recursive relationships can be difficult in SQL. Easily implement these relationships with a parent-child dimension using Analysis Services MDX.
2008-10-10
3,842 reads
Data Collections are a great tool that allows DBAs to gather different statistics, and the Management Data Warehouse (MDW) is the repository for storing those statistics. This article offers an overview of Data Collections and how to configure the MDW.
2008-10-09
2,720 reads
Attaching and restoring databases from one server instance to another are common tasks executed by a DBA. After attaching or restoring of a database, previously created and configured logins in that database do not provide access. This tip looks at how to deal with this.
2008-10-09
4,605 reads
Inspired by what he recently found in some SQL Server shops, database architect Brian Walker shares advice for improved database design – and SQL Server performance.
2008-10-08
5,952 reads
I want to suppress the trigger from firing for a particular statement while it remains in its normal execution state for any of the other statements. Is there any way this can be done dynamically?
2008-10-07
4,550 reads
A great summary from MVP Brad McGehee on the new TDE feature in SQL Server 2008
2008-10-06
3,124 reads
Part 19 digs deep into two of SQL 2005's ranking functions: RANK() and DENSE_RANK(). It includes performance considerations and using CTEs to avoid table variables.
2008-10-06
3,629 reads
Learn how to apply the new tracing functionality in Microsoft data access technologies such as ADO.NET 2.0, MDAC 2.82, SQL Server Native Client, and the JDBC driver; and in the SQL Server network protocols and the Microsoft SQL Server 2005 database engine. You can also download associated sample code for this article.
2008-10-03
2,854 reads
MS Access can retrieve and measure time with millisecond precision, but only with the help of a few well-known API calls and several user-defined functions.
2008-10-03
2,319 reads
This article describes the process of how to configure the Windows firewall for SQL Server
2008-10-02
2,670 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers