|
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...
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.
Jun 15, 2009
Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many... 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... More... Jun 9, 2009
Organizations banking on SQL Server to protect and manage their internal data are in for a treat when they... More... Jun 3, 2009
SQL Server 2008 introduces the concept of the sparse column, which is a type of column...
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... 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... 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...
More...
May 19, 2009
The next version of SQL Server will be getting a new name, added logical processor support and a bevy of new... 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... 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...
More...
May 5, 2009
This chapter excerpt from Learning SQL Server 2008 Reporting Services, by Jayaram Krishnaswamy, is printed with...
More...
May 1, 2009
its own file rather than be stored in the same file as the table. You have to use the T-SQL editor to modify database objects because there is still no user interface (UI...
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...
More...
Apr 21, 2009
query that retrieves data from a remote OLE DB data source or bulk loads data into a SQL Server table. In such cases, you can use the OPENROWSET function in Transact-SQL to...
More...
Apr 16, 2009
Although the changes in replication when moving from SQL Server 2000 to 2005 were radically different, the enhancements for 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... More... Apr 9, 2009
while increasing the scalability and availability associated with their SQL Server infrastructures. Although it would seem natural for most organizations to...
More...
Apr 3, 2009
This chapter excerpt from Microsoft SQL Server 2008 Management and Administration, by Ross Mistry, is printed with...
More...
Apr 1, 2009
When planning a SQL Server upgrade -- such as an upgrade to SQL Server 2008 -- one of the most important...
More...
Mar 30, 2009
in an effort to reduce costs. This is especially true in large organizations with SQL Server infrastructures, where IT staffs often find themselves running many...
More...
Mar 25, 2009
There are several benefits to consolidating your SQL servers, but there are also a number of "gotchas" to consider before moving forward... 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...
More...
Mar 23, 2009
|
Server Clustering Solutions
Server Clustering Whitepapers
|