|
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
is disabled. Instant file initialization is a feature of Windows Server 2003 that SQL Server 2005 can take advantage of where database growth times are extremely fast, as the...
More...
Jun 9, 2009
has outlined specific strategies for virtualizing SQL Server installations. Both SQL Server 2005 and 2008 are supported on Hyper-V and other, non-Microsoft hardware virtualization...
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... 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...
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 data... 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...
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...
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 pass a...
More...
Apr 16, 2009
of eye-popping. A pull replication scenario, which used to run in 223 minutes using [SQL Server 2005] Yukon on Win2K3, takes just under 2 minutes on [Windows 2008 Server] Longhorn...
More...
Apr 13, 2009
don't create complications with the new version. In my experience, though, moving from SQL Server 2005 to SQL Server 2008 doesn't present many issues that compromise an entire migration...
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 permission...
More...
Apr 1, 2009
it is never a certainty. This is especially true for upgrades from SQL Server 2000 to SQL Server 2005, which appear to be the most untested upgrade path in quite a while.
Considering that... 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
This short guide features expert advice for those looking to learn more about SQL Server consolidation, with details on when (and when not) to consolidate, 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 your...
More...
Mar 23, 2009
|
Server Clustering Solutions
Server Clustering Whitepapers
|