SQL Archives - Page 232 of 519 - SQL Authority with Pinal Dave

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

January 25, 2013

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

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…

SQL SERVER – How to Use Instead of Trigger

January 24, 2013

Pinal Dave

SQL

SQL Scripts, SQL Server, SQL Trigger

A trigger is an exceptional sort of stored procedure which functions when we try to amend the data in a table like inserting, deleting or updating data. It is a database object, executed automatically and is bound to a table. Fundamentally, triggers are classified into two types mainly-

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

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 – A List of Various SQL Server RTM and Service Pack Number

January 18, 2013

Pinal Dave

SQL

Database, SQL Scripts, SQL Server, SQL Service Pack

A common question I receive is that how do user know which version user is using and what is the latest service pack number available for the product. Here is something at this beginning of the year, check with your production server.