Blog Home Page - Page 130 of 830 - SQL Authority with Pinal Dave

Oct21

SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform This Operation

Log Shipping, SQL Error Messages, SQL Scripts, SQL Server

They have observed that Log Shipping Copy and Log Shipping Restore jobs have been failing with log shipping error. Let us fix them.

Oct20

Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247

Pinal Dave

SQL Interview Questions and Answers

MariaDB, MySQL, PostgreSQL, SQL Server

Question: Retrieve TOP 10 Rows Without Using TOP or LIMIT? We do not want to use TOP or LIMIT as they are actually not an ANSI implementation.

Oct19

Analyzing SQL Server Query Plans – Pluralsight Online Video Course

Pinal Dave

SQL Video

Execution Plan, SQL Performance

No Comments

I got the opportunity to work on the area of SQL Server Performance Tuning have built a video course on the topic of Analyzing SQL Server Query Plans.

Oct18

SQL SERVER – Turning Off Priority Boost Server Configuration Option on SSMS 18 Onwards

Pinal Dave

SQL Performance

SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Management Studio, SSMS

No Comments

While working together we figured out one of the many issues was the priority boost server configuration. Let us talk about it a bit more in detail.

Oct17

SQL SERVER – Sample Script to Check Index Fragmentation with RowCount

Pinal Dave

SQL Performance

Clustered Index, SQL Index, SQL Scripts, SQL Server

Let us see a script built for one of my clients of Comprehensive Database Performance Health Check to Check Index Fragmentation with RowCount.

Oct16

MariaDB – MySQL – Show Engines to Display All Available and Supported Engine

Pinal Dave

SQL

Engine, MariaDB, MySQL

No Comments

Essentially, they wanted to know command which can Show Engines to Display All Available and Supported Engine in MariaDB.

Oct15

SQL Puzzle – Schema and Table Creation – Answer Without Running Code

Pinal Dave

SQL Puzzle

Schema, SQL Scripts, SQL Server, SQL Table Operation

319

It has been a while we have a puzzle on this blog. Let us have a very simple and interesting puzzle today about Schema and Table Creation.

SQLAuthority News - Database Poll and Gandhinagar SQL Server User Group Launch Today identitybug

SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution

SQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009

SQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009

SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master

SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.

SQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009

SQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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 104 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.

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.