SQL Tips and Tricks Archives - Page 286 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – A Quick History of Writing Three Books in Year 2011

December 30, 2011

Personal, SQL, SQL Server, SQL Tips and Tricks

This has been an eventful year for me. I write in various formats online and offline but becoming a published author of printed book was always my dream. Every day I write continuously. Here are few of the writing tasks I do in my everyday routine. I write – Emails…

SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow

December 29, 2011

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks

I have received lots of good responses to the puzzles, quizzes and brain teasers posted on this blog post. As the year is ending, I have decided to give two interesting puzzles for you. The first one is easy and the second one is equally uncomplicated, but let us see…

SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup

December 28, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

I recently received following question from reader. I would like to share the complete story in few short sentences with you to give you complete idea. Let us call the reader Margie. Our long email conversation is converted into chat like conversation Margie: Hi Pinal – I am seeing strange…

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012

December 27, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Function

Recently I was going over few advanced options of SQL Server 2012 in database properties and I found a new option in the property screen. Properties screen of SQL Server 2008 R2 Properties screen of SQL Server 2012 I got little curious and decided to learn what does this new…

SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

December 26, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Last day I had excellent fun asking puzzle on SQL Server Login SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users. One of the user sent me email asking urgent question about how to resolve following error. Reader was trying to remove the login from…

SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users

December 25, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

First of all Merry Christmas and Happy Holidays to everybody. I wish you best holiday season. In today’s blog post – I am sharing very small question received by one of the reader. Though simple sometime a small question make people think. He sent me very similar to following image…

SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column

December 24, 2011

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Scripts

Christmas is just near and happy holidays to all of you. Today is Christmas eve and I decided to share something very simple but interesting with you. Recently some one reading my SQL Server Interview Questions and Answers book asked me following question. “Pinal, Instead of puzzle, or difficult interview…