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
SQL SERVER – How to Start SQL Server Service Without tempdb?

SQL SERVER – How to Start SQL Server Service Without tempdb?

February 23, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB

During a live demo, SQL Server refused to connect after a config change. Here is how to start SQL Server Service without tempdb. Never try this in production.

Read More
SQL SERVER - Scripting Tip: PowerShell to Identify Last Bootup Time

SQL SERVER – Scripting Tip: PowerShell to Identify Last Bootup Time

February 22, 2016
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Scripts, SQL Server

A friend from the networking team asked when his server was last started. Here is a quick PowerShell script to identify the last Bootup Time of a machine.

Read More
SQL SERVER - Starting Up Database - Why Multiple Times in Errorlog?

SQL SERVER – Starting Up Database – Why Multiple Times in Errorlog?

February 20, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Scripts, SQL Server

My instance took unusually long to come up, and the ERRORLOG showed ‘Starting up database’ many times for the same database. Here is why that happens.

Read More
SQL SERVER - View Dependencies on SQL Server: Hard & Soft Way

SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way

February 16, 2016
Pinal Dave
SQL Tips and Tricks
Devart, SQL Constraint and Keys, SQL Scripts, SQL Server, SQL Utility

Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.

Read More
SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group

SQL SERVER – Huge Transaction Log (LDF) for Database in Availability Group

February 12, 2016
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, Transaction Log

A reader’s database in an AlwaysOn availability group grew a Huge Transaction Log of 230 GB with error 9002, AVAILABILITY_REPLICA. Here is what to check.

Read More
SQL SERVER 2016: Creating Simple Temporal Table

SQL SERVER 2016: Creating Simple Temporal Table

February 10, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server 2016, SQL Utility, Temporal Table

Want to see what your data looked like on a past date? Here is how to create a simple Temporal Table in SQL Server 2016, with its history table made for you.

Read More
A railway semaphore signals when a stretch of track can proceed

Interview Question of the Week #057 – What is GO Statement in SQL SERVER?

February 7, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server

Learn what the GO statement really does in SQL Server, why a variable vanishes after it, and the simple rules every script writer should know.

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

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