SearchSQLServer provides targeted news, expert advice, tips, search, learning guides, webcasts and research that cover all aspects of Windows-centric database design, development, administration and management.
View the complete archive of SQL Server Management news, research and expert advice.
Go to SearchSQLServer.comRecently on SearchSQLServer.com
Database index design and optimization: Some guidelines
What are the latest tips and tricks for database design and optimization? Check out this tip from Basit Farooq to learn more.
-
More Highlights
-
Clustered index vs. non-clustered index
This expert response examins clustered indexes vs. non-clustered indexes.
-
How to speed up a composite nonclustered index-based query
A query still responds slowly after implementing an index. Performance Tuning...
-
Adding non-clustered indexes to SQL Server columns
Adding non-clustered indexes to SQL Server columns and tables frequently quer...
-
-
Definitions
-
database replication
Database replication is the frequent electronic copying of data from one comp...
-
SQL Azure
SQL Azure is Microsoft’s cloud database service.
-
multidimensional expressions (MDX)
multidimensional expressions (MDX)
-
Browse SQL Server Topics
-
Microsoft SQL Server Platforms
The SQL Server platform topics page provides resources for the enterprise database administration and development community covering the last three releases of Microsoft SQL S... More about Microsoft SQL Server Platforms
-
Recent Definitions
-
Quiz: Database Basics
- Directions: - After reading the question, click on the answer that you think is correct. -
Yukon
- Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and s... -
flat file
- A flat file is a file containing records that have no structured interrelationship.
-
-
Highlights
-
More Microsoft SQL Server Platforms Topics
-
Microsoft SQL Server Administration
The Microsoft SQL Server administration topics page provides resources for the enterprise SQL Server community that include the latest topics on SQL Server performance and tunin... More about Microsoft SQL Server Administration
-
Recent Definitions
-
SQL Server 2012
- Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 20... -
database mirroring
- Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that mig... -
external hard drive
- An external hard drive is a portable storage device that can be attached to a computer through a USB or Firewire connection, or wirelessly.
-
-
Highlights
-
More Microsoft SQL Server Administration Topics
SQL-Transact SQL (T-SQL)
Microsoft SQL Server Performance Monitoring and Tuning
SQL Server Security
SQL Server Stored Procedures
SQL Server Replication
SQL Server High Availability, Scalability and Reliability
SQL Server Backup and Recovery
Microsoft SQL Server Tools and Utilities
SQL Server Interoperability
Microsoft SQL Server Installation
-
SQL Server Business Intelligence (BI) and Data Warehousing
The need for organizations to have sound business intelligence and data warehousing solutions is becoming more critical by the day. Microsoft has recognized this by adding sever... More about SQL Server Business Intelligence (BI) and Data Warehousing
-
Recent Definitions
-
SQL Server 2012
- Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 20... -
data mining
- Data mining is the analysis of data for relationships that have not previously been discovered. For example, the sales records for a particular brand of tennis ... -
data warehouse or information warehouse
- A data warehouse is a central repository for all or significant parts of the data that an enterprise's various busines...
-
-
Highlights
-
More SQL Server Business Intelligence (BI) and Data Warehousing Topics
-
Microsoft SQL Server Database Development
The SQL Server database development topic page provides resources for the enterprise DB development community that include the latest topics on stored procedures, SQL and T-SQL,... More about Microsoft SQL Server Database Development
-
Recent Definitions
-
database replication
- Database replication is the frequent electronic copying of data from one computer or server to another so that all users share the same level of in... -
multidimensional expressions (MDX)
- multidimensional expressions (MDX) -
tablespace
- In a database management system (DBMS), a tablespace is a logical group of data files in a database. A typical database contains at least one tablespace, and usua...
-
-
Highlights
-
More Microsoft SQL Server Database Development Topics
-
Microsoft SQL Server Management Issues
The Microsoft SQL Server management issues topics page provides resources for enterprise database managers including topics on SQL Server migration strategies and licensing cons... More about Microsoft SQL Server Management Issues
-
Recent Definitions
-
SQL Server 2012
- Microsoft SQL Server 2012 is a relational database management system (RDBMS) designed for the enterprise environment. Like its predecessors, SQL Server 20... -
database mirroring
- Database mirroring is the maintenance of redundant copies of a database to ensure continuous data availability and minimize or avoid downtime that mig... -
SQL Azure
- SQL Azure is Microsoft’s cloud database service.
-
-
Highlights
-
More Microsoft SQL Server Management Issues Topics