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

SQL SERVER – Introduction to GUIDs – SQL Queries 2012 Joes 2 Pros Volume 3 – Advanced Query Tools and Techniques for SQL Server 2012

March 27, 2013

This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 3. Book On Amazon | Book On Flipkart Kit on Amazon | Kit on Flipkart Why buy this Book: We often learn good practices from the people that come before us. Sometimes we later learn why those practices make sense.…

SQL SERVER – Query Writing Strategy – SQL Queries 2012 Joes 2 Pros Volume 1 – The SQL Queries 2012 Hands-On Tutorial for Beginners

March 25, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Joes 2 Pros

This chapter is abstract from the Beginning SQL 2012 – Joes 2 Pros Volume 1. Book On Amazon | Book On Flipkart Kit on Amazon | Kit on Flipkart Why Buy this Book: Weather you are a tester, developer, or administrator of SQL there are some basic terms and skill they are…

SQLAuthority News – Whitepaper – Plan Caching and Recompilation in SQL Server 2012

March 24, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL White Papers

Plan Caching and Recompilation in SQL Server 2012 Whitepaper has been my favorite paper for a long time. Plan caching and recompilation are two of the best concepts which are explained in depth by my favorite author Greg Low. I have met Greg several times and I have been a big fan…

SQL SERVER – Weekly Series – Memory Lane – #021

March 23, 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 – Fix – Error: 1060 The number of rows provided for a TOP or FETCH clauses row count parameter must be an integer

March 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Here is the interesting error one of my friend faced and it took me 15 minutes go over various code to identify the real issue. When we see a simple example in demonstration or a blog, we often think that SQL is a much simpler language and it looks easy.…

SQL SERVER – Identify Last User Access of Table using T-SQL Script

March 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Scripts

During the TechEd India 2013 presentations I received a question how to identify when any table is accessed by any of the user. It seems people would like to know if the table was used in any part of query by any user. The best possible solution is to create…

SQL SERVER – TechEd India 2013 Sessions and Relevent Pluralsight Courses

March 19, 2013

Pinal Dave

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

Pluralsight, SQL Index

I am presenting at TechEd India 2013 two SQL Server session. You can read about my session in this blog post. Yesterday I presented on topic SQL Server Performance Troubleshooting: Ancient Problems and Modern Solutions. Today I will be presenting on the subject Indexes – The Unsung Hero. If you are at…