Blog Home Page - Page 337 of 828 - SQL Authority with Pinal Dave

Oct30

Datetime datatype stores date and time part. If you have only date value, You can add time part to a datetime variable using direct literal value and + operator. It is shown below DECLARE @date DATETIME SET @date='2010-10-01' SET @date=@date+'15:00:00' SELECT @date AS DATETIME The result is 2010-10-01 15:00:00.000 But…

Oct29

SQL SERVER – Who is consuming CPU on my SQL Server?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL CPU

The topics around performance tuning is always interesting and I get quizzed by a number of you during conferences on these topic areas post my presentation. A relatively simple yet a powerful question was asked by one of the attendee in my session at MODS (Mobile Developer Conference) this year.…

Oct28

SQL SERVER – What is Semantics Search Inside SQL Server?

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Every now and then I bump into stuffs that I didn’t even hear about when it comes to working with SQL Server. This time I heard the word Semantics Search and was wondering where and when did it come. In this blog, I will put the foundation for this and…

Oct27

SQL SERVER – Script level upgrade for database ‘master’ failed – CREATE SCHEMA failed due to previous errors

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

SQL Server troubleshooting topics seem to be the most searched for in this blog. In continuation to this, blog for today is also inspired with one such error message. Some time back I have written below blog which talks about upgrade script mode of SQL Server: SQL SERVER – Login…

Oct26

SQL SERVER – Taking Backup Without Consuming Disk Space

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Long back, I learned this trick and found an interesting use of it. I totally understand that its very dangerous. Recently I have seen someone getting bitten by this so thought of sharing. Warning: Don’t do this in any production environment The trick here is to take backup on NUL…

Oct25

Interview Question of the Week #042 – How Does SPACE Function Works in SQL Server?

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

No Comments

This question may sound strange but I have personally observed this being asked in one of the interview. Question: How Does SPACE Function Works in SQL Server? Answer: SPACE function accepts one numeric parameter and generates as many as space as a value of the parameter. Observe the output of the…

Oct24

SQL SERVER – Simple Way to Find Existence of Column in a Table

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

If you want to check if the column is already available in the table, you can use system views like sys.columns or INFORMATION_SCHEMA.COLUMNS. Let us create this dataset USE TEMPDB; CREATE TABLE TESTING(ID INT, NAME VARCHAR(100)) Suppose you want to find out the existence of the column named NAME and…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 94 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 an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@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.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER – Adding Datetime and Time Values Using Variables

SQL SERVER – Who is consuming CPU on my SQL Server?

SQL SERVER – What is Semantics Search Inside SQL Server?

SQL SERVER – Script level upgrade for database ‘master’ failed – CREATE SCHEMA failed due to previous errors

SQL SERVER – Taking Backup Without Consuming Disk Space

Interview Question of the Week #042 – How Does SPACE Function Works in SQL Server?

SQL SERVER – Simple Way to Find Existence of Column in a Table