What is SQL Server Utility?
 SSEUtil
is a tool that lets you interact with SQL Server. It allows you to:
- Connect to the main instance or
user-instance of SQL Server.
- Create, attach, detach, and list databases on the server
- Upgrade database files to match the version of the server
- Execute SQL statements via the console (similar to SQLCMD)
- Retrieve the version of SQL Server running
- Enable and disable trace flags (for example, to trace SQL statements
sent to the server by any client application)
- List the instances of SQL Server on the local machine or on remote
machines
- Checkpoint and shrink a database
- Measure the performance of executing specific queries
- Create and playback lists of SQL commands for the server to execute
- Log all input and output
Download the
SQL Server Utility from the Microsoft Website
Related articles
SQL Server performance tuning can consume a considerable amount of time
and effort. The following list is a quick guideline that you should keep in
mind when designing and developing SQL Server database applications...
All SQL Server data modifications (updates, inserts, and deletes) are
initially recorded in the database log file. Depending on the frequency of
modification and your backup and recovery model, the size of the database
log file can grow to large proportions in a short amount of time...
Use the sp_configure system stored procedure with the max server memory
option to limit the amount of memory in the buffer pool used by an instance
of SQL Server. This will prevent SQL Server from using more than the
specified amount of memory, thus leaving remaining memory available to start
other applications quickly...
Have you ever wondered which tables take the most disk space in your
database? Using the sp_spaceused stored procedure you can determine the
amount of disk space (data and index) used by any given table in the current
database...
The OPENROWSET feature in SQL Server provides a fast and easy way to open an
OLE DB compatible data source, such as an Excel sheet, directly from your
SQL script. Coupled with the "SELECT * INTO" command, the OPENROWSET feature
can import data from an Excel sheet into a table in SQL Server...
SQL Server 2005 Express Edition is a scaled down version of Microsoft SQL
Server 2005. Although the database server is limited in enterprise features,
most of the limitations do not affect the database performance for what it
is meant to do...
With the release of SQL Server 2005, Microsoft has introduced the
Express edition and the Workgroup edition to better meet the needs of
each customer. The new line of SQL Server 2005 editions includes
Express, Workgroup, Standard, and Enterprise Edition. The four new editions will offer a range of features including high
availability, scalability, and business intelligence tools...
When Microsoft first introduced MSDE 1.0, it was called Microsoft Data
Engine and it shared the same code base as SQL Server 7.0. With the release
of SQL Server 2000, Microsoft introduced MSDE 2000 and called it Microsoft
SQL Server 2000 Desktop Engine. This article provides information on MSDE
2000 as it compares to SQL Server...
|
