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
-
Six top SQL Server 2012 management tools you should know about
Read this tip from Basit Farooq to learn which time-saving and job-improving SQL Server 2012 management tools you need to know about. 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
-
Intel boosts Moore's Law with SQL 2012 business intelligence
Moore's Law doesn't just happen on its own. Relevant companies, and the people behind them, need to make it happen. At Intel, leaders said they carried out a SQL 2012 business intelligence project using self-service BI that helped the company... Feature | SearchSQLServer.com
-
Microsoft unveils GeoFlow 3-D SQL Server mapping tool
A public preview is now available for GeoFlow, a 3-D mapping tool that will be an add-on to Microsoft Excel 2013, and which can turn SQL Server data into three-dimensional graphs and animations.
The new tool is almost like a 3-D version... News | SearchSQLServer.com
-
SQL Server stored procedures vs. CLR stored procedures: Time to migrate?
Years ago, I had a class project that used SQL Server as a back end and a website as a front end, and one of the incremental exercises I implemented on it was moving all those horrible ad hoc, in-line SQL Server statements to SQL Server... Tip | SearchSQLServer.com
-
SQL Server big data technologies should be a major DBA focus
In this edition of SQL in Five, Mark Kromer, national platform architect at Microsoft, says database administrators need to start familiarizing themselves with SQL Server big data technologies.
Q&A | SearchSQLServer.comLegacy file systems, away: Dealing with an unsupported file system
What do you do when you've found the perfect solution to your problem, but it's no longer supported?
This was the issue that faced the City of Aurora, Colo. Longtime users of the PolyServe file... Feature | 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
Search Again: