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
A gouache inspection bench preserves one cracked ceramic vessel separately from intact vessels beside an inspection lens.

SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution

November 13, 2007
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server DBCC

DBCC CHECKDB checks database consistency. If it reports corruption, I preserve the output and establish the recovery options.

Read More
SQL SERVER - FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB

SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB

November 12, 2007
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts

Msg 5174 says each file size must be greater than or equal to 512 KB, followed by error 1802. The fix is to create a database larger than 512KB.

Read More
SQL SERVER - 2005 2000 - Search String in Stored Procedure

SQL SERVER – 2005 2000 – Search String in Stored Procedure

November 10, 2007
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure

Two scripts to search a string in stored procedure code, one for SQL Server 2000 using syscomments and one for SQL Server 2005, clearly labeled by version.

Read More
SQL SERVER - Disable All Triggers on a Database - Disable All Triggers on All Servers

SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers

October 29, 2007
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Trigger

How to disable all triggers on a database and on the server, which kind of trigger each command touches, and how to turn them back on safely.

Read More
SQL SERVER - 2005 - Get Current User - Get Logged In User

SQL SERVER – 2005 – Get Current User – Get Logged In User

October 27, 2007
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server Security, SQL System Table

How to get current user for a query in SQL Server 2005: SELECT SYSTEM_USER returns the name of the current context, which helps with debugging and security.

Read More
Database Properties.

SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS

October 25, 2007
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Management Studio

Forced parameterization can cut query compilations for busy databases. I explain FORCED vs SIMPLE parameterization and how to set each with T-SQL and SSMS.

Read More
break

SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords

October 24, 2007
Pinal Dave
SQL Tips and Tricks
SQL Cursor, SQL Function, SQL Scripts, SQL Server

I have tried to explain the usage of simple WHILE loop in the first example. BREAK keywords will exit the stop the while loop and control is moved.

Read More
Previous 1 … 326 327 328 329 330 331 332 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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