This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Branches of a grapevine connect back to the same main stem on a trellis

What is a Self Join? Explain with Example – Interview Question of the Week #064

March 27, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Joins, SQL Scripts, SQL Server

What is a Self Join? It is a popular interview question for every developer. Here is a simple answer, whether it is inner or outer, and a practical use.

Read More
keycertificates

SQL SERVER – How Enable Transparent Database Encryption (TDE) for Database Mirroring?

March 21, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Mirroring, SQL Scripts, SQL Server, SQL Server Encryption

hey incidentally wanted to enable Transparent Database Encryption (TDE) on their server and wanted me to guide on how to enable.

Read More
A wooden bending jig is adjusted to fit the curvature of a different strip

Interview Question of the Week #063 – How to Recompile Stored Procedure for Specific Table?

March 20, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Stored Procedure

After a big data change in one table, we wanted fresh plans. Here is how to recompile stored procedure plans for a specific table, with a word of caution.

Read More
Gouache painting of a garden bench with one forgotten vermilion umbrella hooked over its backrest

Msg 15559: Script Level Upgrade for master Failed

March 19, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Upgrade, Starting SQL

Msg 15559 says SQL Server cannot drop the ##MS_AgentSigningCertificate## certificate because a user is mapped to it. The upgrade script then fails with error 912 and the service will not start. Start the instance with trace flag 902, drop the mapped user and the upgrade can finish.

Read More
SQL SERVER - Introduction to SQL Azure Database Throttling

SQL SERVER – Introduction to SQL Azure Database Throttling

March 18, 2016
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Scripts, SQL Server

On-premises SQL Server queues extra requests, but Azure works differently. Here is an introduction to SQL Azure Database Throttling and what it means for you.

Read More
Gouache painting: a wooden weaving loom on a craft table, a thick skein of cream yarn at one end fanning out into many neat separate strands across the loom; one strand is vermilion

SQL SERVER 2016 – STRING_SPLIT Function Performance Comparison – Notes from the Field #118

March 17, 2016
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL DateTime, SQL Function, SQL Scripts, SQL Server

Splitting strings once meant temp tables or CROSS APPLY. In Notes from the Field #118, Kathi Kellenberger compares STRING_SPLIT performance in SQL Server 2016.

Read More
Loose planks in a staging bin beside planks held in an orderly slotted rack

Interview Question of the Week #062 – How to Find Table Without Clustered Index (Heap)?

March 13, 2016
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, SQL Constraint and Keys, SQL Scripts, SQL Server

Not every table has a clustered index. Here is a quick script to find each table without a clustered index, also called a Heap, in your database.

Read More
Previous 1 … 152 153 154 155 156 157 158 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com