More Results
-
T-SQL tricks for SQL Server 2012: T-SQL statements
In the final part of Robert Sheldon's series on features and tricks in T-SQL, learn about important T-SQL statements like LAG, LEAD and more. Tip | SearchSQLServer.com
-
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
-
More T-SQL statements in SQL Server 2012 you need to know about
In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more. Tip | SearchSQLServer.com
-
Autumn Statement sticks to government trajectory
The Autumn Statement was an exercise from the Chancellor is making sure that he stuck to the economic course he has set out on Feature | MicroscopeUK
-
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
-
Judges scold Apple for Samsung statement
Apple is forced to redraft the statement on its website regarding its patent case against Samsung after a judge deems it ‘non-compliant’ News | ComputerWeekly.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
-
SQL Server 2012 security: Changes for the newest version
Editor's note: This is part two of a four-part series about SQL Server security. The first part, "Why SQL Server security... Series | 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
Search Again: