|
Solution Search:
SQL Admin Tips
times each and the execution statistics were captured by SQL Profiler. Here is the code: -- Truncate the table
truncate table ExpandDB go -- Truncate the T-Log backup... More... Jun 25, 2009
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 database, so that it's already...
More...
Jun 22, 2009
that are optimized for just that. This is the case for SQL Server 2008 among other Microsoft products.
When previously discussing fault-tolerant virtual installations, the... More... Jun 15, 2009
SQL Server Articles
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
ease of use and manageability, functionality, value and support.
Quest Software's LiteSpeed for SQL Server 4.6 was the Gold Award winner in the Backup and Recovery category, while Tableau... More... Jan 15, 2007
2 now covers several Windows server workloads including Exchange 2000 Server, Exchange Server 2003, SQL Server 2000 and SQL Server 2005.
Another public beta, due out this spring, will include... More... Sep 27, 2006
placed in the database. They did that because the general consensus after the first generation of client-server development was that stored procedures did not scale and led to vendor lock in. A lot...
More...
Aug 16, 2006
|
SQL Development Tips
to 1MB;
In the second step, autogrowth was set to 10MB.
The two steps were executed three times each and the execution statistics were captured by SQL Profiler. Here is the code: -- Truncate the table... More... Jun 25, 2009
backup system doesn't support encryption, then you'll need 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...
More...
Jun 22, 2009
has continued its commitment to server virtualization by releasing new software products that are optimized for just that. This is the case for SQL Server 2008 among other Microsoft products.
When... More... Jun 15, 2009
SQL Server White Papers
SQL Word Definitions
SQL Server
SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment. SQL...
More...
Jan 10, 2006
Database: Glossary
programmer responsible for developing the conceptual framework for the relational database and SQL.
HOLAP - hybrid online analytical processing, a combination of ROLAP and MOLAP. Java Data Objects - an API that enables a Java... More... Oct 27, 2003
Quiz: SQL Server 2000
DIRECTIONS: Match the SQL Server statement in the right-hand column with its description in the left-hand column. How to take the quiz: Sep 23, 2003
|