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 - Top Five Articles of Year 2008

SQL SERVER – Top Five Articles of Year 2008

January 11, 2009
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts

My Top 5 Articles of year 2008 from SQLAuthority.com and pinaldave.com, led by the most visited page: the SQL Server 2008 interview questions and answers list.

Read More
SELECT query error in SQL Server Management Studio.

SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query

January 9, 2009
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Security, SQL Utility, sqlcmd

When a long running query makes SQL Server stop responding, sqlcmd with a Dedicated Administrator Connection lets you connect from another computer and kill it.

Read More
SQL SERVER - Find Currently Running Query - T-SQL

SQL SERVER – Find Currently Running Query – T-SQL

January 7, 2009
Pinal Dave
SQL Performance
SQL Scripts, SQL Server Security

A short script to find a currently running query on your server using sys.dm_exec_requests, plus the KILL command to stop one that runs for too long.

Read More
SQL SERVER - Interesting Observation - Using sqlcmd From SSMS Query Editor

SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor

January 6, 2009
Pinal Dave
SQL Video
SQL Scripts, SQL Server, SQL Utility, sqlcmd

Turn on SQLCMD Mode and the SSMS Query Editor can run sqlcmd scripts that mix OS and SQL commands. The interesting part: the OS commands run first.

Read More
Sqlcmd command window.

SQL SERVER – sqlcmd vs osql – Basic Comparison

January 5, 2009
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Utility, sqlcmd

sqlcmd vs osql: which one should you use to run queries from the command prompt? A short comparison of isql, osql and sqlcmd, and why I pick sqlcmd.

Read More
SQL Server 'WAITFOR' execution context in Visual Studio.

SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction

January 3, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL DateTime, SQL Scripts, SQL Utility

WAITFOR makes a T-SQL batch pause for a set time, or until a clock time, before the next statement runs. I show both uses with small examples.

Read More
SQL SERVER - 2008 - 2005 - Find Longest Running Query - TSQL

SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL

January 2, 2009
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server DBCC, SQL Stored Procedure

My company owner asked which query runs longest and I found no ready script, so I wrote one: the Longest Running Query with its average and maximum time.

Read More
Previous 1 … 292 293 294 295 296 297 298 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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