SQL Tips and Tricks Archives - Page 199 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Finding Frequently Running Query and Elapsed Time – Notes from the Field #005

December 5, 2013

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a fifth episode of Notes from the Field series. What happens when your server performs badly. The very first reaction is identifying what is running on the server. Once you identify what is running on the server we want to identify two of the most…

SQL SERVER – Scripting Statistics for Read-Only Database and Making it Permanent

December 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Statistics

This is a follow up blog post to my earlier blog posts about statistics for Read-Only Database. Please read the following blog post in this series to get further idea about this subject: SQL SERVER – Statistics for Read-Only Database are in TempDB SQL SERVER – How to Script Statistics…

Weekend Project – Connect your Database and Automatically Generate a Fully Customized Back-office Interface

December 3, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Office

Note: This blog post is based on the backand.com. I accidently landed on this site a few days ago and after browsing a bit around, I found this very interesting. I encourage all of you to feel the same as what I experienced. Just like me you can also connect…

SQL SERVER – Location of Statistics Before and After Database is Marked as a Read-Only

December 2, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Statistics

Earlier last week I wrote a blog post about Statistics for Read-Only Database are in TempDB, I received a very interesting comment from Ayman El-Ghazali on the same blog post. Let me reproduce the same comment over here. “Nice post. What if you create a database, create some statistics in…

SQL SERVER – Download SQL Server 2014 CTP2 and Related Downloads

December 1, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

CTP, SQL Download

SQL Server 2014 CTP2 was announced quite a while ago. I still see very few people working on it or writing about it. There can be many reasons for not attempting to start with SQL Server 2014 but the reality is that it is coming in the next few months…

SQL SERVER – How to Script Statistics from SSMS? – Scripting Statistics is Disabled in SSMS

November 30, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Statistics

Here is a very interesting question, I have received after reading yesterday’s blog post SQL SERVER – Statistics for Read-Only Database are in TempDB. “Pinal, I like your blog post. I recently tried to create statistics with the help of SSMS but I was not successful. Everytime when I go to…

SQL SERVER – Statistics for Read-Only Database are in TempDB

November 29, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Statistics

Here is the question I received when I was explaining about Statistics in SQLLive360 event in Orlando. “As we use database tables and run various queries on SQL Server, it automatically creates statistics and the statistics helps eventually queries to execute efficiently. I also understand that statistics are stored in…