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 - Finding Count of Logical CPU using T-SQL Script - Identify Virtual Processors

SQL SERVER – Finding Count of Logical CPU using T-SQL Script – Identify Virtual Processors

February 4, 2012
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server

A friend needed to count Virtual Processors available to SQL Server 2000. Scripts for 2000 with xp_msver, and for 2005 to 2012 with sys.dm_os_sys_info.

Read More
A butter curler reaches a butter block through one open section of a covered dish

Application Roles: Permissions That Follow the App, Not the User

January 16, 2012
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Application roles sound like a lock only your app can open. This demo shows what the switch really does and why the password is the whole key.

Read More
A tightened rubber expansion plug beside a slender loose spare

Capturing Autogrowth Events With database_file_size_change

January 5, 2012
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

A data file grew over the weekend and nobody owns up. This small demo shows how one extended event tells autogrowth from a manual resize.

Read More
SQL SERVER - A Simple Puzzle and Simple Solution of Datatype and Computed Column

SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column

December 24, 2011
Pinal Dave
SQL Puzzle
SQL Scripts

An interview riddle: create two columns but give a datatype only once, and copy data without UPDATE. A computed column solves it simply.

Read More
SQL SERVER - A Quick Script for Point in Time Recovery - Back Up and Restore

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore

December 23, 2011
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts

A quick script for point in time recovery: set up and back up a database, restore it to a point in time, then clean up. Three simple steps.

Read More
SQL SERVER - A Quick Trick about SQL Server CONCAT function

SQL SERVER – A Quick Trick about SQL Server CONCAT function

December 20, 2011
Pinal Dave
SQL Video
SQL Function, SQL Scripts, SQL Server, SQLAuthority Book Review

A quick trick from a Virtual Tech Days demo: adding a string to GETDATE() throws an error. CAST fixes it, and SQL Server 2012 CONCAT does it more simply.

Read More
An ice cream spade lifts one portion from a full tub beside an empty tub

EXISTS vs COUNT: The Right Way to Check If Rows Exist

December 15, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

Need a yes or no? Ask EXISTS. Need a number? Ask COUNT. Here is a small demo that shows why mixing them up can quietly give the wrong answer.

Read More
Previous 1 … 209 210 211 212 213 214 215 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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