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 – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue

June 19, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Security
There is an old quote “A Picture is Worth a Thousand Words”. I believe this quote immensely. Quite often I get phone calls that something is not working if I can help. My reaction is in most of the cases, I need to know more, send me exact error or…
Read More

SQL SERVER – Identifying Column Data Type of uniqueidentifier without Querying System Tables

June 18, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Server Management Studio
I love interesting conversations with related to SQL Server. One of my friends Madhivanan always comes up with an interesting point of conversation. Here is one of the conversation between us. I am very confident this blog post will for sure enable you with some new knowledge. Madhi: How do…
Read More

SQL SERVER – Read Only Files and SQL Server Management Studio (SSMS)

June 17, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Server Management Studio
Just like any other Developer or DBA SQL Server Management Studio is my favorite application. Any any moment of the time I have multiple instances of the same application are open and I am working on it. Recently, I have come across a very interesting feature in SSMS related to…
Read More

SQL SERVER – Simple Explanation and Puzzle with SOUNDEX Function and DIFFERENCE Function

June 16, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
Earlier this week I asked a question where I asked how to Swap Values of the column without using CASE Statement. Read here: A Puzzle – Swap Value of Column Without Case Statement,there were more than 50 solutions proposed in the comment. There were many creative solutions. I have mentioned my personal…
Read More

SQL SERVER – Free eBook Download – EPUB, MOBI, PDF Format

June 15, 2012
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Documentation
Microsoft has released recently free eBooks on various Microsoft Technology. The best part is that all these books are available in ePub, Mobi and PDF. You can download them to your local machine or eBook reader and read them. This is a great start as many important subjects are now…
Read More

SQL SERVER – Solution of Puzzle – Swap Value of Column Without Case Statement

June 14, 2012
Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Function, SQL Scripts
Earlier this week I asked a question where I asked how to Swap Values of the column without using CASE Statement. Read here: SQL SERVER – A Puzzle – Swap Value of Column Without Case Statement. I have proposed 3 different solutions in the blog posts itself. I had requested the help…
Read More

SQL SERVER – A Quick Look at Logging and Ideas around Logging

June 12, 2012
Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
This blog post is written in response to the T-SQL Tuesday post on Logging. When someone talks about logging, personally I get lots of ideas about it. I have seen logging as a very generic term. Let me ask you this question first before I continue writing about logging. What…
Read More
Previous 1 … 254 255 256 257 258 259 260 … 519 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version