Skip to content
  • Facebook
  • GitHub
  • YouTube
  • Pinterest
My Tec Bits
  • Home
  • Microsoft
    • .Net
      • ASP.NET
      • MVC
      • Visual Studio
    • IIS
    • SQL Server
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012
      • SQL Server 2008
    • Windows OS
  • Web Development
    • Java Script
    • Jquery
    • Python
    • Bootstrap
    • Zurb Foundation
    • Web Security
  • More
    • macOS
    • Reviews
  • Online Tools
    • Fitness Calculators
    • Encoders & Decoders
    • Cryptography
    • Unit Converters
    • Math. Calculators
    • Date & Time Calculators
    • Finance Calculators

SQL

SP_WHO and SP_WHO2

Jul 31, 2019Jun 5, 2013 by Beaulin Twinkle

SP_WHO and SP_WHO2 – Brief description about Microsoft system stored procedures SP_WHO and SP_WHO2. SP_WHO vs SP_WHO2 which one to use when.

Categories SQL Server Tags Performance, SQL Leave a comment

Using isnull in where clause is expensive in SQL Server

Aug 18, 2018May 26, 2012 by Beaulin Twinkle
My-Tec-Bits

Using isnull in where clause is expensive in SQL Server. How to avoid useing isnull? Simple way to use case instead of isnull in where clause.

Categories SQL Server Tags Performance, SQL 3 Comments
Newer posts
← Previous Page1 … Page7 Page8

Article Categories

  • Android (2)
  • Apple (22)
    • macOS (22)
  • Internet & Web Dev. (149)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (7)
    • Python (80)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (3)
  • Microsoft (303)
    • .Net (66)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (213)
    • Windows (24)
  • Networks And Distributed Systems (2)
  • Oracle (7)
    • Java (2)
    • Oracle Database (5)
  • Others (6)
  • Reviews (10)

Recent Articles

  • How to delete a file or folder in Python? Sep 21, 2023
  • How to create a directory, and any missing parent directories in Python? Sep 20, 2023
  • How to exit from single-user mode in SQL Server database? Sep 14, 2023
  • How to group by datetime column without considering time? Aug 31, 2023
  • What Is Django Used For and Why Do We Use The Django Framework? Aug 29, 2023
  • Returning multiple values from a function in Python Aug 10, 2023
  • How to decode ASCII to text in C#? Aug 3, 2023
  • How to encode a string to ASCII in C#? Jul 19, 2023
  • Advantages and disadvantages of cursors in SQL Server Jul 15, 2023
  • What is hosts file and how to use it to override DNS? Jul 5, 2023

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators
  • Date & Time Calculators
  • Finance Calculators

Popular Articles

  • How To Get Day Of Week In SQL Server?
  • SQL Server: Concatenate Multiple Rows Into Single String
  • Error: 'SqlConnection' could not be found in the namespace (Solved)
  • Where is SQL Server Configuration Manager?
  • How to compare contents of two files in Visual Studio Code?
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. Learn more...
  • Home
  • About Us
  • Contact Us
  • Site Map
  • Terms Of Use
  • Privacy Policy
© 2012 - 2023 My Tec Bits. All Rights Reserved.