July 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQLAuthority News – 9th Year Blog Anniversary

November 1, 2015
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
SQL Milestone
Today is an amazing day! 9 years ago on this day, I started to write this blog. Since then I am producing one blog post a day everyday! During this year there are so many changes have happened in the blog and my professional career as well as on my…
Read More

SQL SERVER – Adding Datetime and Time Values Using Variables

October 30, 2015
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL DateTime
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…
Read More

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

October 29, 2015
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.…
Read More

SQL SERVER – What is Semantics Search Inside SQL Server?

October 28, 2015
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…
Read More

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

October 27, 2015
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…
Read More

SQL SERVER – Taking Backup Without Consuming Disk Space

October 26, 2015
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…
Read More

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

October 25, 2015
Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks
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…
Read More
Previous 1 … 7 8 9 10 11 12 13 … 393 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version