@sqlserverperf profile picture
SQLServerPerformance @sqlserverperf
Joined July 2010
  • Tweets 218
  • Following 0
  • Followers 158
Photos and videos
SQL Server Audit Walkthrough: So, you are the Database Administrator in your company and your boss... bit.ly/2dYGCC8 #SQLServer
SQL Server Logical Reads – What do they really tell us?: SQL Server trace, the most common tool DB... bit.ly/2dReNtk #SQLServer
Physical Join Operators in SQL Server – Hash Operator: In second part of this series on physical j... bit.ly/2djpzrY #SQLServer
Physical Join Operators in SQL Server – Merge Operator: In Part I of this series on physical join ... bit.ly/2bCjDMc #SQLServer
1
Techniques to Monitor SQL Server memory usage: Memory has a dramatic impact on SQL Server Performa... bit.ly/2b53kXT #SQLServer
Recovering a SQL Server Database from Suspect Mode: A couple of days back at I got a call from my ... bit.ly/2baFlsx #SQLServer
1
Setting Up Data And Log Files For SQL Server: When a database is created in SQL Server it creates ... bit.ly/2aoYUcN #SQLServer
How to Shrink a Database with Column Store Index: DBCC SHRINKDATABASE will fail when it encounters... bit.ly/29b4YSY #SQLServer
SQL Server Hardware Optimization: An important concern in optimizing the hardware platform is hard... bit.ly/2916f2N #SQLServer
Configuring the Maximum Degree of Parallelism: A commonly altered setting is Maximum Degree of Par... bit.ly/28R2z2L #SQLServer
Implementing Database Settings Using Policy Based Management: Introduction Database Administrators... bit.ly/20dM4j8 #SQLServer
Physical Join Operators in SQL Server – Nested Loops: SQL Server implements three different physic... bit.ly/24FEUL6 #SQLServer
Tuning your SQL Query – Generating a Proper Execution Plan.: Recently one of my developers came to ... bit.ly/20Z2GMF #SQLServer
SQL Server T-SQL Performance Tuning – Views: In this installament of the TSQL Performance Tuning se... bit.ly/20tCZ6o #SQLServer
Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective: I once walked into a bar... bit.ly/22cPwjm #SQLServer
12 Essential Steps After Installing SQL Server: Rolling out SQL Servers is a key task for DBAs.  Wh... bit.ly/21w8hdL #SQLServer
1
Monitoring Transactional Replication – The Distribution Queue: Note : The scripts for this article ... bit.ly/1Q7Te2K #SQLServer
TroubleShooting SQL Server Memory Consumption: Recently on one of our staging servers had a memory ... bit.ly/1oo1zbe #SQLServer
SQL Server T-SQL Tuning -TVF and Scalar Functions: In the first of this series we looked at TSQL tu... bit.ly/1Rl0KvE #SQLServer
Primer on Selecting Data Using Entity Framework: This question about selecting data using Entity Fr... bit.ly/1VKa37h #SQLServer
Load more