|
Solution Search:
steps were executed three times each and the execution statistics were captured by SQL Profiler. Here is the code: -- Truncate the table
truncate table ExpandDB go -- ... More... Jun 25, 2009
to look into an encryption system outside of the backup solution. If you are running SQL Server 2008, you can use the Full Database Encryption option that encrypts the data in the...
More...
Jun 22, 2009
new software products that are optimized for just that. This is the case for SQL Server 2008 among other Microsoft products.
When previously discussing fault-tolerant... More... Jun 15, 2009
Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many editions... More... Jun 10, 2009
Transparent Data Encryption (TDE) is a new feature in SQL Server 2008 designed to encrypt your database files, database backups and temporary database... More... Jun 9, 2009
to protect and manage their internal data are in for a treat when they upgrade to SQL Server 2008. That's because the latest version of SQL Server provides a host of new features...
More...
Jun 3, 2009
SQL Server 2008 introduces the concept of the sparse column, which is a type of column that...
More...
Jun 2, 2009
A full transaction log is a sporadic, yet common problem for SQL Server DBAs. It can cause a transaction to be terminated prematurely, or even take a system... More... May 27, 2009
The new FILESTREAM functionality in SQL Server 2008 lets you configure a varbinary(max) column so that the actual data is stored on the... More... May 25, 2009
specifically with virtualization of the workload in mind. This is the case for SQL Server 2008, among others. When you run SQL Server 2008 on Windows Server 2008 inside a virtual...
More...
May 19, 2009
label the next major release of SQL Server, which was expected to be SQL Server 2010, as SQL Server 2008 R2. The product had previously gone under the code name Kilimanjaro. A Community...
More...
May 11, 2009
approach is going to run fastest for the business requirements and data content?
SQL Server full-text performance can be improved by doing the following best practices:
... More... May 7, 2009
One of the new Transact-SQL features implemented in SQL Server 2008 is the GROUPING SETS option in the GROUP BY clause of a SELECT statement. Compared...
More...
May 5, 2009
This chapter excerpt from Learning SQL Server 2008 Reporting Services, by Jayaram Krishnaswamy, is printed with permission from...
More...
May 1, 2009
on the disk. Database Schema View, the other view, is hierarchical in the manner of SQL Server Management Studio. There is a list of top-level objects, such as tables or stored...
More...
Apr 27, 2009
of handling larger workloads, or in other words, making it bigger and better. With SQL Server 2008, there are two distinct paths you can take to scaling: up and out. Both are designed to...
More...
Apr 21, 2009
you can also find details about the SQLNCLI provider (or the SQLNCLI10 provider in SQL Server 2008).
ABOUT THE AUTHOR: Robert Sheldon is a technical consultant and the... More... Apr 16, 2009
moving from SQL Server 2000 to 2005 were radically different, the enhancements for SQL Server 2008 are much more subtle. The following replication features are new in SQL Server 2008:
... More... Apr 13, 2009
So you've decided to upgrade to SQL Server 2008 – what now? Let's take a look at some of the basics steps to ensure a successful... More... Apr 9, 2009
include four quad-cores, 64 GB of RAM, 64-bit technology and the Enterprise Edition of SQL Server 2008 or Windows Server 2008. Not a cheap project. These budget challenges are forcing...
More...
Apr 3, 2009
This chapter excerpt from Microsoft SQL Server 2008 Management and Administration, by Ross Mistry, is printed with permission from...
More...
Apr 1, 2009
When planning a SQL Server upgrade -- such as an upgrade to SQL Server 2008 -- one of the most important aspects to consider is testing. Too often, people move...
More...
Mar 30, 2009
and other challenges associated with business continuity.
Fortunately, by using SQL Server 2008 on Windows Server 2008, organizations can successfully address the issues... More... Mar 25, 2009
strategies, virtualization with Microsoft Hyper-V, and more. FEATURED CONTENT
SQL Server 2008 consolidation strategies and best practices There are several consolidation... More... Mar 25, 2009
Let's say you've just spent many hours designing a SQL Server 2005 Analysis Services (SSAS) unified dimensional model for the sales managers in...
More...
Mar 23, 2009
|
Server Clustering Solutions
Server Clustering Whitepapers
|