Blog Home Page - Page 444 of 831 - SQL Authority with Pinal Dave

Dec3

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

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…

Dec2

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

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…

Dec1

SQL SERVER – Download SQL Server 2014 CTP2 and Related Downloads

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…

Nov30

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

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…

Nov29

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

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…

Nov28

SQL SERVER – Building Three-Part Name from OBJECT-ID – Database Name, Schema Name, TableName

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Here is the question I recently received based on my earlier blog post – SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME. “How I get three part name if the only thing I have is object_id and current database context. What I mean is that, when I…

Nov27

SQL SERVER – MySQL – Order Column by Nearest Value for Any Integer

Pinal Dave

SQL Tips and Tricks

MySQL, SQL Order By, SQL Scripts

Here is a very interesting question I received, which is based on my MySQL courses. The same script works on SQL Server as well as MySQL. Let us understand how to Order Column by Nearest Value for Any Integer.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 109 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.