Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

What is the Difference between TRUNCATE and DELETE in SQL Server? – Interview Question of the Week #118

April 16, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Scripts, SQL Server, SQL Table Operation

Question: What is the Difference between TRUNCATE and DELETE in SQL Server?

Read More

How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117

April 9, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Question: How to Change Owner of Database in SQL SERVER?

Read More

SQL SERVER – Unable to Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types

April 8, 2017
Pinal Dave
SQL
SQL Scripts, SQL Server, SQL Server Cluster, SQL Service Pack

Learning never stops for me with SQL Server. Even though I have written articles to solve many issues, I still get pinged from various clients and I find one new thing every day. In this blog post we will learn how to fix the error related to installing the service pack in the cluster.

Read More

SQL SERVER – Unable to recycle Errorlog – sp_cycle_errorlog – OS error 1392

April 7, 2017
Pinal Dave
SQL
SQL Error Messages, SQL Log, SQL Scripts, SQL Server

One of my clients contacted me and informed that they have a node production clustered server and they recently noticed that the nightly error log had stopped cycling ERRORLOGs. When we attempted to run sp_cycle_errorlog we get the following:

Read More

SQL SERVER – Script to Audit Login and Role Member Change

April 6, 2017
Pinal Dave
SQL
SQL Audit, SQL Login, SQL Scripts, SQL Server

Once there was a security breach on my client machine and they wanted to know who made changes to the SysAdmin role. They contacted me and my first question was that, are you are auditing such changes and as expected answer was No. I gave them answer that nothing can be done as a consultant. They still wanted my suggestion to prevent this in future. So, they want to track if someone does such things in future. Let us see a script to audit login and role member change.

Read More

SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State

April 5, 2017
Pinal Dave
SQL
SQL Backup, SQL Error Messages, SQL Restore, SQL Scripts, SQL Server

I was trying to teach copy-only backups to my students and encountered below error related to differential backup.

Read More

How to Find Median in SQL Server? – Interview Question of the Week #116

April 2, 2017
Pinal Dave
SQL Interview Questions and Answers
Ranking Functions, SQL Scripts, SQL Server

Question: How to Find Median in SQL Server?

Read More
Previous 1 … 122 123 124 125 126 127 128 … 318 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version