Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » disk space » performance   (RSS)
How SQL Server manages when a database is created in terms of I/O and disk usage?
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that Read More...
FULLTEXT catalogs and BACKUP - behaviour in SQL Server 2005
There should be no special consideration to perform BACKUP activities within your SQL Server environment. But if you are using FTS with full-text indexes/catalogs then you should be concerned about point-in time recoverability with the backups. You may Read More...