SQL Archives - Page 257 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Solution – User Not Able to See Any User Created Object in Tables – Security and Permissions Issue

June 19, 2012

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…

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…

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…

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…

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…

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…

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…