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
Sep19

SQL SERVER – 2008 – Interview Questions and Answers Part 8

Pinal Dave
SQL Interview Questions and Answers
Data Warehousing, Database, SQL Data Storage, SQL Function, SQL Index, SQL Scripts, SQL Server DBCC, SQL Utility
19 Comments

SQL Server 2008 Interview Questions and Answers Part 8 starts with Data Compression: how row compression and page compression work and save space.

Continue Reading
Sep18

SQL SERVER – 2008 – Interview Questions and Answers Part 7

Pinal Dave
SQL Interview Questions and Answers
Database, SQL Error Messages, SQL Scripts, SQL Server Security, SQL Utility
4 Comments

SQL Server 2008 Interview Questions and Answers Part 7: how to rewrite sub-queries with joins or a CTE, what CLR is, and more answers with examples.

Continue Reading
Sep17

SQL SERVER – Interview Questions and Answers – Part 6

Pinal Dave
SQL Interview Questions and Answers
Database, SQL Data Storage, SQL DateTime, SQL Function, SQL Index, SQL Scripts, SQL Server, SQL Utility
8 Comments

Part 6 of my SQL Server Interview questions and answers covers SQL Server 2008, starting with what the master, msdb, model, tempdb and resource databases do.

Continue Reading
Sep16

SQL SERVER – 2008 – Interview Questions and Answers Part 5

Pinal Dave
SQL Interview Questions and Answers
Database, SQL Scripts, SQL Stored Procedure, SQL Utility
9 Comments

SQL Server 2008 Interview Questions and Answers Part 5: how to rename a db with sp_renamedb, and a table or a column with sp_rename, with examples.

Continue Reading
Sep15

SQL SERVER – 2008 – Interview Questions and Answers Part 4

Pinal Dave
SQL Interview Questions and Answers
Database, SQL Constraint and Keys, SQL Function, SQL Index, SQL Scripts, SQL Stored Procedure, SQL Utility
15 Comments

SQL Server 2008 Interview Questions and Answers Part 4: which command shows the version of SQL server and operating system, what SQL Server Agent is, and more.

Continue Reading
Sep14

SQL SERVER – 2008 – Interview Questions and Answers Part 3

Pinal Dave
SQL Interview Questions and Answers
Database, SQL Constraint and Keys, SQL Index, SQL Scripts, SQL Utility
17 Comments

SQL Server 2008 Interview Questions and Answers Part 3: which TCP/IP port SQL Server uses, and the difference between a clustered and non-clustered index.

Continue Reading
Sep13

Cursor and Join Questions: SQL Server Interview Answers Part 2

Pinal Dave
SQL Interview Questions and Answers
Data Warehousing, SQL Constraint and Keys, SQL Cursor, SQL Function, SQL Joins
37 Comments

This is part 2 of my SQL Server interview series, with cursor and join questions and seven more. The answers cover collation, functions, subqueries, keys, identity and data warehousing. Each answer is short, with a link to a longer post where one exists.

Continue Reading
Previous 1 … 743 744 745 746 747 748 749 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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 19 books and 125 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 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.

  • Books
  • Testimonials
  • Privacy Policy

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