This document describes the indexed views capability of SQL Server 2005 and SQL Server 2008, including the new support for partition-aligned views added to SQL Server 2008. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.
2009-06-19
4,111 reads
When an enterprise first encounters master data management, it often doesn’t have a clear understanding of how MDM will affect the architecture of its business transaction systems or business intelligence systems. This article describes master data patterns in legacy system architectures, a general MDM architecture and some ways the new MDM layer affects the master data patterns in the legacy layers.
2009-06-19
2,401 reads
Learn to enable the FILESTREAM feature in SQL Server 2008 and configure your database to support it.
2009-06-18
2,817 reads
Recent installments of our series dedicated to the most prominent features of SQL Server 2005 Express Edition have discussed its reporting capabilities. This article illustrates another approach to generating reports, relying on the Report Server Project template, which offers a considerably wider range of flexibility than its wizard-driven counterpart does.
2009-06-18
2,151 reads
This document describes common data warehouse implementation strategies and proposes an effective hub-and-spoke architecture using a massively parallel processing system with multiple instances of SQL Server databases.
2009-06-17
2,159 reads
Learn about the advantages available for SQL Server consolidation and virtualization when running SQL Server 2008 on Microsoft Hyper-V for Windows 2008.
2009-06-17
2,531 reads
Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and you'll confuse users and run into data warehousing brick walls.
2009-06-16
4,808 reads
Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
2009-06-15
4,321 reads
This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.
2009-06-12
2,093 reads
Authenticators are additional data that gets encrypted along with the data to be stored in an encrypted manner. When it comes to decrypt the data, if the right authenticator isn't specified, SQL Server doesn't return the data in the decrypted form. Rather, a NULL value is returned, just as if the wrong key was used.
2009-06-12
2,384 reads
By Steve Jones
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of...
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
Hi. What is the most difficult aspect of using monitoring software like idera, redgate,...
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Comments posted to this topic are about the item Making an Impression
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers