More Results
-
Database index design and optimization: Some guidelines
Well-designed indexes are an important part of database optimization because they are the key factor in achieving optimal query performance and response... Tip | SearchSQLServer.com
-
xVelocity Columnstore Indexes in SQL Server 2012
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity... Tip | SearchSQLServer.com
-
Useful SQL Server 2012 features to become familiar with
SQL Server 2012 has plenty of new features for everyone, from developers to administrators. There are several features for high availability and database administration that will improve DBA operations. We're going to look at four of them:... Tip | SearchSQLServer.com
-
Manage, query SQL Azure Federations using T-SQL
EDITOR’S NOTE: The following is the first article in a two-part series on managing Microsoft’s sharding technology SQL Azure Federations with Transact-SQL (T-SQL). Part 1 focuses on using T-SQL to create federated tables and migrating data... Tip | SearchSQLServer.com
-
Six top SQL Server 2012 management tools you should know about
Management tools play a vital role in enterprise database management. This is because the well-integrated tools extend the administrator's capabilities, whereas a random collection of tools can lead to confusion, operational mistakes, high... Tip | SearchSQLServer.com
-
Microsoft SQL Server 2012: A dozen features you might have missed
No longer are enterprise customers confined to one flavor of Enterprise Edition. Microsoft SQL Server Enterprise Edition now gives you two... Photo Story | SearchSQLServer.com
-
Why you should think twice about Windows Azure SQL Database
In the first part of this piece, I took a look at the reasons why... Feature | SearchSQLServer.com
-
Maximize SQL Server database performance by streamlining your data
As the databases behind websites and applications become bigger and busier, application architects and developers often need to figure out very quickly how to scale the database before the application becomes unusable under heavy... Tip | SearchSQLServer.com
-
Little-known features of Microsoft SQL Server 2012
After more than 25 years of working with Microsoft SQL Server, you'd think pretty much everything has been done at least once. I thought it would be... Feature | SearchSQLServer.com
-
SQL Server editions: Is Microsoft SQL Server Express right for you?
Editor's note: This is the first in a three-part series that will examine three popular versions of Microsoft SQL Server, along with the pros and cons of each. Check back next week for the second installment.
Deciding... Series | SearchSQLServer.com
Search Again: