Pages

Saturday, August 31, 2013

SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree | Journey to SQL Authority with Pinal Dave

Many years ago I wrote article SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server where I demonstrated using undocumented Stored Procedure to find the drive letter in local system and available free space. I received question in email from reader asking if there any way he can list directory… Continue Reading...

Source: SQL SERVER – Get Directory Structure using Extended Stored Procedure xp_dirtree | Journey to SQL Authority with Pinal Dave

SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience | Journey to SQL Authority with Pinal Dave

It has been my lifelong dream to be an author, and recently I have seen that goal realized three times.  One of the books I am most proud of is SQL Server Interview Questions and Answers. When I wrote SQL Server Interview Questions and Answers - I had very clear idea what my goals were… Continue Reading...

Source: SQL SERVER – Mastering the Basics – Igniting Learning – A Unique Learning Experience | Journey to SQL Authority with Pinal Dave

SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore | Journey to SQL Authority with Pinal Dave

Blogging is like writing a big novel in parts. It has its own mood and it has its own colors. Someday I feel like writing philosophy and some day I like writing theory and some day just a script. Today is one of the day when I just feel like providing working script for user… Continue Reading...

Source: SQL SERVER – A Quick Script for Point in Time Recovery – Back Up and Restore | Journey to SQL Authority with Pinal Dave

SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column | Journey to SQL Authority with Pinal Dave

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 question, I was asked following… Continue Reading...

Source: SQL SERVER – A Simple Puzzle and Simple Solution of Datatype and Computed Column | Journey to SQL Authority with Pinal Dave

SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users | Journey to SQL Authority with Pinal Dave

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 and asked few questions. As… Continue Reading...

Source: SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users | Journey to SQL Authority with Pinal Dave

SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped | Journey to SQL Authority with Pinal Dave

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 database but every single time… Continue Reading...

Source: SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped | Journey to SQL Authority with Pinal Dave

SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012 | Journey to SQL Authority with Pinal Dave

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 feature indicates. When I started… Continue Reading...

Source: SQL SERVER – Target Recovery Time of a Database – Advance Option in SQL Server 2012 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup | Journey to SQL Authority with Pinal Dave

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 behavior with regards to my… Continue Reading...

Source: SQL SERVER – Effect of Compressed Backup Setting at Server Level on Database Backup | Journey to SQL Authority with Pinal Dave

SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow | Journey to SQL Authority with Pinal Dave

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 if any of you can… Continue Reading...

Source: SQL SERVER – Year End Brain Teaser – Disabled Login and Associated User Without Disabled User Red Arrow | Journey to SQL Authority with Pinal Dave

SQLAuthority News – A Quick History of Writing Three Books in Year 2011 | Journey to SQL Authority with Pinal Dave

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 I write nearly 400+ emails… Continue Reading...

Source: SQLAuthority News – A Quick History of Writing Three Books in Year 2011 | Journey to SQL Authority with Pinal Dave

SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year | Journey to SQL Authority with Pinal Dave

Year 2011 will be my favorite year for long time. I have achieved many personal milestones this year. I will list few things here today, which should keep me inspired next year to do even better. Here is my blog post which I have written for January 1, 2011 SQLAuthority News – Resolution for New… Continue Reading...

Source: SQLAuthority News – An Year Worth Remembering and Looking Forward to Better Next Year | Journey to SQL Authority with Pinal Dave

SQL SERVER – Interview Questions and Answers – Perspectives of an Author | Journey to SQL Authority with Pinal Dave

Today is the first day of year 2012 - Happy New Year!. This blog post is written by my co-author of SQL Server Interview Questions and Answers book Vinod Kumar M. When Pinal Dave and I started our new book – I thought this whole series is very important even if you are not planning… Continue Reading...

Source: SQL SERVER – Interview Questions and Answers – Perspectives of an Author | Journey to SQL Authority with Pinal Dave

SQL SERVER – Importance of ANSI ISOLATION Levels in SQL Server Database – Quiz – Puzzle – 1 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Importance of ANSI ISOLATION Levels in SQL Server Database – Quiz – Puzzle – 1 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. Here is an article which discusses the Author's Perspective. While writing the book, I… Continue Reading...

Source: SQL SERVER – Significance of Various Kinds of Triggers- Quiz – Puzzle – 2 of 31 | Journey to SQL Authority with Pinal Dave

SQLAuthority News – To Err is Human; to Forgive, Divine – Errata of SQL Server Interview Book | Journey to SQL Authority with Pinal Dave

Regular readers of my blog will know that I have written three books this year.  We are currently reviewing readers comments about SQL Server Interview Questions and Answers.  I am sorry to announce that we made a mistake but happy to add that we have corrected it. We will pay closer attention to the error… Continue Reading...

Source: SQLAuthority News – To Err is Human; to Forgive, Divine – Errata of SQL Server Interview Book | Journey to SQL Authority with Pinal Dave

SQL SERVER – Understanding Identity Beyond its Every Increasing Nature – Quiz – Puzzle – 3 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Understanding Identity Beyond its Every Increasing Nature – Quiz – Puzzle – 3 of 31 | Journey to SQL Authority with Pinal Dave

SQLAuthority News – I am Speaking at SQL Saturday 116 – Bangalore, India on January 7, 2012 – First SQL Saturday in India | Journey to SQL Authority with Pinal Dave

SQLSaturday 116 is now only 3 days away. SQL Saturday is FREE event all the attendees and 100% SQL community driven. This is very first SQL Saturday in India and I am very much excited that I will be speaking at this event on my favorite subject of SQL Server Performance Tuning. I have so… Continue Reading...

Source: SQLAuthority News – I am Speaking at SQL Saturday 116 – Bangalore, India on January 7, 2012 – First SQL Saturday in India | Journey to SQL Authority with Pinal Dave

SQL SERVER – An Important Part of Most SELECT statement – WHERE clause – Quiz – Puzzle – 4 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – An Important Part of Most SELECT statement – WHERE clause – Quiz – Puzzle – 4 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Locking and Blocking – Important Aspect of Database and Effect on Performance – Quiz – Puzzle – 5 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Locking and Blocking – Important Aspect of Database and Effect on Performance – Quiz – Puzzle – 5 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Collation and Collation Sensitivity – Quiz – Puzzle – 6 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Collation and Collation Sensitivity – Quiz – Puzzle – 6 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Indexed Views and Restrictions – Quiz – Puzzle – 7 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Using RANKING Functions Instead of SQL Looping Logic of Cursor – Quiz – Puzzle – 8 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Locking, Blocking and Deadlock – Quiz – Puzzle – 9 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Reasons for Using Output Clause – Quiz – Puzzle – 10 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – A Quick Look at expressor Data Quality Solutions | Journey to SQL Authority with Pinal Dave

Last month I described the extension framework that allows one to easily add functionality to an expressor Studio installation.  I then used this added functionality – the input and output operators to SalesForce.com – to develop an example application.  But expressor has a second mechanism that allows you to easily enhance the functionality of your installation –… Continue Reading...

Source: SQL SERVER – A Quick Look at expressor Data Quality Solutions | Journey to SQL Authority with Pinal Dave

SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Non-Clustered Index and Automatic Rebuild – Quiz – Puzzle – 11 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – DACPAC and SQL Azure – Quiz – Puzzle – 12 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Debate – Table Variables vs Temporary Tables – Quiz – Puzzle – 13 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Cases When Stored Procedure RECOMPILE – Quiz – Puzzle – 14 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Using SafePeak to Accelerate Performance of 3rd Party Applications | Journey to SQL Authority with Pinal Dave

An exciting solution I found last year (2011) for SQL Server performance acceleration is SafePeak. Designed to specifically to accelerate and tune performance of cases where you have minimum control on the applications, like 3rd party line of business applications. SafePeak performs automated caching of queries and procedures results, returning with very high speed results… Continue Reading...

Source: SQL SERVER – Using SafePeak to Accelerate Performance of 3rd Party Applications | Journey to SQL Authority with Pinal Dave

SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Difference between CHAR, VARCHAR, NVARCHAR and VARCHAR(MAX) – Quiz – Puzzle – 15 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – CHECKPOINT Behavior and Database Recovery Models – Quiz – Puzzle – 16 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Various Ways to Create Constraints – Quiz – Puzzle – 17 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Various Ways to Create Constraints – Quiz – Puzzle – 17 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Importance of Resource Database – Quiz – Puzzle – 18 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – MERGE or INSERT, UPDATE, DELETE – Quiz – Puzzle – 19 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Difference between Create Index – Drop Index – Rebuild Index – Quiz – Puzzle – 21 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – What is Piecemeal Restore – Quiz – Puzzle – 22 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Database Mirroring and Fine-Prints – Quiz – Puzzle – 23 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Correct Value for Fillfactor – Quiz – Puzzle – 24 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Correct Value for Fillfactor – Quiz – Puzzle – 24 of 31 | Journey to SQL Authority with Pinal Dave

SQL SERVER – Different Aspect of Policy Based Management – Quiz – Puzzle – 25 of 31 | Journey to SQL Authority with Pinal Dave

SQL Server Interview Questions and Answers Print Book Available (207 Pages) | Sample Chapters Year 2011 was a year of learning and opportunity for me. My recent book, SQL Server Interview Questions and Answers, has received such overwhelming love and support from all of you. While writing the book, I had two simple goals: (1) Master the Basics and (2) Ignite Learning. There was… Continue Reading...

Source: SQL SERVER – Different Aspect of Policy Based Management – Quiz – Puzzle – 25 of 31 | Journey to SQL Authority with Pinal Dave

Thursday, August 22, 2013

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh | Journey to SQL Authority with Pinal Dave

I have heard this joke from my friend. I always wanted to write it but I was not able to find the source of the joke. This joke I have located on DavidM's Blog on SQLTeam. It is March 1st and the first day of DBMS school The teacher starts off with a role call..… Continue Reading...

Source: SQL SERVER – SQL Joke, SQL Humor, SQL Laugh | Journey to SQL Authority with Pinal Dave

SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure | Journey to SQL Authority with Pinal Dave

This is quick but interesting trick to display the text of Stored Procedure in the result window. Open SQL Query Analyzer >> Tools >> Customize >> Custom Tab type sp_helptext against Ctrl+3 (or shortcut key of your choice) Press CTRL + T to enable the text view in result window. Type any Stored Procedure name… Continue Reading...

Source: SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure | Journey to SQL Authority with Pinal Dave

SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables | Journey to SQL Authority with Pinal Dave

SQL SERVER 2005 uses ALTER INDEX syntax to reindex database. SQL SERVER 2005 supports DBREINDEX but it will be deprecated in future versions. When any data modification operations (INSERT, UPDATE, or DELETE statements) table fragmentation can occur. DBCC DBREINDEX statement can be used to rebuild all the indexes on all the tables in database. DBCC… Continue Reading...

Source: SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables | Journey to SQL Authority with Pinal Dave

SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case | Journey to SQL Authority with Pinal Dave

Following function will convert any string to Title Case. I have this function for long time. I do not remember that if I wrote it myself or I modified from original source. Run Following T-SQL statement in query analyzer: SELECT dbo.udf_TitleCase('This function will convert this string to title case!') The output will be displayed in… Continue Reading...

Source: SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case | Journey to SQL Authority with Pinal Dave

SQL SERVER – Primary Key Constraints and Unique Key Constraints | Journey to SQL Authority with Pinal Dave

Primary Key: Primary Key enforces uniqueness of the column on which they are defined. Primary Key creates a clustered index on the column. Primary Key does not allow Nulls. Create table with Primary Key: CREATE TABLE Authors ( AuthorID INT NOT NULL PRIMARY KEY, Name VARCHAR(100) NOT NULL ) GO Alter table with Primary Key:… Continue Reading...

Source: SQL SERVER – Primary Key Constraints and Unique Key Constraints | Journey to SQL Authority with Pinal Dave

SQL SERVER – Function to Convert List to Table | Journey to SQL Authority with Pinal Dave

Update : (5/5/2007) I have updated the UDF to support SQL SERVER 2005. Visit :SQL SERVER - UDF - Function to Convert List to Table Reference : Pinal Dave (http://blog.SQLAuthority.com) Continue Reading...

Source: SQL SERVER – Function to Convert List to Table | Journey to SQL Authority with Pinal Dave

SQL SERVER – FIX : Error 15023: User already exists in current database. | Journey to SQL Authority with Pinal Dave

Error 15023: User already exists in current database. 1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login 'Report' GO Run following T-SQL Query in Query Analyzer to associate login with the… Continue Reading...

Source: SQL SERVER – FIX : Error 15023: User already exists in current database. | Journey to SQL Authority with Pinal Dave

SQL SERVER – Creating Comma Separate List From Table | Journey to SQL Authority with Pinal Dave

Update : (5/5/2007) I have updated the script to support SQL SERVER 2005. Visit :SQL SERVER - Creating Comma Separate Values List from Table - UDF - SP Reference : Pinal Dave (http://blog.SQLAuthority.com) Continue Reading...

Source: SQL SERVER – Creating Comma Separate List From Table | Journey to SQL Authority with Pinal Dave

SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007) | Journey to SQL Authority with Pinal Dave

The samples download provides over 100 samples for SQL Server 2005, demonstrating the following components: Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, and XML Analysis Services Integration Services Notification Services Reporting Services Replication The samples databases downloads include the AdventureWorks sample online transaction… Continue Reading...

Source: SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007) | Journey to SQL Authority with Pinal Dave