SQL Server Archives - Page 121 of 393 - SQL Authority with Pinal Dave

SQL SERVER – Basic Explanation of SET LOCK_TIMEOUT – How to Not Wait on Locked Query

January 28, 2013

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

In earlier blog post SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query, we learned how we can use NOWAIT query hint to not wait on any locked query and return error. The Query Hint works on query and table level. There is…

SQL SERVER – Weekly Series – Memory Lane – #013

January 26, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – Basic Explanation of Query Hint NOWAIT – How to Not Wait on Locked Query

January 25, 2013

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Query Hint, SQL Lock

Everybody knows about NOLOCK but not everyone knows about NOWAIT. They are different and they have an entire different purpose. In this blog post we will not talk about NOLOCK but we will see how NOWAIT will work. The idea of writing about blog post is based on the question…

SQLAuthority News – Great Experience at SharePoint Conference Singapore 2013

January 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SharePoint

Last week, I had great pleasure to present at SharePoint Conference Singapore . It was my second time visit to this event and I had a great time attending this event. The event had more than 900 attendees and it was moved to bigger and better location since the last time.…

SQL SERVER – Best Practices to Store the SQL Server Backups

January 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Nobody doubts the necessity to create SQL Server backups – I have covered this topic extensively before. The question of where to store the backups however often goes unanswered. I will try to compare some of the most popular options for this task. For demonstration purposes we will use the…

SQLAuthority News – Download Whitepaper – Introducing the BI Semantic Model in Microsoft SQL Server 2012

January 20, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

IT industry has recognized that businesses benefit from a model layer over their data sources. Model layers can deliver high-performance query responses even over extremely large volumes of data, and they can encapsulate business rules and effectively secure access to data. The BI Semantic Model is a single model that…

SQL SERVER – Weekly Series – Memory Lane – #012

January 19, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane