Apr 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
  • Hire Me
  • Health Check

SQL Server – Multiple CTE in One SELECT Statement Query

August 8, 2009
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
CTE, SQL Joins, SQL Scripts
I have previously written many articles on CTE. One question I get often is how to use multiple CTE in one query or multiple CTE in SELECT statement. Let us see quickly two examples for the same. I had done my best to take simplest examples in this subject. Option…
Read More

SQLAuthority News – Humorous SQL Cake – Funny SQL Cake

August 7, 2009
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Humor
I  received the following interesting images in email during the past 2 months. I think they are superbly hilarious! I received them from various people at different times, so their is unknown. Let me know which of the following images you find the most interesting. Hope you enjoyed watching them!…
Read More

SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime

August 6, 2009
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server

I have seen scores of expert developers getting perplexed with SQL Server in finding time only from datetime datatype. Let us have a quick glance look at the solution. Let us learn about how to get Time in Hour:Minute Format from a Datetime as well as to get Date Part Only from Datetime.

Read More

SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server

August 5, 2009
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Stored Procedure, undocumented SQL
When I am not blogging, I am typically working on SQL Server Optimization projects. Time and again, I only have access to SQL Server Management Studio that I can remotely connect to server but do not have access to Operating System, and it works just fine. At one point in…
Read More

SQL SERVER – Forgot the Password of Username SA

August 4, 2009
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Server Security
I just received a call from an old friend with whom I used to work in Las Vegas. He told me about a password-related issue he faced in his organization. They had changed the password of username SA and now they are not able to recall the new password. I…
Read More

SQLAuthority News – Author Visit – Virtual Tech Days August 2009

August 4, 2009
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQLAuthority Author Visit
Microsoft India has organized a premier online technical event Microsoft Virtual TechDays between August 19-21, 2009. I had presented two technical sessions and they were greatly received by audience. I had received 50+ request for providing PPT for all the attendees. It was great FREE event and I suggest that…
Read More

SQL SERVER – Introduction to SQL Server 2008 Profiler – Complete

August 3, 2009
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Profiler
Introduction SQL Server Profiler is a powerful tool that is available with SQL Server since a long time; however, it has mostly been underutilized by DBAs. SQL Server Profiler can perform various significant functions such as tracing what is running under the SQL Server Engine’s hood, and finding out how…
Read More
Previous 1 … 399 400 401 402 403 404 405 … 536 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version