Feb 2026 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 – Retrieving Random Rows from Table Using NEWID()

November 16, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Function
I have previously written about how to get random rows from SQL Server. SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader SQL SERVER – Random Number Generator Script – SQL Query However, I have not blogged about following trick…
Read More

SQL SERVER – Concurrency Basics – Guest Post by Vinod Kumar

November 15, 2012
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versions from SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect.…
Read More

SQLAuthority News – Happy Deepavali and Happy New Year

November 13, 2012
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Diwali or Deepavali is popularly known as the festival of lights. It literally means “array of light” or “row of lamps“. Today we build a small clay maps and fill it with oil and light it up. The significance of lighting the lamp is the triumph of good over evil. I work…
Read More

SQL SERVER – Get Free Books on While Learning SQL Server 2012 Error Handling

November 12, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Joes 2 Pros
Fans of this blog are aware that I have recently released my new books SQL Server Functions and SQL Server 2012 Queries. The books are available in market in limited edition but you can avail them for free on Wednesday Nov 14, 2012. Not only they are free but you…
Read More

SQL SERVER – Changing Default Installation Path for SQL Server

November 11, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Management Studio
Earlier I wrote a blog post about SQL SERVER – Move Database Files MDF and LDF to Another Location and in the blog post we discussed how we can change the location of the MDF and LDF files after database is already created. I had mentioned that we will discuss how…
Read More

SQL SERVER – Beginning New Weekly Series – Memory Lane – #002

November 10, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Memory Lane
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite…
Read More

SQLAuthority News – #SQLPASS 2012 Book Signing Photos

November 9, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL PASS, SQLAuthority Author Visit
I am at SQLPASS 2012 and the event is going great. Here are few of the random photos and random news. We had participated in three different book signing event today. SQL Queries 2012 Joes 2 Pros Book 1 Launch and Book Signing SQL 2012 Functions Book Launch at Embarcadero…
Read More
Previous 1 … 237 238 239 240 241 242 243 … 519 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version