K-MUG organized TechEd Trivandrum on 27th June, 2009. They even launched an official PASS Chapter in Trivandrum. The complete report of this event is here. This event like TechEd in Ahmedabad, was a huge success and saw a huge number of attendees from all over India. Jacob Sebastian and Pinal Dave had presented two solid [...]
Archive for the ‘SQL Tips and Tricks’ Category
SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged TechEd, TechEdIn on July 9, 2009 | 1 Comment »
SQLAuthority News – Book Review – Murach’s SQL Server 2008 for Developers
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLAuthority News, T SQL, Technology on July 8, 2009 | 1 Comment »
Murach’s SQL Server 2008 for Developers (Murach: Training & Reference) (Paperback)
by Bryan Syverson, Joel Murach
Link to Amazon
Short Summary: Murach’s SQL Server 2008 for developers is an ideal book for all developers, and particularly, it is an excellent book for training and reference. If you are new to SQL, no problem! This book is the best [...]
SQLAuthority News – Authors Visit – DotNet Buzz Delhi TechEd Delhi on July 11, 2009
Posted in MVP, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology, tagged TechEd, TechEdIn on July 7, 2009 | 2 Comments »
DotNet Buzz Delhi is organizing TechEd Delhi on July 11, 2009. Not just this, they are launching an official PASS Chapter in Delhi. The Agenda of the event is here and if you are around Delhi do not miss the opportunity to be a part of this upcoming great event. If you are keen to [...]
SQL SERVER – Languages for BI – MDX, DMX, XMLA
Posted in Business Intelligence, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLServer, T SQL, Technology on July 6, 2009 | 2 Comments »
Today, we have a very basic thing to go over. Few days back, I was discussing with one of my friends regarding BI. He told me that he knows that BI stands for Business Intelligence but he would like to know what languages BI uses to achieve the goal. The reason I found this question [...]
SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades
Posted in Pinal Dave, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged HP on July 5, 2009 | Leave a Comment »
Unlike my usual articles today’s article is not at all related to SQL Server but something drove me to include it on my blog. This issue snatched away my precious few hours. It took me over 2 hours to resolve it yesterday, which barred me from doing research on SQL Server. I am sure many [...]
SQL SERVER – Disk Partition Alignment Best Practices
Posted in SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology on July 4, 2009 | Leave a Comment »
Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for [...]
SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Book Review, SQLAuthority News, T SQL, Technology on July 3, 2009 | 1 Comment »
The Rational Guide to Building Technical User Communities (Rational Guides) (Paperback)
by Greg Low
Short Review : A Great, one-of-its-kind book for everybody who is interested in building technical user community. There is no other book written on this subject but after this comprehensive book no further reading will be required.
Link to Amazon
Detailed Review :
This is [...]
SQLAuthority News – MVP Award Renewed
Posted in About Me, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology on July 2, 2009 | 20 Comments »
Year ago, it was a great, perhaps the proudest moment of my professional life. I was awarded Most Valuable Professional (MVP) for SQL Server by Microsoft.
Today, I received an email informing me that I have been re-awarded SQL Server MVP status by Microsoft in recognition of my community contributions. It’s yet another proud moment for [...]
SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Utility, SQLServer, T SQL, Technology on July 1, 2009 | 4 Comments »
Today, we will examine something very simple and very generic that can apply to hordes of programming languages. Let’s take a common question that is frequently discussed – What is difference between Line Feed (\n) and Carriage Return (\r)?
Prior to continuing with this article let us first look into few synonyms for LF and CR.
Line [...]
SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged Policy Management on June 30, 2009 | 1 Comment »
This article will cover the most spectacular feature of SQL 2008 – Policy-based management and how the configuration of SQL Server with policy-based management architecture can make a powerful difference. Policy based management is loaded with several advantages. It can help you implement various policies for reliable configuration of the system. It also provides additional [...]
-
About Pinal Dave
Pinalkumar Dave is Microsoft SQL Server MVP, Solid Quality Mentor and a prominent author of over 1000 SQL Server articles at SQLAuthority. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager specializing in SQL Server Programming with over 7 years of hands-on experience. He holds a degree in Masters of Science and has accomplished a number of certifications including MCDBA and MCAD (.NET). He has also been awarded Regional Mentor for PASS Asia.
-
Blog Stats
- 8,411,127 Readers
-
SQLAuthority Links

My Homepage
My Resume
My Other Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Categories
- About Me (49)
- Best Practices (82)
- Business Intelligence (6)
- Data Warehousing (27)
- Database (257)
- DBA (121)
- DigiCorp (7)
- MVP (81)
- Poll (5)
- Readers Contribution (22)
- Readers Question (28)
- Software Development (62)
- SQL Add-On (88)
- SQL Backup and Restore (48)
- SQL BOL (8)
- SQL Coding Standards (21)
- SQL Constraint and Keys (49)
- SQL Cursor (30)
- SQL Data Storage (36)
- SQL DateTime (36)
- SQL Documentation (193)
- SQL Download (198)
- SQL Error Messages (116)
- SQL Function (104)
- SQL Humor (22)
- SQL Index (82)
- SQL Interview Questions and Answers (54)
- SQL Joins (61)
- SQL Optimization (51)
- SQL Performance (204)
- SQL Puzzle (18)
- SQL Security (115)
- SQL Server DBCC (42)
- SQL Server Management Studio (17)
- SQL Stored Procedure (97)
- SQL String (17)
- SQL System Table (27)
- SQL Trigger (27)
- SQL User Group (41)
- SQL Utility (116)
- SQL White Papers (8)
- SQLAuthority (307)
- SQLAuthority Author Visit (62)
- SQLAuthority Book Review (19)
- SQLAuthority News (277)
- SQLAuthority Website Review (23)
- SQLServer (42)
- Tech (772)
- Pinal Dave (761)
- SQL Scripts (490)
- Technology (1023)
- SQL (1023)
- SQL Authority (1023)
- SQL Query (1023)
- SQL Server (1023)
- SQL Tips and Tricks (1023)
- T SQL (1023)
-
Top Posts
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL Server Interview Questions and Answers Complete List Download
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
- SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - 2005 List All Tables of Database
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL SERVER - TRIM() Function - UDF TRIM()
-
Authors
-
pinaldave
- SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
- SQLAuthority News – Book Review – Murach’s SQL Server 2008 for Developers
- SQLAuthority News – Authors Visit – DotNet Buzz Delhi TechEd Delhi on July 11, 2009
- SQL SERVER – Languages for BI – MDX, DMX, XMLA
- SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades
- SQL SERVER – Disk Partition Alignment Best Practices
- SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
- SQLAuthority News – MVP Award Renewed
- SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
- SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
-
Archives
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Pages
Category Cloud
About Me Best Practices Database DBA MVP Pinal Dave Software Development SQL SQL Add-On SQL Authority SQLAuthority Author Visit SQLAuthority News SQL Documentation SQL Download SQL Error Messages SQL Function SQL Index SQL Interview Questions and Answers SQL Joins SQL Optimization SQL Performance SQL Query SQL Scripts SQL Security SQL Server SQL Stored Procedure SQL Tips and Tricks SQL Utility Technology T SQL


