If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...

Your upcoming session at SQL Server Live!/Live! 360 talks about the "best and worst practices for indexing tables within your SQL Server 2000-2016 database." ...

With PolyBase, SQL Server offers that capability, exposing data in systems as though they were simply local SQL Server tables and letting you use the same set of T-SQL functionality you already know.

I was just wondering if anyone was dumping performance monitoring data to SQL Server tables?Any tips, advice, thoughts in general on this?Lessons hard learned, etc...?Here is what I am dreaming of ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put ...

Microsoft's SQL Server 2014 is slated to deliver in-memory OLTP capabilities, plus a handful of other new and enhanced database features early next year.

SQL Server 2008 has been designed to be a database administrators dream. Many of the features that currently exist in SQL Server 2005 are still there, but enhanced to make administration even that ...

SQL Server throws a wobbly when one tries to declare/create the same-named temporary table more than once in the same procedure - I guess the query analyser assumes that all temp table creations ...

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.