(Michael Otey) Q: How do I size the bucket_count value for SQL Server 2014’s In-Memory OLTP hash indexes?

(Paul Ferrill) Microsoft releases new versions of its main products on a relatively predictable schedule. SQL Server releases or major updates have appeared at roughly two-year intervals going back to SQL Server 2008. A bit of a naming anomaly occurred with SQL Server 2008 R2, but that name coincide

(Ben Snaidero) Most DBAs, myself included, install SQL Server with the default server collation SQL_Latin1_General_CP1_CI_AS and all of our table columns get created using this default setting. This tip will look at the performance impacts of querying data with this setting as it compares to queryin

(Thomas LaRock) I like having a routine. Most people do, I suppose. There’s some comfort in knowing what lies ahead, what comes next.

(Jonathan Hickford) In my previous post, “Automating Deployments with SQL Compare command line” I looked at how teams can automate the deployment and post deployment validation of SQL Server databases using the command line versions of Red Gate tools. In this post I’m looking at another use for the

(Pinal Dave) Here is a question which I have received from user yesterday.

(Shehap El Nagar) Database Performance has become an important subject for any database administrator, database Analysts and IT Directors. That is why Microsoft has focused on the performance factor within SQL Server 2014 to achieve 10x-30x improvement without touching your code whatsoever, they did

(Dmitri Korotkevitch) Last time we have looked at the internal structure of delta store and delete bitmap in the clustered columnstore indexes. Today, I would like us to discuss a few practical aspects affecting performance of ETL processes and queries against tables with clustered columnstore index

(Allen White) Throughout my career, I’ve needed to restore a SQL Server database from a backup file, and either the backup is from a system other than the server where the restored database needs to be placed, or it’s from an unknown (but trusted) source.

(John Ssansom) A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the SQL Server Dynamic Management Views(DMVs)?