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

SQL SERVER – Puzzle and Answer – REPLICATE over 8000 Characters

May 13, 2013
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Function
It has been a long time since we have played a puzzle over this blog. This Monday, let us play a quick puzzle. SQL Server have REPLICATE function which will replicate the string passed as many as times as the second parameter. For example execute following string. SELECT 'Ha'+REPLICATE('ha',20) The script…
Read More

SQL SERVER – Caption the Cartoon Contest – Last 2 Days

December 6, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
Developer’s life is very interesting, we often want to start my day early at a job so we can go home early. However, the day never comes as the life of the developer is always about working late hours. If the developer goes to the office early – there are…
Read More

SQL Contest – Win USD 300 Worth Gift – Cartoon Contest is Back

November 29, 2012
Pinal Dave
SQL Puzzle
Embarcadero, SQL Cartoon, SQL Humor, SQL Server

There are two excellent contests and we have lots of winning to do this year end. In this blog post we are going to have a cartoon contest again.

Read More

SQL SERVER – Recover the Accidentally Renamed Table

October 8, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
I have no answer to following question. I saw a desperate email marked as urgent delivered in my mailbox. “I accidentally renamed table in my SSMS. I was scrolling very fast and I made mistakes. It was either because I double clicked or clicked on F2 (shortcut key for renaming).…
Read More

SQL SERVER – Solution – 2 T-SQL Puzzles – Display Star and Shortest Code to Display 1

October 2, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
NuoDB
Earlier on this blog we had asked two puzzles. The response from all of you is nothing but Amazing. I have received 350+ responses. Many are valid and many were indeed something I had not thought about it. I strongly suggest you read all the puzzles and their answers here…
Read More

SQL SERVER – 2 T-SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes

September 20, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
NuoDB
We all love brain teasers and interesting puzzles. Today I decided to come up with 2 interesting puzzles and winner of the contest will get USD 50 worth Amazon Gift Card. The puzzles are sponsored by NuoDB. Additionally, The first 25 individuals who download NuoDB Beta 8 by midnight Friday, Sept.…
Read More

SQL SERVER – Understanding XML – Contest Win Joes 2 Pros Combo (USD 198) – Day 5 of 5

August 10, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
Joes 2 Pros
August 2011 we ran a contest where every day we give away one book for an entire month. The contest had extreme success. Lots of people participated and lots of give away. I have received lots of questions if we are doing something similar this month. Absolutely, instead of running…
Read More
Previous 1 … 8 9 10 11 12 13 14 … 28 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version