• Home
  • Resume
  • All Articles
  • SQL Interview Q & A
  • Contact Me

Journey to SQL Authority with Pinal Dave

Notes of a SQL Server MVP and Database Administrator

Feeds:
Posts
Comments

All Articles

1136 Oct 28, 2009 SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008
1135 Oct 27, 2009 SQL SERVER – How to Enable Index – How to Disable Index – Incorrect syntax near ‘ENABLE’
1134 Oct 26, 2009 SQL SERVER – Advanced T-SQL with Itzik Ben-Gan – A Dream Coming True
1133 Oct 25, 2009 SQLAuthority News – Best Practices for Integration Services Configurations
1132 Oct 24, 2009 SQL SERVER – Link to SQL Server Book Online – BOL
1131 Oct 23, 2009 SQLAuthority News – PASS Sessions – I will be there!
1130 Oct 22, 2009 SQL SERVER – Difference Between Candidate Keys and Primary Key
1129 Oct 21, 2009 SQL SERVER – Introduction to Business Intelligence – Important Terms & Definitions
1128 Oct 20, 2009 SQLAuthority News – PASS 2009 Sessions on Query Optimization and Performance Tuning
1127 Oct 19, 2009 SQL SERVER – Change Collation of Database Column – T-SQL Script – Consolidating Collations – Extention Script
1126 Oct 18, 2009 SQLAuthority News – Whitepaper – Auditing in SQL Server 2008
1125 Oct 17, 2009 SQLAuthority News – Happy Diwali and New Year
1124 Oct 16, 2009 SQL SERVER – Recently Executed T-SQL Query
1123 Oct 15, 2009 SQL SERVER – Enable Automatic Statistic Update on Database
1122 Oct 14, 2009 SQLAuthority News – First Editorial – T-SQL Challenges Beginners
1121 Oct 13, 2009 SQL SERVER – Comic Slow Query – SQL Joke
1120 Oct 12, 2009 SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3
1119 Oct 11, 2009 SQLAuthority News – Accessing SQL Server Databases with PHP
1118 Oct 10, 2009 SQL SERVER – Download Logical Query Processing Poster
1117 Oct 09, 2009 SQL SERVER – Queries Waiting for Memory Allocation to Execute
1116 Oct 08, 2009 SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2
1115 Oct 07, 2009 SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup
1114 Oct 06, 2009 SQL SERVER – Interesting Observation – Query Hint – FORCE ORDER
1113 Oct 05, 2009 SQLAuthority News – Community TechDays in Ahmedabad – A Successful Event
1112 Oct 04, 2009 SQL SERVER – Choose Right Edition of SQL Server Express for Your Application
1111 Oct 03, 2009 SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition
1110 Oct 02, 2009 SQLAuthority News – SQL Server 2008 – The Other Side of Index – Live Presentation in Ahmedabad
1109 Oct 01, 2009 SQL SERVER – SQL Server Management Studio and Client Statistics
1108 Sep 30, 2009 SQLAuthority News – Community Tech Days – Oct 3, 2009 – SQL Server 2008 – The Other Side of Index
1107 Sep 29, 2009 SQL SERVER – Interesting Observation – Execution Plan and Results of Aggregate Concatenation Queries
1106 Sep 28, 2009 SQLAuthority News – Download IIS Database Manager
1105 Sep 27, 2009 SQLAuthority News – FILESTREAM Storage in SQL Server 2008
1104 Sep 26, 2009 SQLAuthority News – FIX : An error occurred while executing this command. If this error persists, please contact your Live Meeting administrator.
1103 Sep 25, 2009 SQL SERVER – Outer Join in Indexed View – Question to Readers
1102 Sep 24, 2009 SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query
1101 Sep 23, 2009 SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function
1100 Sep 22, 2009 SQLAuthority News – Article 1100 and Community Service
1099 Sep 21, 2009 SQL SERVER – Intorduction to Service Broker and Sample Script
1098 Sep 20, 2009 SQL SERVER – Execution Plan and Results of Aggregate Concatenation Queries Depend Upon Expression Location
1097 Sep 19, 2009 SQLAuthority News – SQL Server Accelerator for Business Intelligence (BI)
1096 Sep 18, 2009 SQLAuthority News – Community Tech Days Oct 3, 2009 – Ahmedabad
1095 Sep 17, 2009 SQL SERVER – Converting Stored Procedure into Table Valued Function
1094 Sep 16, 2009 SQLAuthority News – Download Microsoft SQL Server StreamInsight CTP2
1093 Sep 15, 2009 SQL SERVER – Cryptography in SQL Server 2008
1092 Sep 14, 2009 SQL SERVER – Plan Caching and Schema Change – An Interesting Observation
1091 Sep 13, 2009 SQL SERVER – Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet
1090 Sep 12, 2009 SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.2
1089 Sep 11, 2009 SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2009- Seattle
1088 Sep 10, 2009 SQL SERVER – SQL Server Desktop Screen Background
1087 Sep 09, 2009 SQL SERVER – Difference between SQL Server Express and MySQL
1086 Sep 08, 2009 SQLAuthority News – Shaivi Dave – Baby SQLAuthority
1085 Sep 07, 2009 SQL SERVER – Importance of Database Schemas in SQL Server
1084 Sep 06, 2009 SQL SERVER – Find Gaps in The Sequence
1083 Sep 05, 2009 SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)
1082 Sep 04, 2009 SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
1081 Sep 03, 2009 SQL SERVER – What is Data Mining – A Simple Introductory Note
1080 Sep 02, 2009 SQL SERVER – Mirrored Backup and Restore and Split File Backup
1079 Sep 01, 2009 SQL SERVER – Download Script of Change Data Capture (CDC)
1078 Sep 01, 2009 SQLAuthority News – Baby SQLAuthority is here!
1077 Aug 31, 2009 SQLAuthority News – Effect of Oracle acquiring MySQL – A Delayed Analysis
1076 Aug 30, 2009 SQLAuthority News – Application and Multi-Server Management
1075 Aug 29, 2009 SQL SERVER – Plan Caching in SQL Server 2008 by Greg Low
1074 Aug 28, 2009 SQL SERVER – Best Practices – Implementation of Database Object Schemas
1073 Aug 27, 2009 SQL SERVER – Introduction to SQL Azure
1072 Aug 26, 2009 SQL SERVER – SQL Server Express – A Complete Reference Guide
1071 Aug 25, 2009 SQLAuthority News – Business Intelligence Training Roadshow August September 2009
1070 Aug 24, 2009 SQL SERVER – Index Seek vs. Index Scan – Diffefence and Usage – A Simple Note
1069 Aug 23, 2009 SQLAuthority News – SQL Server 2008 Migration White Papers
1068 Aug 22, 2009 SQLAuthority News – Microsoft SQL Server 2008 Books Online
1067 Aug 21, 2009 SQL SERVER – Get Query Plan Along with Query Text and Execution Count
1066 Aug 20, 2009 SQL SERVER – FIX : ERROR : Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
1065 Aug 19, 2009 SQLAuthority News – Two Virtual Tech Days Sessions – Watch it Online
1064 Aug 18, 2009 SQLAuthority News – Beyond Relational Interview on SQL Server 2008 Beyond Relational
1063 Aug 17, 2009 SQL SERVER – Measure CPU Pressure – CPU Business
1062 Aug 16, 2009 SQLAuthority News – Evaluate the Microsoft SQL Server 2008 R2 August Community Technology Preview (CTP)
1061 Aug 15, 2009 SQL SERVER – Introduction to Change Data Capture (CDC) in SQL Server 2008
1060 Aug 14, 2009 SQLAuthority News – USB Drive Fails to Copy Large File
1059 Aug 13, 2009 SQL SERVER – Reason for SQL Server Agent Starting Before SQL Server Engine Service
1058 Aug 12, 2009 SQL SERVER – Backup master Database Interval – master Database Best Practices
1057 Aug 11, 2009 SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario
1056 Aug 10, 2009 SQLAuthority News – A Quick Guide to Twitter
1055 Aug 09, 2009 SQLAuthority News – Interview with SQL Server MVP Glenn Berry
1054 Aug 08, 2009 SQL Server – Multiple CTE in One SELECT Statement Query
1053 Aug 07, 2009 SQLAuthority News – Humorous SQL Cake – Funny SQL Cake
1052 Aug 06, 2009 SQL SERVER – Get Time in Hour:Minute Format from a Datetime – Get Date Part Only from Datetime
1051 Aug 05, 2009 SQL SERVER – Get a List of Fixed Hard Drive and Free Space on Server
1050 Aug 04, 2009 SQL SERVER – Forgot the Password of Username SA
1049 Aug 04, 2009 SQLAuthority News – Author Visit – Virtual Tech Days August 2009
1048 Aug 03, 2009 SQL SERVER – Introduction to SQL Server 2008 Profiler
1047 Aug 02, 2009 SQLAuthority News – Proposed eGov Standards Policy – Benefit for All or Only A Chosen Few
1046 Aug 01, 2009 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
1045 Jul 31, 2009 SQL SERVER – Introduction to Cloud Computing
1044 Jul 30, 2009 SQLAuthority News – Author’s Birthday – Top 7 Commenters – Volunteers
1043 Jul 29, 2009 SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table
1042 Jul 28, 2009 SQL SERVER – 2008 – Design Process Decision Flow
1041 Jul 27, 2009 SQL SERVER – List All Missing Identity Values of Table in Database
1040 Jul 26, 2009 SQLAuthority News – Search SQL Server Solutions
1039 Jul 25, 2009 SQLAuthority News – Download – Cumulative Update Package for SQL Server 2008
1038 Jul 24, 2009 SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen
1037 Jul 23, 2009 SQL SERVER – Puzzle – Write Script to Generate Primary Key and Foreign Key
1036 Jul 22, 2009 SQLAuthority News – SQL Server Value Calculator
1035 Jul 21, 2009 SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing
1034 Jul 20, 2009 SQLAuthority News – Authors Visit – DelhiBuzz TechEd on July 11, 2009
1033 Jul 19, 2009 SQL SERVER – Get Last Running Query Based on SPID
1032 Jul 18, 2009 SQLAuthority News – Whitepaper – Using the Resource Governor
1031 Jul 17, 2009 SQL SERVER – Two Methods to Retrieve List of Primary Keys and Foreign Keys of Database
1030 Jul 16, 2009 SQL SERVER – Four Different Ways to Find Recovery Model for Database
1029 Jul 15, 2009 SQL SERVER – Restore Sequence and Understanding NORECOVERY and RECOVERY
1028 Jul 14, 2009 SQL SERVER – Backup Timeline and Understanding of Database Restore Process in Full Recovery Model
1027 Jul 13, 2009 SQL SERVER – BLOB – Pointer to Image, Image in Database, FILESTREAM Storage
1026 Jul 12, 2009 SQLAuthority News – Big Thinkers – Robert Cain
1025 Jul 11, 2009 SQL SERVER – Standby Servers and Types of Standby Servers
1024 Jul 10, 2009 SQLAuthority News – Request SQLAuthority.com Stickers and SQL Server Cheat Sheet
1023 Jul 09, 2009 SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
1022 Jul 08, 2009 SQLAuthority News – Book Review – Murach’s SQL Server 2008 for Developers
1021 Jul 07, 2009 SQLAuthority News – Authors Visit – DotNet Buzz Delhi TechEd Delhi on July 11, 2009
1020 Jul 06, 2009 SQL SERVER – Languages for BI – MDX, DMX, XMLA
1019 Jul 05, 2009 SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades
1018 Jul 04, 2009 SQL SERVER – Disk Partition Alignment Best Practices
1017 Jul 03, 2009 SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
1016 Jul 02, 2009 SQLAuthority News – MVP Award Renewed
1015 Jul 01, 2009 SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
1014 Jun 30, 2009 SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
1013 Jun 29, 2009 SQL SERVER – Maximum Number of Index per Table
1012 Jun 28, 2009 SQL SERVER – 2008 – Management Studio New Features
1011 Jun 27, 2009 SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
1010 Jun 26, 2009 SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
1009 Jun 25, 2009 SQLAuthority News – Authors Visit – K-MUG TechEd Trivandrum on June 27, 2009
1008 Jun 24, 2009 SQLAuthority News – Update on pinaldave.com and SQLAuthority.com
1007 Jun 23, 2009 SQL SERVER – 2005 – 2008 – Delete Duplicate Rows
1006 Jun 22, 2009 SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success
1005 Jun 21, 2009 SQLAuthority News – Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1
1004 Jun 20, 2009 SQL Server – Understanding Table Hints with Examples
1003 Jun 19, 2009 SQL SERVER – Why You Should Attend PASS Summit Unite 2009- Seattle
1002 Jun 18, 2009 SQL SERVER – Clustered Index on Separate Drive From Table Location
1001 Jun 17, 2009 SQL SERVER – List Schema Name and Table Name for Database
1000 Jun 16, 2009 SQLAuthority News – 1000th Article Milestone – 8 Millions Views – Solid Quality Mentors
999 Jun 15, 2009 SQL SERVER – Query Optimizer Hint ROBUST PLAN – Question to You
998 Jun 14, 2009 SQL SERVER – 2008 – SSMS Feature – Multi-server Queries
997 Jun 13, 2009 SQL SERVER – Effect of Normalization on Index and Performance
996 Jun 12, 2009 SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
995 Jun 11, 2009 SQLAuthority News – Registration and Competition – TechEd on Road – Ahmedabad – June 20, 2009 Saturday
994 Jun 10, 2009 SQL SERVER – Performance Counters from System Views – By Kevin Mckenna
993 Jun 09, 2009 SQLAuthority News – TechEd On Road Ahmedabad, India is Announced – June 20, 2009 Saturday
992 Jun 08, 2009 SQL SERVER – Fix : Error: 15372 Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance. The connection will be closed

991 Jun 07, 2009 SQLAuthority News – Using SQL Server 2008 Extended Events – White paper By Jonathan Kehayias
990 Jun 06, 2009 SQL SERVER – Order of Hotfix and Service Pack
989 Jun 05, 2009 SQLAuthority News – Rambling of Author and Technology Musing – Bing, Google, Windows 7, Books, Blogs, Twitter and Life
988 Jun 04, 2009 SQL SERVER – What is Interim Table – Simple Definition of Interim Table
987 Jun 03, 2009 SQL SERVER – Connect Item – Vote for Feature Request Function TRIM
986 Jun 02, 2009 SQLAuthority News – Summary of TechEd India 2009 – A Grand Event
985 Jun 01, 2009 SQL SERVER – List All Objects Created on All Filegroups in Database
984 May 31, 2009 SQL SERVER – Create Multiple Filegroup For Single Database
983 May 30, 2009 SQL SERVER – Difference Between Candidate Keys and Primary Key
982 May 29, 2009 SQLAuthority News – Blog Makeover – New Banner – New Color
981 May 28, 2009 SQL SERVER – Fix : Error : SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall t

980 May 27, 2009 SQL SERVER – Interesting Observation of Logon Trigger On All Servers
979 May 26, 2009 SQL SERVER – Find Hostname and Current Logged In User Name
978 May 25, 2009 SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (May 2009)
977 May 24, 2009 SQL SERVER – Introduction to Business Intelligence – Important Terms and Definitions
976 May 23, 2009 SQLAuthority News – SQL Server Energy Event with Rushabh Mehta – May 20, 2009
975 May 22, 2009 SQLAuthority News – Download – SQL Server 2008 Developer Training Kit
974 May 21, 2009 SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
973 May 20, 2009 SQL Server – Download PDF SQL Server Cheat Sheet
972 May 19, 2009 SQLAuthority News – SQL Server Energy Event – Mark Your Calendar – May 20, 2009
971 May 18, 2009 SQL SERVER – Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped an

970 May 17, 2009 SQLAuthority News – Gandhinagar SQL Server User Group Meeting – International Speaker Visiting
969 May 17, 2009 SQL SERVER – How to Drop Temp Table – Check Existence of Temp Table
968 May 16, 2009 SQLAuthority News – TechEd India 2009 – Day 3 – Product Group Meeting – Final Presentations – Meeting Friends
967 May 15, 2009 SQLAuthority News – TechEd India 2009 – Day 2 – In-Person Meeting with Industry Leaders – Community Party
966 May 14, 2009 SQLAuthority News – TechEd India 2009 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Meeting Great People
965 May 13, 2009 SQLAuthority News – TechEd India 2009 – Day 0 – Day 1 – Authors Tech Session – SQL Server Cheat Sheet – Catch Me Live
964 May 12, 2009 SQLAuthority News – Release of SQL Server 2008 R2 Announced
963 May 12, 2009 SQL SERVER – How to Drop Primary Key Contraint
962 May 11, 2009 SQL SERVER – Questions and Answers with Database Administrators
961 May 10, 2009 SQL SERVER – 10 Reasons for Database Outsourcing
960 May 09, 2009 SQL SERVER – Find Last Date Time Updated for Any Table
959 May 08, 2009 SQLAuthority News – Future of Business Intelligence and Databases – Article by Nupur Dave
958 May 07, 2009 SQL SERVER – FIX : Error : Windows Update; Error Code 8000FFFF
957 May 06, 2009 SQLAuthority News – Book Review – SQL Server 2008 Management and Administration by Ross Mistry
956 May 05, 2009 SQLAuthority News – Author Visit – TechEd India 2009 – Hyderabad
955 May 04, 2009 SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
954 May 03, 2009 SQL SERVER – Add or Remove Identity Property on Column
953 May 02, 2009 SQL SERVER – Example of DDL, DML, DCL and TCL Commands
952 May 01, 2009 SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
951 Apr 30, 2009 SQL SERVER – FIX : ERROR : is not a valid Win32 application. (Exception from HRESULT: 0×800700C1)
950 Apr 29, 2009 SQL SERVER – Solution to Puzzle – Shortest Code to Perform SSN Validation
949 Apr 28, 2009 SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial with Script
948 Apr 27, 2009 SQLAuthority News – Starting the SQL Journey – How Did I Get Started With SQL?
947 Apr 26, 2009 SQL SERVER – List All the Tables for All Databases Using System Tables
946 Apr 25, 2009 SQLAuthority News – Interview of Author on 60 Seconds with Pinal Dave
945 Apr 24, 2009 SQL SERVER – Leading Zero to Number
944 Apr 24, 2009 SQL SERVER – Introduction to SQL Server 2008 Profiler
943 Apr 23, 2009 SQLAuthority News – Gandhinagar SQL Server User Group Meeting April 24, 2009
942 Apr 23, 2009 SQL SERVER – FIX : Error: 18486 Login failed for user ’sa’ because the account is currently locked out. The system administrator can unlock it. – Unlock SA Login
941 Apr 22, 2009 SQL SERVER – Difference Between SQL Server Compact Edition (CE) and SQL Server Express Edition
940 Apr 21, 2009 SQL SERVER – What is Cloud Computing – Introduction to Cloud Computing
939 Apr 20, 2009 SQLAuthority Book Review – Pro T-SQL 2008 Programmer’s Guide by Michael Coles
938 Apr 19, 2009 SQL SERVER – Fix : SQL Server 2008 Developer Edition Install fail due to .NET Framework 3.5 missing
937 Apr 18, 2009 SQLAuthority News – Troubleshooting Performance Problems in SQL Server 2008
936 Apr 17, 2009 SQLAuthority News – Authors Website Redesigned – http://www.pinaldave.com – Feedback Requested
935 Apr 16, 2009 SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD
934 Apr 15, 2009 SQL SERVER – Poll Result – What is Your Favorite Database?
933 Apr 14, 2009 SQL SERVER – Check if Current Login is Part of Server Role Member
932 Apr 13, 2009 SQL SERVER – Introduction to JOINs – Basic of JOINs
931 Apr 12, 2009 SQL SERVER – FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)
930 Apr 11, 2009 SQL SERVER – Interesting Observation of DMV of Active Transactions and DMV of Current Transactions
929 Apr 10, 2009 SQL SERVER – Restore or Attach Database Without .NDF or .MDF is Not Possible
928 Apr 10, 2009 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
927 Apr 10, 2009 SQLAuthority News – Download SQL Server 2005 Report Packs – SQL Server Sample Reports – Report Templates
926 Apr 09, 2009 SQL SERVER – Fix : Error : Msg 9803, Level 16. Invalid data for type “numeric” – Data Type Mapping for Oracle Publishers
925 Apr 08, 2009 SQL SERVER – Maximum Columns per Primary Key – Fix : Error : Msg 1904, Level 16, The index on table has column names in index key list. The maximum limit

924 Apr 08, 2009 SQLAuthority News – SQL Server 2008 Service Pack 1 Released – Available for Download
923 Apr 07, 2009 SQL SERVER – Server Type and File Extention
922 Apr 06, 2009 SQL SERVER – Logical Query Processing Phases – Order of Statement Execution
921 Apr 05, 2009 SQL SERVER – 2008 – Management Studio New Features
920 Apr 05, 2009 SQL SERVER – Mirrored Backup and Restore and Split File Backup
919 Apr 04, 2009 SQL SERVER – Automated Index Defragmentation Script
918 Apr 03, 2009 SQLAuthority News – Launch of Gandhinagar SQL Server User Group
917 Apr 02, 2009 SQL SERVER – Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP
916 Apr 01, 2009 SQL SERVER – Reseed Identity of Table – Table Missing Identity Values – Gap in Identity Column
915 Mar 31, 2009 SQL SERVER – 2008 – IntelliSense Does Not Work – Enable IntelliSense
914 Mar 30, 2009 SQLAuthority News – Top 10 Strategic Technologies for 2009
913 Mar 29, 2009 SQL SERVER – Fix : Error : Msg 2714, Level 16, State 6 – There is already an object named ‘#temp’ in the database
912 Mar 28, 2009 SQLAuthority News – SQL SERVER 2008 – Updated Brochure Available for Download
911 Mar 27, 2009 SQLAuthority News – Database Poll and Gandhinagar SQL Server User Group Launch Today
910 Mar 27, 2009 SQLAuthority News – Author Video Interview Published Online – Microsoft MVP Summit 2009
909 Mar 26, 2009 SQL SERVER – FIX : Error: Msg 15123, Level 16 – The configuration option ‘advance option’ does not exist, or it may be an advanced option.
908 Mar 26, 2009 SQL SERVER – Fix : Error : Msg 4621, Level 16, State 10 : Permissions at the server scope can only be granted when the current database is master
907 Mar 25, 2009 SQLAuthority News – Announcement – Gandhinagar SQL Server User Group – March 27, 2009
906 Mar 25, 2009 SQLAuthority News – Ahmedabad SQL Server User Group Meeting Review – March 21, 2009
905 Mar 24, 2009 SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution
904 Mar 23, 2009 SQL SERVER – 2008 – Location of Activity Monitor – Where is SQL Serve Activity Monitor Located
903 Mar 22, 2009 SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users
902 Mar 21, 2009 SQL SERVER – 2008 – Optimize for Ad hoc Workloads – Advance Performance Optimization
901 Mar 20, 2009 SQL SERVER – AWE (Address Windowing Extensions) Explained in Simple Words
900 Mar 19, 2009 SQLAuthority News – 900th Article – 9 Best Practices – Important Milestones
899 Mar 18, 2009 SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network
898 Mar 17, 2009 SQL SERVER – Practical SQL Server XML: Part One – Query Plan Cache and Cost of Operations in the Cache
897 Mar 16, 2009 SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display
896 Mar 15, 2009 SQL SERVER – Interesting Observation of ON Clause on LEFT JOIN – How ON Clause Effects Resultset in LEFT JOIN
895 Mar 14, 2009 SQLAuthority News – Lots of SQL Server News – Tip of the Article
894 Mar 13, 2009 SQL SERVER – Profiler – Adding Filters – Observation on CPU Load
893 Mar 12, 2009 SQL SERVER – What is Your Favorite Database? – Poll Continuous
892 Mar 11, 2009 SQL SERVER – Difference Between Union vs. Union All – Optimal Performance Comparison
891 Mar 10, 2009 SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display
890 Mar 09, 2009 SQLAuthority News – Author Visit – Complete Wrapup of Microsoft MVP Summit 2009 Trip
889 Mar 08, 2009 SQLAuthority News – Author Visit – South Asian MVPs at Global MVP Summit 2009
888 Mar 07, 2009 SQLAuthority News – Author Visit – Tech User Group Meeting, Markham, Canada and Toronto CA Solutions
887 Mar 06, 2009 SQLAuthority News – Author Visit – Toronto, Canada – Insert Image in Database
886 Mar 05, 2009 SQLAuthority News – MVP Summit 2009 – Day 4 – Keynote of Steve Ballmer
885 Mar 04, 2009 SQLAuthority News – MVP Summit 2009 – Day 3 – Party Day and SQL Celebrity Photos
884 Mar 03, 2009 SQLAuthority News – MVP Summit 2009 – Day 2 – Most Contributing MVP of Year
883 Mar 02, 2009 SQLAuthority News – MVP Summit 2009 – Day 1 – Summit Welcome and Keynotes
882 Mar 01, 2009 SQLAuthority News – MVP Summit 2009 – Day 0 – About Pinal Dave
881 Feb 28, 2009 SQLAuthority News – MVP Summit 2009 – Database Industry Discussion – Live From London Airport and Sheraton Seattle
880 Feb 27, 2009 SQLAuthority News – MVP Summit 2009 – Journey Begins
879 Feb 26, 2009 SQL SERVER – 2008 – Find Relationship of Foreign Key and Primary Key using T-SQL – Find Tables With Foreign Key Constraint in Database
878 Feb 25, 2009 The Poll – What is Your Favorite Database?
877 Feb 24, 2009 SQLAuthority News – Author Visit – MVP Global Summit 2009 – Seattle and Redmond
876 Feb 24, 2009 SQL SERVER – Disable Windows Authentication – Remove Windows Authentication Login Account
875 Feb 23, 2009 SQLAuthority News – Ahmedabad User Group Meeting February 21 2009
874 Feb 22, 2009 SQL SERVER – Download – Microsoft SQL Server 2008 Management Studio Express
873 Feb 21, 2009 SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index
872 Feb 20, 2009 SQLAuthority News – Ahmedabad User Group Meeting February 21 2009
871 Feb 19, 2009 SQL SERVER – Enable and Disable Index Non Clustered Indexes Using T-SQL
870 Feb 18, 2009 SQLAuthority Author Visit – A True Outsourcing Giant and Technology Leader DigiCorp in Ahmedabad India
869 Feb 17, 2009 SQL SERVER – Find Current Location of Data and Log File of All the Database
868 Feb 16, 2009 SQL SERVER – List All Server Wide Configurations Values
867 Feb 15, 2009 SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup
866 Feb 14, 2009 SQL SERVER – Restore Master Database – An Easy Solution
865 Feb 13, 2009 SQL SERVER – Simple Example of Reading XML File Using T-SQL
864 Feb 12, 2009 SQL SERVER – Simple Example of Creating XML File Using T-SQL
863 Feb 11, 2009 SQL SERVER – Technical Articles – Performance Optimizations for the XML Data Type in SQL Server 2005
862 Feb 10, 2009 SQL SERVER – Start SQL Server Instance in Single User Mode
861 Feb 09, 2009 SQL SERVER – 2008 – Download Microsoft SQL Server 2008 Express with Tools Free
860 Feb 08, 2009 SQL SERVER – Introduction to Force Index Query Hints – Index Hint – Part2
859 Feb 07, 2009 SQL SERVER – Introduction to Force Index Query Hints – Index Hint
858 Feb 06, 2009 SQL SERVER – Quickest Way to – Kill All Threads – Kill All User Session – Kill All Processes
857 Feb 05, 2009 SQLAuthority News – Two Promotion to Help Community
856 Feb 04, 2009 SQL SERVER – Observation – Effect of Clustered Index over Nonclustered Index
855 Feb 03, 2009 SQLAuthority News – Download SQL Server 2008 System Views Poster – PDF – A Wall Poster
854 Feb 02, 2009 SQL SERVER – T-SQL Script for FizzBuzz Logic
853 Feb 01, 2009 SQLAuthority News – Download Microsoft SQL Server 2008 Books Online (January 2009)
852 Jan 31, 2009 SQL SERVER – FIX : ERROR : Msg 5834, Level 16, State 1, Line 1 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option

851 Jan 30, 2009 SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor
850 Jan 29, 2009 SQLAuthority News – Microsoft Certification Exam – Discount Code – Free Second Chance – MCTS, MCITP, MCPD
849 Jan 28, 2009 SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader
848 Jan 27, 2009 SQLAuthority News – Download Cumulative update package 3 for SQL Server 2008
847 Jan 27, 2009 SQLAuthority News – Download Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview
846 Jan 26, 2009 SQLAuthority News – Happy 60th Republic Day to India – Database Tip
845 Jan 25, 2009 SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation
844 Jan 24, 2009 SQLAuthority News – Download Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
843 Jan 23, 2009 SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2
842 Jan 22, 2009 SQLAuthority News – Milestone of 6 Million Visits – 60 Lak Visits – Search and Job
841 Jan 21, 2009 SQLAuthority News – SQLAuthority News – Ahmedabad User Group Meeting January 17 2009 – Review
840 Jan 20, 2009 SQL SERVER – Rules for Optimizining Any Query – Best Practices for Query Optimization
839 Jan 19, 2009 SQLAuthority News – CWE/SANS TOP 25 Most Dangerous Programming Errors
838 Jan 18, 2009 SQL SERVER – Difference Between Index Scan and Index Seek
837 Jan 17, 2009 SQLAuthority News – Download Microsoft SQL Server Protocol Documentation
836 Jan 16, 2009 SQLAuthority News – Ahmedabad User Group Meeting January 17 2009
835 Jan 15, 2009 SQL SERVER – Remove Duplicate Entry from Comma Delimited String – UDF
834 Jan 14, 2009 SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation
833 Jan 13, 2009 SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL
832 Jan 12, 2009 SQLAuthority News – Humor – Favorite Website – Funny Image
831 Jan 11, 2009 SQL SERVER – Top Five Articles of Year 2008
830 Jan 10, 2009 SQLAuthority News – Security White Papers
829 Jan 09, 2009 SQL SERVER – sqlcmd – Using a Dedicated Administrator Connection to Kill Currently Running Query
828 Jan 08, 2009 SQLAuthority News – Author Visit – Mumbai, India – From January 8, 2008 to January 11, 2008
827 Jan 07, 2009 SQL SERVER – Find Currently Running Query – T-SQL
826 Jan 06, 2009 SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor
825 Jan 05, 2009 SQL SERVER – sqlcmd vs osql – Basic Comparison
824 Jan 04, 2009 SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor
823 Jan 03, 2009 SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction
822 Jan 02, 2009 SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL
821 Jan 01, 2009 SQLAuthority News – Happy New Year – 5 SQL New Year Resolutions
820 Dec 31, 2008 SQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life
819 Dec 30, 2008 SQLAuthority Author Visit Report – Tech Meetings – Recession – Job Market – Consolidation of Servers – OS Choice – Server Reboots – Performance Optimization – Backup and Restore</s

818 Dec 29, 2008 SQL SERVER – 2008 – Certification Path Complete Download PDF
817 Dec 28, 2008 SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission
816 Dec 27, 2008 SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles
815 Dec 26, 2008 SQL SERVER – Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ’sa’, because it does not exist or you do not have permission
814 Dec 25, 2008 SQLAuthority Author Visit – Valsad, Daman, Silvassa, Vapi – Tech Meetings
813 Dec 25, 2008 SQLAuthority News – Merry Christmas – Search SQLAuthority
812 Dec 24, 2008 SQL SERVER – DISABLE and ENABLE user SA
811 Dec 23, 2008 SQL SERVER – 2008 – Download Copy of Developer Edition for Free Is Myth
810 Dec 22, 2008 SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL
809 Dec 21, 2008 SQLAuthority News – SQL Server Related Downloads from Microsoft
808 Dec 20, 2008 SQL SERVER – Change Collation of Database Column – T-SQL Script
807 Dec 19, 2008 SQLAuthority News – Download – SQL Server 2005 Books Online (December 2008)
806 Dec 18, 2008 SQLAuthority News – Download Microsoft SQL Server 2005 Service Pack 3
805 Dec 17, 2008 SQL SERVER – Interesting Interview Questions – Revisited
804 Dec 16, 2008 SQL SERVER – Find Collation of Database and Table Column Using T-SQL
803 Dec 15, 2008 SQLAuthority News – Wedding Day of Author – Photographs – Mr. and Mrs. SQLAuthority
802 Dec 14, 2008 SQL SERVER – Connect using Enterprise Manager to SQL Server 2005/2008
801 Dec 13, 2008 SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle
800 Dec 12, 2008 SQLAuthority News – Wedding Day of Author – 800th Article of Blog
799 Dec 11, 2008 SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle – Solution
798 Dec 11, 2008 SQLAuthority News – SQL SERVER 2008 Upgrade Technical Reference Guide Download
797 Dec 10, 2008 SQL SERVER 2008 – Top 10 SQL Server 2008 Features for Independent Software Vendor Applications
796 Dec 10, 2008 SQL SERVER – Interesting Interview Questions – Part 2 – Puzzle
795 Dec 09, 2008 SQL SERVER – Find Table Rowcount Without Using T-SQL and Without Opening Table
794 Dec 08, 2008 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
793 Dec 08, 2008 SQLAuthority News – Author Photographs Updated
792 Dec 07, 2008 SQL SERVER – Interesting Interview Questions
791 Dec 06, 2008 SQLAuthority News – 10 Days After Attack on India
790 Dec 05, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
789 Dec 04, 2008 SQL SERVER – Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals / Developers
788 Dec 03, 2008 SQL SERVER – Default Collation of SQL Server 2008
787 Dec 02, 2008 SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial
786 Dec 01, 2008 SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications
785 Nov 30, 2008 SQL SERVER – Interesting Observation – Use of Index and Execution Plan
784 Nov 29, 2008 SQLAuthority News – Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
783 Nov 28, 2008 SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut
782 Nov 27, 2008 SQLAuthority News – Download Tools and Documentation for SQL SERVER
781 Nov 26, 2008 SQLAuthority News – Help to Find Recession Proof Job
780 Nov 25, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008
779 Nov 24, 2008 SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY
778 Nov 23, 2008 SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2008
777 Nov 22, 2008 SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database Including Schema
776 Nov 21, 2008 SQLAuthority News – SQL Server White Paper: SQL Server 2008 Compliance Guide
775 Nov 20, 2008 SQL SERVER – Simple Use of Cursor to Print All Stored Procedures of Database
774 Nov 19, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
773 Nov 18, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 3
772 Nov 17, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 2
771 Nov 16, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 1
770 Nov 15, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Link List
769 Nov 14, 2008 SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa
768 Nov 13, 2008 SQLAuthority News – RML Utilities – Usage and Additional Help
767 Nov 12, 2008 SQLAuthority News – Download RML Utilities for SQL Server
766 Nov 11, 2008 SQL SERVER – Delete Backup History – Cleanup Backup History
765 Nov 10, 2008 SQL SERVER – Check Database Integrity for All Databases of Server
764 Nov 09, 2008 SQLAuthority News – SQL Server 2008 Book Online Updated in October 2008
763 Nov 08, 2008 SQL SERVER 2008 – Connect Visual Studio 2005 Patch Download
762 Nov 07, 2008 SQL SERVER – Refresh Database Using T-SQL
761 Nov 06, 2008 SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server
760 Nov 05, 2008 SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio
759 Nov 04, 2008 SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user
758 Nov 03, 2008 SQLAuthority News – SQL Server Security Whitepapers
757 Nov 02, 2008 SQL SERVER – Fix : Error : Login failed for user ‘UserName’. The user is not associated with a trusted SQL Server connection
756 Nov 01, 2008 SQL SERVER – Stored Procedure WITH ENCRYPTION and Execution Plan
755 Oct 31, 2008 SQL SERVER – DECLARE Multiple Variables in One Statement
754 Oct 30, 2008 SQLAuthority News – Download Microsoft SQL Server Management Pack for Operations Manager 2007
753 Oct 29, 2008 SQLAuthority News – Download SQL Server 2005 Service Pack 3 – CTP
752 Oct 28, 2008 SQLAuthority News – Happy Diwali to All of You
751 Oct 27, 2008 SQLAuthority News – Download Microsoft SQL Server 2008 Feature Pack, October 2008
750 Oct 26, 2008 SQLAuthority News – Definition – Outsourcing, Offshoring, Nearshoring, Offshore Outsourcing
749 Oct 25, 2008 SQL SERVER – Simulate INNER JOIN using LEFT JOIN statement – Performance Analysis
748 Oct 24, 2008 SQLAuthority News – TOP Downloads – Bookmark
747 Oct 23, 2008 Author Visit – MVP Open Day 2008 – Goa – November 15-17
746 Oct 22, 2008 SQLAuthority News – Running SQL Server 2008 in a Hyper-V Environment Best Practices and Performance Considerations
745 Oct 21, 2008 SQL SERVER – Fix : Error : Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable thi

744 Oct 20, 2008 SQL SERVER – Transaction and Local Variables – Swap Variables – Update All At Once Concept
743 Oct 19, 2008 SQL SERVER – Introduction to CLR – Simple Example of CLR Stored Procedure
742 Oct 18, 2008 SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice – Part 2
741 Oct 17, 2008 SQL SERVER – Get Common Records From Two Tables Without Using Join
740 Oct 17, 2008 SQLAuthority News – Ahmedabad SQL Server User Group Meeting – October 2008
739 Oct 16, 2008 SQL SERVER – Downgrade Database to Previous Version
738 Oct 15, 2008 SQL SERVER – Introduction and Example of UNION and UNION ALL
737 Oct 14, 2008 SQL SERVER – Get Numeric Value From Alpha Numeric String – UDF for Get Numeric Numbers Only
736 Oct 13, 2008 SQLAuthority News – Book Review – Pro SQL Server 2005 Replication (Definitive Guide)
735 Oct 12, 2008 SQLAuthority News – SQL Injection – SQL Joke, SQL Humor, SQL Laugh
734 Oct 11, 2008 SQLAuthority News – Download – Microsoft SQL Server 2008 Feature Pack, August 2008
733 Oct 10, 2008 SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
732 Oct 09, 2008 SQL SERVER – 2008 – TRIM() Function – User Defined Function
731 Oct 08, 2008 SQLAuthority News – SQL Server 2008 – Microsoft Certifications for 70-432 70-433 70-450 70-452
730 Oct 07, 2008 SQL SERVER – 2008 – High Resolution Wallpaper and Screen Saver
729 Oct 07, 2008 SQLAuthority News – Author Visit – SQL Hour at Patni Computer Systems
728 Oct 06, 2008 SQLAuthority News – Upgrade SQL Server With SA Renamed – Rebuild System Databases – SQL Server 2008
727 Oct 05, 2008 SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported – VS SP1 ISO Download
726 Oct 04, 2008 SQLAuthority News – Cumulative update package 1 for SQL Server 2008
725 Oct 03, 2008 SQL SERVER – 2008 – Find If Index is Being Used in Database
724 Oct 03, 2008 SQLAuthority News – Download – Visual Studio Team System 2008 Database Edition GDR September CTP
723 Oct 02, 2008 SQLAuthority News – Download – Microsoft SQL Server 2008 Books Online (August 2008)
722 Oct 02, 2008 SQL Server – 2008 – Cheat Sheet – One Page PDF Download
721 Oct 01, 2008 SQL SERVER – Example of PIVOT UNPIVOT Cross Tab Query in Different SQL Server Versions
720 Sep 30, 2008 SQLAuthority News – Security Update for SQL Server 2005 Service Pack 2
719 Sep 29, 2008 SQL SERVER – Puzzle – Solution – Computed Columns Datatype Explanation
718 Sep 28, 2008 SQL SERVER – Renaming SP is Not Good Idea – Renaming Stored Procedure Does Not Update sys.procedures
717 Sep 27, 2008 SQL SERVER – Puzzle – Computed Columns Datatype Explanation
716 Sep 26, 2008 SQL SERVER – Get Answer in Float When Dividing of Two Integer
715 Sep 25, 2008 SQL SERVER – Guidelines and Coding Standards Complete List Download
714 Sep 24, 2008 SQL SERVER – Guidelines and Coding Standards Part – 2
713 Sep 23, 2008 SQL SERVER – Guidelines and Coding Standards Part – 1
712 Sep 22, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – September 2008
711 Sep 21, 2008 SQL SERVER – 2008 – Fix Connection Error with Visual Studio 2008 – Server Version is not supported
710 Sep 20, 2008 SQLAuthority Author Visit – Ahmedabad User Group Meeting September 2008
709 Sep 20, 2008 SQL SERVER – 2008 – Interview Questions and Answers Complete List Download
708 Sep 19, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 8
707 Sep 18, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 7
706 Sep 17, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 6
705 Sep 16, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 5
704 Sep 15, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 4
703 Sep 14, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 3
702 Sep 13, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 2
701 Sep 12, 2008 SQL SERVER – 2008 – Interview Questions and Answers – Part 1
700 Sep 11, 2008 SQLAuthority News – 700 Articles and Author Updates
699 Sep 10, 2008 SQLAuthority News – SharePoint – Steps To Create A Custom WebPart – Deploy It SharePoint Site
698 Sep 09, 2008 SQL Server – Error : Fix : SharePoint Stop Working After Changing Server (Computer) Name
697 Sep 08, 2008 SQL SERVER – 2008 – Creating Primary Key, Foreign Key and Default Constraint
696 Sep 07, 2008 SQL SERVER – Explanation about Usage of Unique Index and Unique Constraint
695 Sep 06, 2008 SQL SERVER – Find Primary Key Using SQL Server Management Studio
694 Sep 05, 2008 SQL SERVER – 2008 – Creating Full Text Catalog and Full Text Search
693 Sep 05, 2008 SQLAuthority News – Download SQL Server Related Products
692 Sep 04, 2008 SQLAuthirty Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008
691 Sep 03, 2008 SQLAuthority Author Visit – Microsoft Student Partner Conference
690 Sep 02, 2008 SQL SERVER – 2008 – Hardware and Software Requirements for Installing SQL Server 2008
689 Sep 01, 2008 SQL SERVER – 2008 – Introduction to Filtered Index – Improve performance with Filtered Index
688 Aug 31, 2008 SQL SERVER – 2008 – Introduction to Table-Valued Parameters with Example
687 Aug 30, 2008 SQL SERVER – FIX : ERROR : Could Not Connect to SQL Server – TDSSNIClient initialization failed with error 0×7e, status code 0×60
686 Aug 29, 2008 SQL SERVER – Few Useful DateTime Functions to Find Specific Dates
685 Aug 28, 2008 SQL SERVER – 2008 – Introduction to Merge Statement – One Statement for INSERT, UPDATE, DELETE
684 Aug 27, 2008 SQLAuthority News – Download SQL Server 2008 Report Builder 2.0 RC1
683 Aug 27, 2008 SQLAuthority News – SQL Server Express 2008 Downloads
682 Aug 26, 2008 SQL SERVER – How to Rename a Column Name or Table Name
681 Aug 25, 2008 SQLAuthority News – Ahmedabad SQL Server User Group Meeting – August 2008
680 Aug 25, 2008 SQLAuthority News – 4 Million Visits – over 675 SQL Server Articles
679 Aug 24, 2008 SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server – Fix Connection Problems of SQL Server
678 Aug 23, 2008 SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database
677 Aug 22, 2008 SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case – Part 2
676 Aug 21, 2008 SQL SERVER – Behind the Scene of SQL Server Activity of – Transaction Log – Shrinking Log
675 Aug 21, 2008 SQLAuthority News – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005
674 Aug 20, 2008 SQLAuthority News – Find Your IP Address – What Is My IP Address
673 Aug 19, 2008 SQL SERVER – Disable All the Trigger of Current Database
672 Aug 18, 2008 SQL SERVER – Detailed Explanation of Transaction Lock, Lock Type, Avoid Locks
671 Aug 17, 2008 SQL SERVER – 2005 – Best Practices Analyzer (August 2008)
670 Aug 17, 2008 SQL SERVER – XML – Split a Delimited String – Generate a Delimited String
669 Aug 16, 2008 SQLAuthority News – Tip of the Minute
668 Aug 15, 2008 SQLAuthority News – Happy Indepedance Day to India
667 Aug 15, 2008 SQL SERVER – 2008 – Introduction to Online Indexing Operation
666 Aug 14, 2008 SQL SERVER – Get Date Time in Any Format – UDF – User Defined Functions
665 Aug 13, 2008 SQLAuthority News – Authors Personal Website Renovate – SQL Centric Website
664 Aug 12, 2008 SQLAuthority News – SQL Server 2008 Pricing and Licensing
663 Aug 12, 2008 SQLAuthority News – Microsoft SQL Server 2008 Books Online – BOL – English
662 Aug 11, 2008 SQLAuthority News – SQL Server 2008 Downloads Availables
661 Aug 10, 2008 SQL SERVER – 2008 – Download and Install Samples Database AdventureWorks 2005 – Detail Tutorial
660 Aug 09, 2008 SQL SERVER – Fix : Error : 1326 Cannot connect to Database Server Error: 40 – Could not open a connection to SQL Server
659 Aug 08, 2008 SQLAuthority News – Security Update for SQL Server 2000 Service Pack 4 and MSDE 2000
658 Aug 08, 2008 SQL SERVER – 2008 – Released To Manufacturing Available
657 Aug 07, 2008 SQL SERVER – EXCEPT Clause in SQL Server is Similar to MINUS Clause in Oracle
656 Aug 06, 2008 SQL SERVER – Query to Find Column From All Tables of Database
655 Aug 05, 2008 SQL SERVER – 2005 – Get Field Name and Type of Database Table
654 Aug 04, 2008 SQLAuthority News – SQLAuthority Site With New Banner
653 Aug 03, 2008 SQL SERVER – 2005 – Difference Between INTERSECT and INNER JOIN – INTERSECT vs. INNER JOIN
652 Aug 02, 2008 SQL SERVER – Effect of Order of Join In Query
651 Aug 01, 2008 SQL SERVER – 2008 – Get Current System Date Time
650 Jul 31, 2008 SQL SERVER – 2008 – Find Current System Date Time and Time Offset
649 Jul 30, 2008 SQLAuthority News – Author BirthDay – SQL Server Birthday
648 Jul 29, 2008 SQL SERVER – SQL SERVER – Simple Example of Recursive CTE – Part 2 – MAXRECURSION – Prevent CTE Infinite Loop
647 Jul 28, 2008 SQL SERVER – Simple Example of Recursive CTE
646 Jul 27, 2008 SQL SERVER – mssqlsystemresource – Resource Database
645 Jul 26, 2008 SQLAuthority News – Readers Selection – Readers Most Favorite Articles
644 Jul 25, 2008 SQLAuthority News – SQLAuthority T-Shirts, Mug, Hat and Other Product
643 Jul 25, 2008 SQL SERVER – DBCC SHRINKFILE Takes Long Time to Run
642 Jul 24, 2008 SQL SERVER – 2005 -Track Down Active Transactions Using T-SQL
641 Jul 23, 2008 SQL SERVER – Introduction to Log Viewer
640 Jul 22, 2008 SQL SERVER – Clear SQL Server Memory Caches
639 Jul 21, 2008 SQL SERVER – FIX – ERROR : 9004 An error occurred while processing the log for database. If possible, restore from backup. If a backup is not available, it mi

638 Jul 21, 2008 SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – July 19 2008
637 Jul 20, 2008 SQL SERVER – Change the Port of Service Broker Configuration
636 Jul 19, 2008 SQL Server – Fix – Error : 9692 The _MSG protocol transport cannot listen on port because it is in use by another process.
635 Jul 18, 2008 SQL SERVER – Introduction to Service Broker
634 Jul 18, 2008 SQLAuthority News – Updated My Personal Book Mark Pages
633 Jul 17, 2008 SQLAuthority News – Ahmedabad SQL Server Usergroup Meeting
632 Jul 16, 2008 SQL SERVER – Readers Contribution to Site – Simple Example of Cursor
631 Jul 15, 2008 SQL SERVER – Deferred Name Resolution
630 Jul 14, 2008 SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2
629 Jul 13, 2008 SQL SERVER – SP_CONFIGURE – Displays or Changes Global Configuration Settings
628 Jul 12, 2008 SQL SERVER – 2008 – User Account – sa or sysadmin
627 Jul 11, 2008 SQL SERVER – 2005 – Two Important Security Update
626 Jul 10, 2008 SQL SERVER – 2008 – Introduction to SPARSE Columns
625 Jul 09, 2008 SQL SERVER – 2008 – Two Convenient Features Inline Assignment – Inline Operations
624 Jul 08, 2008 SQL SERVER – Find Space Used For Any Particular Table
623 Jul 07, 2008 SQLAuthority News – Thank You to Awarding Author SQL MVP
622 Jul 06, 2008 SQL SERVER – 2008 – Introduction to Row Compression
621 Jul 05, 2008 SQL SERVER – Difference Between Database Mail and SQLMail
620 Jul 04, 2008 SQL SERVER – Deprecated DataType vardecimal
619 Jul 03, 2008 SQL SERVER – 2008 – Introduction to New Feature of Backup Compression
618 Jul 02, 2008 SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
617 Jul 01, 2008 SQLAuthority News – Microsoft Most Valuable Professional Award for SQL Server – MVP
616 Jun 30, 2008 SQL SERVER – 2008 – High Availability – Hot Add Memory
615 Jun 29, 2008 SQLAuthority News – Rise in SQL Injection Attacks Exploiting Unverified User Data Input
614 Jun 28, 2008 SQL SERVER – 2008 – High Availability – Hot Add CPU
613 Jun 27, 2008 SQL SERVER – Difference Between DBMS and RDBMS
612 Jun 26, 2008 SQLAuthority News – Famous Quotes From Bill Gates – Part 2
611 Jun 25, 2008 SQLAuthority Download – SQL Server Cheatsheet
610 Jun 24, 2008 SQLAuthority News – Microsoft Source Code Analyzer for SQL Injection
609 Jun 23, 2008 SQLAuthority News – Release Notes for SQL Server 2008 Release Candidate 0
608 Jun 22, 2008 SQL SERVER – Create Check Constraint on Column
607 Jun 21, 2008 SQLAuthority News – White Paper: Security Overview for Database Administrators
606 Jun 20, 2008 SQL SERVER – Find Current Identity of Table
605 Jun 19, 2008 SQLAuthority News – White Paper: SQL Server 2008 Compared to Oracle Database 11g
604 Jun 18, 2008 SQLAuthority News – Famous Quotes From Bill Gates
603 Jun 17, 2008 SQL SERVER – 2008 – SQL Server Start Time
602 Jun 16, 2008 SQL SERVER – Introduction to SERVERPROPERTY and example
601 Jun 15, 2008 SQL SERVER – 2008 – Inline Variable Assignment
600 Jun 14, 2008 SQLAuthority News – 600 Article and Over 3 Million Readers
599 Jun 13, 2008 SQL SERVER – 2008 – Introduction to Policy Management – Enforcing Rules on SQL Server
598 Jun 12, 2008 SQL SERVER – 2008 – Step By Step Installation Guide With Images
597 Jun 11, 2008 SQL SERVER – 2008 – Four Key Pillars
596 Jun 10, 2008 SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies
595 Jun 09, 2008 SQLAuthority News – SQL Server 2008 Release Candidate 0
594 Jun 08, 2008 SQL SERVER – Order of Conditions in WHERE Clauses
593 Jun 07, 2008 SQL SERVER – PIVOT and UNPIVOT Table Examples
592 Jun 06, 2008 SQLAuthority News – Search SQLAuthority – Get Email On Every Article
591 Jun 05, 2008 SQL SERVER – 2008 – Compound Assignment Operators
590 Jun 04, 2008 SQL SERVER – Create a Comma Delimited List Using SELECT Clause From Table Column
589 Jun 03, 2008 SQL SERVER – Example of DISTINCT in Aggregate Functions
588 Jun 02, 2008 SQL SERVER – Order Of Column In Index
587 Jun 01, 2008 SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 4
586 May 31, 2008 SQL SERVER – Create Default Constraint Over Table Column
585 May 30, 2008 SQLAuthority News – 3 Million Readers and Continuing Journey
584 May 29, 2008 SQL SERVER – UNPIVOT Table Example
583 May 28, 2008 SQLAuthority News – Download – Windows Server 2008 w/ SQL Server 2005
582 May 27, 2008 SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 3
581 May 26, 2008 SQLAuthority News – SQL SERVER 2008 – New Logo
580 May 25, 2008 SQL SERVER – T-SQL Script to Devide One Column into Two Column
579 May 24, 2008 SQL Authority News – SQL Server Interview Questions – SQL Related Jobs – DBA Job Description
578 May 23, 2008 SQL SERVER – SQL SERVER – UDF – Get the Day of the Week Function – Part 2
577 May 22, 2008 SQL SERVER – PIVOT Table Example
576 May 21, 2008 SQL SERVER – 2005 – Twelve Tips For Optimizing Sql Server 2005 Query Performance
575 May 20, 2008 SQL SERVER – 2008 – Choosing the Right Edition for Your Needs
574 May 19, 2008 SQLAuthority Download – Providing Security for Web Applications and Infrastructure: Best Practices for Managing Security Risks
573 May 18, 2008 SQLAuthority News – SQL SERVER Database Administrator Job Description
572 May 17, 2008 SQL SERVER – Ideal TempDB FileGrowth Value
571 May 16, 2008 SQL SERVER – Find Table in Every Database of SQL Server – Part 3
570 May 15, 2008 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Silly Mistake
569 May 14, 2008 SQL SERVER – Orphaned MS DTC Transaction Information
568 May 13, 2008 SQL SERVER – Four Basic SQL Statements – SQL Operations
567 May 12, 2008 SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2
566 May 11, 2008 SQL SERVER 2005 – Microsoft Will Release SP3 Soon
565 May 10, 2008 SQL SERVER – Function Property – Deterministic or Non-Deterministic
564 May 09, 2008 SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a

563 May 08, 2008 SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2
562 May 07, 2008 SQL SERVER – Create Database Error in Windows Vista
561 May 06, 2008 SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication
560 May 05, 2008 SQL SERVER – Find Table in Every Database of SQL Server – Part 2
559 May 04, 2008 SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution
558 May 03, 2008 SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition
557 May 02, 2008 SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions
556 May 01, 2008 SQLAuthority News – Write for SQLAuthority
555 Apr 30, 2008 SQL SERVER – Find Table in Every Database of SQL Server – Part 2
554 Apr 29, 2008 SQL SERVER – Find Table in Every Database of SQL Server
553 Apr 28, 2008 SQL SERVER – Download FAQ Sheet – SQL Server in One Page
552 Apr 27, 2008 SQL SERVER – Query Analyzer Shortcuts – Part 2
551 Apr 26, 2008 SQL SERVER – Optimization Rules of Thumb – Best Practices – Reader’s Article
550 Apr 25, 2008 SQL SERVER – Optimization Rules of Thumb – Best Practices
549 Apr 25, 2008 SQLAuthority News – Authors Personal Bookmarks
548 Apr 24, 2008 SQLAuthority News – Download Microsoft Office Visio 2007 Professional SQL Server Add-In
547 Apr 23, 2008 SQL SERVER – Converting Subqueries to Joins
546 Apr 22, 2008 SQL SERVER – Better Performance – LEFT JOIN or NOT IN?
545 Apr 21, 2008 SQL SERVER – 2008 – Update Resolving Conflict Between SQL Server 2005 and SQL Server 2008
544 Apr 20, 2008 SQL SERVER – Identifiers As Valid Object Names
543 Apr 19, 2008 SQL SERVER – Is Cursor Database Object or Datatype
542 Apr 18, 2008 SQL SERVER – Generate Foreign Key Scripts For Database
541 Apr 17, 2008 SQLAuthority News – My Favorite Link of This Blog
540 Apr 16, 2008 SQL SERVER – 2008 – Row Constructors – Load Temp Tables From Stored Procedures
539 Apr 15, 2008 SQL SERVER – Surface Area Configuration Tools Reduce Exposure To Security Risks
538 Apr 14, 2008 SQL SERVER – SQL Slammer (Computer Worm)
537 Apr 13, 2008 SQL SERVER – 2008 – Important Resources
536 Apr 12, 2008 SQL SERVER – 2008 – Download Presentation and Whitepapers
535 Apr 11, 2008 SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS – Part 2
534 Apr 10, 2008 SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf) – Part 2
533 Apr 09, 2008 SQL SERVER – 2005 – Connection Strings For .NET
532 Apr 08, 2008 SQL SERVER – Change Order of Column In Database Tables
531 Apr 07, 2008 SQL SERVER – 2005 – Restore Database Using Corrupt Datafiles (.mdf and .ldf)
530 Apr 06, 2008 SQL SERVER – 15 Best Practices for Better Database Performance
529 Apr 05, 2008 SQL SERVER – 2005 – Transferring Ownership of a Schema to a User
528 Apr 04, 2008 SQLAuthority News – Translation in International Languages – Arabic, Chinese, Dutch, French, German, Greek, Italian, Japanese, Korean, Portuguese, Russian, Spanish
527 Apr 03, 2008 SQLAuthority News – Learn New Things – Self Criticism
526 Apr 02, 2008 SQL SERVER – Find Nth Highest Salary of Employee – Query to Retrieve the Nth Maximum value
525 Apr 01, 2008 SQL SERVER – Microsoft SQL Server 2000/2005 Management Pack Download
524 Mar 31, 2008 SQL SERVER – Popular Articles of SQLAuthority Blog
523 Mar 30, 2008 SQL SERVER – Introduction to Heap Structure – What is Heap?
522 Mar 29, 2008 SQL SERVER – 2005 – List All Column With Indentity Key In Specific Database
521 Mar 28, 2008 SQL SERVER – 2005 – Introduction to sys.dm_exec_query_optimizer_info
520 Mar 27, 2008 SQL SERVER – 2005 – Find Index Fragmentation Details – Slow Index Performance
519 Mar 26, 2008 SQLAuthority News – Few Links About SQLAuthority
518 Mar 25, 2008 SQL SERVER – Simple Puzzle Using Union and Union All – Answer
517 Mar 24, 2008 SQL SERVER – Simple Puzzle Using Union and Union All
516 Mar 23, 2008 SQL SERVER – 2005 – Mechanisms to Ensure Integrity and Consistency of Databases – Locking and Row Versioning
515 Mar 22, 2008 SQL SERVER – 2005 – Find Highest / Most Used Stored Procedure
514 Mar 21, 2008 SQL SERVER – Introduction to Live Lock – What is Live Lock?
513 Mar 20, 2008 SQLAuthority News – Book Review – Joe Celkos SQL Puzzles and Answers, Second Edition, Second Edition
512 Mar 19, 2008 SQL SERVER – Add Column With Default Column Constraint to Table
511 Mar 18, 2008 SQL SERVER – 2005 – Analysis Services Query Performance Top 10 Best Practices
510 Mar 17, 2008 SQLAuthority News – Download White Papers – Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server
509 Mar 16, 2008 SQL SERVER – 2005 – Retrieve Any User Defined Object Details Using sys.objects Database
508 Mar 15, 2008 SQL SERVER – 2005 – Retrieve Processes Using Specified Database
507 Mar 14, 2008 SQL SERVER – 2005 – Introduction to CLR and Integration to CLR with SQL – Simple Sample Example of CLR
506 Mar 13, 2008 SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2
505 Mar 12, 2008 SQL SERVER – 2005 – Find Nth Highest Record from Database Table – Using Ranking Function ROW_NUMBER
504 Mar 11, 2008 SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 3
503 Mar 10, 2008 SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL – Part 2
502 Mar 09, 2008 SQLAuthority News – Authors Most Visited Article on Blog
501 Mar 08, 2008 SQL SERVER – 2005 – Find Nth Highest Record from Database Table
500 Mar 07, 2008 SQLAuthority News – 500th Post – An Interesting Journey with SQL Server
499 Mar 06, 2008 SQLAuthority News – SQL Server 2005 is The Data Platform Leader
498 Mar 05, 2008 SQL SERVER – Simple Example of Cursor – Sample Cursor Part 2
497 Mar 04, 2008 SQL SERVER – 2005 – A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold
496 Mar 03, 2008 SQL SERVER – Sharpen Your Basic SQL Server Skills – Learn the distinctions between unique constraint and primary key constraint and the easiest way to get random rows

495 Mar 02, 2008 SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL
494 Mar 01, 2008 SQL SERVER – Transfer The Logins and The Passwords Between Instances of SQL Server 2005
493 Feb 29, 2008 SQL SERVER – Introduction to SQL Server Encryption and Symmetric Key Encryption Tutorial
492 Feb 28, 2008 SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword
491 Feb 27, 2008 SQLAuthority New – Microsoft SQL Server 2008 and System Center – Managing, Deploying, and Protecting SQL Server 2008
490 Feb 26, 2008 SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation
489 Feb 25, 2008 SQLAuthority News – Download Upgrade Service Datasheet
488 Feb 24, 2008 SQL SERVER – 2005 – Licensing Model Compared to Other Database Products
487 Feb 23, 2008 SQL SERVER – 2005 – Understanding Licensing Model
486 Feb 22, 2008 SQL SERVER – Find All The User Defined Functions (UDF) – Part 2
485 Feb 21, 2008 SQLAuthority News – Download SQL Server 2008 February CTP Sample Codes
484 Feb 21, 2008 SQLAuthority New – SQL Server 2008 Books Online CTP (February 2008)
483 Feb 20, 2008 SQL SERVER – UDF to Return a Calendar for Any Date for Any Year
482 Feb 19, 2008 SQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the cur

481 Feb 18, 2008 SQLAuthority News – Download SQL Server 2008 February CTP (CTP 6)
480 Feb 17, 2008 SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string ‘
479 Feb 16, 2008 SQL SERVER – Msg: 2593 : There are ROWCOUNT rows in PAGECOUNT pages for object ‘OBJECT’.
478 Feb 15, 2008 SQL SERVER – Index Reorganize or Index Rebuild
477 Feb 14, 2008 SQL SERVER – Introduction to Performance Monitor – How to Use Perfmon
476 Feb 13, 2008 SQL SERVER – Introduction to Three Important Performance Counters
475 Feb 12, 2008 SQL SERVER – Get Current Database Name
474 Feb 11, 2008 SQL SERVER – 2005 – Find Unused Indexes of Current Database
473 Feb 10, 2008 SQLAuthority News – RIP: Ken Henderson, 1967 – 2008
472 Feb 09, 2008 SQLAuthority News – 2008 – Download – SQL Server 2008 Brochure
471 Feb 08, 2008 SQL SERVER – Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3
470 Feb 07, 2008 SQL SERVER – Sharpen Your Basic SQL Server Skills – Database backup demystified
469 Feb 06, 2008 SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server
468 Feb 05, 2008 SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Microsoft Quotes
467 Feb 04, 2008 SQL SERVER – Simple Example of WHILE Loop with BREAK and CONTINUE
466 Feb 03, 2008 SQL SERVER – FIX : ERROR : Cannot find template file for new query (C:\Program Files\Microsoft SQL Server\90\Tools\ Binn\VSShell\Common7\ IDE\sqlworkbenchprojectitems\Sql\ SQLFile.s

465 Feb 02, 2008 SQL SERVER – Find All The User Defined Functions (UDF) in a Database
464 Feb 01, 2008 SQL SERVER – Find Great Job with Great Pay
463 Jan 31, 2008 SQL SERVER – Top 10 Best Practices for SQL Server Maintenance for SAP
462 Jan 30, 2008 SQL SERVER – FIX : ERROR : The query processor could not start the necessary thread resources for parallel query execution
461 Jan 29, 2008 SQLAuthority New – O’relly Style Book Cover for SQLAuthority
460 Jan 28, 2008 SQLAuthority News – Book Review – Beginners Guide to SQL Server Integration Services Using Visual Studio 2005
459 Jan 27, 2008 SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes
458 Jan 26, 2008 SQLAuthority News – Microsoft SQL Server 2000 MSIT Configuration Pack for Configuration Manager 2007
457 Jan 25, 2008 SQL SERVER – 2005 – Database Table Partitioning Tutorial – How to Horizontal Partition Database Table
456 Jan 24, 2008 SQL SERVER – 2005 – Introduction to Partitioning
455 Jan 23, 2008 SQLAuthority News – Download Microsoft SQL Server 2005 Assessment Configuration Pack
454 Jan 22, 2008 SQLAuthority News – Fix : Remote Desktop Copy Paste Stop Working
453 Jan 21, 2008 SQL SERVER – 2005 – Get a row per file of a database as stored in the master database
452 Jan 20, 2008 SQL SERVER – Introduction to Statistical Functions – VAR, STDEVP, STDEV, VARP
451 Jan 19, 2008 SQL SERVER – Introduction to Aggregate Functions
450 Jan 18, 2008 SQL SERVER – 2005 Best Practices Analyzer (January 2008)
449 Jan 17, 2008 SQLAuthority News – Job Description of Database Administrator (DBA) or Database Developer
448 Jan 16, 2008 SQLAuthroity News – Microsoft SQL Server 2000 Assessment Configuration Pack
447 Jan 15, 2008 SQL SERVER – What is – DML, DDL, DCL and TCL – Introduction and Examples
446 Jan 14, 2008 SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet
445 Jan 13, 2008 SQLAuthority News – Find Job Related to SQL Server and Database Administrator and Interview Questions and Answers
444 Jan 12, 2008 SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure
443 Jan 11, 2008 SQL SERVER – Reclaim Space After Dropping Variable-Length Columns Using DBCC CLEANTABLE
442 Jan 10, 2008 SQL SERVER – 2005 – Display Fragmentation Information of Data and Indexes of Database Table
441 Jan 09, 2008 SQL SERVER – Execute Same Query and Statement Multiple Times Using Command GO
440 Jan 08, 2008 SQL SERVER – 2005 – Export Data From SQL Server 2005 to Microsoft Excel Datasheet
439 Jan 07, 2008 SQL SERVER – 2005 – Introduction and Explanation to SYNONYM – Helpful T-SQL Feature for Developer
438 Jan 06, 2008 SQL SERVER – Download Frequently Asked Generic Interview Questions
437 Jan 05, 2008 SQL SERVER – Most Frequently Asked Generic Interview Questions
436 Jan 04, 2008 SQL SERVER – 2005 – CROSS APPLY
435 Jan 03, 2008 SQL SERVER – 2005 – Last Ran Query – Recently Ran Query
434 Jan 03, 2008 SQLAuthority New – Best Practices for Speeding Up Your Web Site
433 Jan 02, 2008 SQL SERVER – Fix : Error : 15281 SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’ of component ‘Ad Hoc Distributed Queries’ because this c

432 Jan 01, 2008 SQLAuthority New – Happy New Year 2008
431 Dec 31, 2007 SQLAuthority News – Thank You to Blog Readers
430 Dec 30, 2007 SQL SERVER – Remove Duplicate Characters From a String
429 Dec 29, 2007 SQL SERVER – Change Password of SA Login Using Management Studio
428 Dec 28, 2007 SQL SERVER – Difference Between Quality Assurance and Quality Control – QA vs QC
427 Dec 27, 2007 SQLAuthority News – Book Review – A Practitioner’s Guide to Software Test Design
426 Dec 26, 2007 SQL SERVER – TRUNCATE Can’t be Rolled Back Using Log Files After Transaction Session Is Closed
425 Dec 25, 2007 SQL SERVER – Mirrored Backup Introduction and Explanation
424 Dec 25, 2007 SQL SERVER – Delete Duplicate Records – Count Duplicate Records Links
423 Dec 24, 2007 SQL SERVER – Object Oriented Database Management Systems
422 Dec 24, 2007 SQLAuthority News – Download Microsoft SQL Server 2000/2005 Management Pack
421 Dec 24, 2007 SQLAuthority News – Jobs, Search, Best Articles, Homepage
420 Dec 23, 2007 SQL SERVER – 2008 – New DataTypes DATE and TIME
419 Dec 22, 2007 SQL SERVER – Difference Between Index Rebuild and Index Reorganize Explained with T-SQL Script
418 Dec 21, 2007 SQL SERVER – Enabling Clustered and Non-Clustered Indexes – Interesting Fact
417 Dec 20, 2007 SQL SERVER – DISTINCT Keyword Usage and Common Discussion
416 Dec 19, 2007 SQL SERVER – Cumulative Update Package 5 for SQL Server 2005 Service Pack 2
415 Dec 19, 2007 SQLAuthority News – RML Utilities for SQL Server
414 Dec 18, 2007 SQL SERVER – Get Information of Index of Tables and Indexed Columns
413 Dec 17, 2007 SQL SERVER – T-SQL Script to Find Details About TempDB
412 Dec 16, 2007 SQL SERVER – Solution – Log File Very Large – Log Full
411 Dec 15, 2007 SQL SERVER – TempDB Restrictions – Temp Database Restrictions
410 Dec 14, 2007 SQLAuthority News – Top 10 Tips for Successful Software Outsourcing
409 Dec 13, 2007 SQL SERVER – Do Not Store Images in Database – Store Location of Images (URL)
408 Dec 12, 2007 SQL SERVER – White Papers: Migration from Oracle Sybase, or Microsoft Access to Microsoft SQL Server
407 Dec 11, 2007 SQL SERVER – Microsoft Synchronization Services for ADO.NET v2.0 CTP1 Refresh
406 Dec 10, 2007 SQLAuthority News – Microsoft SQL Server 2008 Community Technology Preview (November 2007) VHD
405 Dec 09, 2007 SQL SERVER – ACID (Atomicity, Consistency, Isolation, Durability)
404 Dec 08, 2007 SQL SERVER – Generic Architecture Image
403 Dec 07, 2007 SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use.
402 Dec 06, 2007 SQL SERVER – 2005 – Dynamic Management Views (DMV) and Dynamic Management Functions (DMF)
401 Dec 05, 2007 SQL SERVER – UDF – Remove Duplicate Chars From String
400 Dec 04, 2007 SQLAuthority Author Visit – IT Outsourcing to India – Top 10 Reasons Companies Outsource
399 Dec 03, 2007 SQL SERVER – Grouping JOIN Clauses In SQL
398 Dec 02, 2007 SQL SERVER – Q and A with Database Administrators
397 Dec 01, 2007 SQL SERVER – Sharpen Your Skills: Brush up on FILLFACTOR, ISNULL, NULLIF, and % as wildcard and operator
396 Nov 30, 2007 SQLAuthority News – Download SQL Server 2005 Books Online (September 2007)
395 Nov 29, 2007 SQL SERVER – Database Interview Questions and Answers Complete List
394 Nov 28, 2007 SQL SERVER – Correct Syntax for Stored Procedure SP
393 Nov 27, 2007 SQL SERVER – 2005 – List All Stored Procedure in Database
392 Nov 26, 2007 SQL SERVER – Rules of Third Normal Form and Normalization Advantage – 3NF
391 Nov 25, 2007 SQLAuthority News – SQL Server Compact 3.5 Downloads and ReportViewer Visual Studio Download
390 Nov 24, 2007 SQL SERVER – Upgrade Advise – From 2000 to 2005 or 2008
389 Nov 23, 2007 SQL SERVER – 2008 – November CPT5 New Improvement
388 Nov 22, 2007 SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2
387 Nov 21, 2007 SQL SERVER – Generate Incremented Linear Number Sequence
386 Nov 20, 2007 SQL SERVER – Sharpen Your Skills: Joins, Groupings, and Data Types
385 Nov 19, 2007 SQLAuthority News – SQL Server 2008 Community Technology Preview (CTP) Download Now Available
384 Nov 18, 2007 SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide – SQL Server, ColdFusion, ASP.NET
383 Nov 17, 2007 SQL SERVER – 2005 – Best Practices for SQL Server Health Check
382 Nov 16, 2007 SQL SERVER – 2005 – Generate Script with Data from Database – Database Publishing Wizard
381 Nov 15, 2007 SQLAuthority News – Microsoft SQL Server 2005 Assessment Configuration Pack Download
380 Nov 14, 2007 SQLAuthority News – SQL Joke, SQL Humor, SQL Laugh – Database Dilbert
379 Nov 14, 2007 SQLAuthority News – Microsoft SQL Server 2005 MSIT Three Configuration Pack for Configuration Manager 2007
378 Nov 13, 2007 SQL SERVER – DBCC CHECKDB Introduction and Explanation – DBCC CHECKDB Errors Solution
377 Nov 12, 2007 SQL SERVER – FIX : ERROR Msg 1803 The CREATE DATABASE statement failed. The primary file must be at least 2 MB to accommodate a copy of the model database
376 Nov 12, 2007 SQLAuthority News – The Equations of Relativist
375 Nov 12, 2007 SQL SERVER – FIX : ERROR Msg 5174 Each file size must be greater than or equal to 512 KB
374 Nov 11, 2007 SQLAuthority News – SQL Server 2005 Powers Global Forensic Data Security Tool
373 Nov 10, 2007 SQL SERVER – 2005 2000 – Search String in Stored Procedure
372 Nov 09, 2007 SQL SERVER – Versions, CodeNames, Year of Release
371 Nov 08, 2007 SQLAuthority News – Book Review – SQL Server 2005 Management and Administration (Paperback)
370 Nov 07, 2007 SQLAuthority News – 1 Million Visitors in last 1 year
369 Nov 06, 2007 SQLAuthority News – Microsoft Synchronization Services for ADO.NET v2.0 CTP1
368 Nov 05, 2007 SQLAuthority News – Few Add-ons for SQLAuthority
367 Nov 04, 2007 SQLAuthority News – Best Articles on SQLAuthority.com
366 Nov 03, 2007 SQLAuthority News – Best SQLAuthority Articles on Other Popular Sites
365 Nov 02, 2007 SQLAuthority News – Best Downloads on SQLAuthority.com
364 Nov 01, 2007 SQLAuthority News – First Birthday of Blog – 365 Post in One Year
363 Oct 31, 2007 SQL SERVER – Importance of Master Database for SQL Server Startup
362 Oct 30, 2007 SQL SERVER – Business Intelligence (BI) Basic Terms Explanation
361 Oct 29, 2007 SQL SERVER – Disable All Triggers on a Database – Disable All Triggers on All Servers
360 Oct 28, 2007 SQL SERVER – 2008 – Server Consolidation WhitePaper Download
359 Oct 27, 2007 SQL SERVER – 2005 – Get Current User – Get Logged In User
358 Oct 26, 2007 SQL SERVER – Deterministic Functions and Nondeterministic Functions
357 Oct 25, 2007 SQL SERVER – 2005 – Forced Parameterization and Simple Parameterization – T-SQL and SSMS
356 Oct 24, 2007 SQL SERVER – Simple Example of WHILE Loop With CONTINUE and BREAK Keywords
355 Oct 23, 2007 SQL SERVER – Get Permissions of My Username / Userlogin on Server / Database
354 Oct 22, 2007 SQL SERVER – Difference Between @@Version and xp_msver – Retrieve SQL Server Information
353 Oct 21, 2007 SQL SERVER – 2005 – Limitation of Online Index Rebuld Operation
352 Oct 20, 2007 SQL SERVER – Set Server Level FILLFACTOR Using T-SQL Script
351 Oct 19, 2007 SQL SERVER – Types of DBCC Commands When Used as Database Console Commands
350 Oct 18, 2007 SQL SERVER – 2005 – Fix : Error : Msg 7411, Level 16, State 1 Server is not configured for RPC
349 Oct 17, 2007 SQLAuthority News – Book Review – Backup & Recovery (Paperback)
348 Oct 16, 2007 SQL SERVER – Three T-SQL Script to Create Primary Keys on Table
347 Oct 16, 2007 SQL SERVER – 2005 – Driver for PHP Community Technology Preview (October 2007)
346 Oct 15, 2007 SQL SERVER – Explanation and Understanding NOT NULL Constraint
345 Oct 14, 2007 SQL SERVER – Three Rules to Use UNION
344 Oct 13, 2007 SQL SERVER – 2005 – SQL Server Surface Area Configuration Tool Examples and Explanation
343 Oct 12, 2007 SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards
342 Oct 11, 2007 SQL SERVER – T-SQL Script to Add Clustered Primary Key
341 Oct 10, 2007 SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE
340 Oct 09, 2007 SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE
339 Oct 08, 2007 SQL SERVER – 2005 – Connection Property of SQL Server Management Studio SSMS
338 Oct 07, 2007 SQLAuthority News – Latest Interesting Downloads and Articles
337 Oct 06, 2007 SQL SERVER – Executing Remote Stored Procedure – Calling Stored Procedure on Linked Server
336 Oct 05, 2007 SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example
335 Oct 04, 2007 SQL SERVER – 2005 – Different Types of Cache Objects
334 Oct 03, 2007 SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling With RAISEERROR Function
333 Oct 02, 2007 SQL SERVER – Find Name of The SQL Server Instance
332 Oct 01, 2007 SQL SERVER – 2005 – OUTPUT Clause Example and Explanation with INSERT, UPDATE, DELETE
331 Sep 30, 2007 SQL SERVER – 2005 Query Editor – Microsoft SQL Server Management Studio
330 Sep 29, 2007 SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS
329 Sep 28, 2007 SQL SERVER – Introduction and Example for DATEFORMAT Command
328 Sep 27, 2007 SQL SERVER – FIX : Error 3154: The backup set holds a backup of a database other than the existing database
327 Sep 26, 2007 SQLAuthority News – Book Review – Programming SQL Server 2005 [ILLUSTRATED]
326 Sep 25, 2007 SQL SERVER – Effect of TRANSACTION on Local Variable – After ROLLBACK and After COMMIT
325 Sep 24, 2007 SQL SERVER – Order of Result Set of SELECT Statement on Clustered Indexed Table When ORDER BY is Not Used
324 Sep 23, 2007 SQL SERVER – Stored Procedure to Know Database Access Permission to Current User
323 Sep 22, 2007 SQL SERVER – 2005 – Version Information and Additional Information – Extended Stored Procedure xp_msver
322 Sep 21, 2007 SQL SERVER – 2005 – Multiple Language Support
321 Sep 20, 2007 SQL SERVER – FIX : ERROR : 3260 An internal buffer has become full
320 Sep 19, 2007 SQL SERVER – Rename Database to New Name Using Stored Procedure by Changing to Single User Mode
319 Sep 18, 2007 SQLAuthority News – Scale-Out Querying with Analysis Services Using SAN Snapshots
318 Sep 18, 2007 SQL SERVER – UDF – Validate Positive Integer Function – Validate Natural Integer Function
317 Sep 17, 2007 SQLAuthority News – NASDAQ Uses SQL Server 2005 – Reducing Costs through Better Data Management
316 Sep 17, 2007 SQL SERVER – Difference Between UPDATE and UPDATE()
315 Sep 16, 2007 SQLAuthority News – Active Directory Integration Sample Script
314 Sep 16, 2007 SQL SERVER – 2005 – List All The Constraint of Database – Find Primary Key and Foreign Key Constraint in Database
313 Sep 15, 2007 SQLAuthority News – Book Review – Pro T-SQL 2005 Programmer’s Guide (Paperback)
312 Sep 14, 2007 SQLAuthority News – Random Article from SQLAuthority Blog
311 Sep 13, 2007 SQL SERVER – Difference Between EXEC and EXECUTE vs EXEC() – Use EXEC/EXECUTE for SP always
310 Sep 12, 2007 SQLAuthority News – Scrum: Agile Software Development for Project Management
309 Sep 11, 2007 SQL SERVER – Frequency of SQL Server Reboot and Restart
308 Sep 11, 2007 SQLAuthority News – Book Review – SQL Server 2005 DBA Street Smarts: A Real World Guide to SQL Server 2005 Certification Skills
307 Sep 10, 2007 SQL SERVER – 2005 – White Paper – Integrating Visio 2007 and Microsoft SQL Server 2005
306 Sep 10, 2007 SQLAuthority News – Job Opportunity in Ahmedabad, India to Work with Technology Leaders Worldwide
305 Sep 09, 2007 SQL SERVER – 2005 – Start Stop Restart SQL Server From Command Prompt
304 Sep 08, 2007 SQL SERVER – UDF – User Defined Function – Get Number of Days in Month
303 Sep 07, 2007 SQL SERVER – Correlated and Noncorrelated – SubQuery Introduction, Explanation and Example
302 Sep 06, 2007 SQL SERVER – 2005 – Introduction and Explanation to sqlcmd
301 Sep 06, 2007 SQLAuthority News – SQL SERVER 2008 CTP 4 Released
300 Sep 05, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Valid SQL Error
299 Sep 05, 2007 SQLAuthority News – Interesting Read – Using A SQL JOIN In A SQL UPDATE/Delete Statement – Ben Nadel
298 Sep 04, 2007 SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database
297 Sep 04, 2007 SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database
296 Sep 03, 2007 SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text
295 Sep 02, 2007 SQL SERVER – Fix : Error : Msg 3117, Level 16, State 4 The log or differential backup cannot be restored because no files are ready to rollforward
294 Aug 31, 2007 SQL SERVER – 2005 – Find Database Status Using sys.databases or DATABASEPROPERTYEX
293 Aug 30, 2007 SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS
292 Aug 29, 2007 SQL SERVER – Difference and Explanation among DECIMAL, FLOAT and NUMERIC
291 Aug 28, 2007 SQL SERVER – Actual Execution Plan vs. Estimated Execution Plan
290 Aug 27, 2007 SQL SERVER – 2005 – Use Always Outer Join Clause instead of (*= and =*)
289 Aug 26, 2007 SQL SERVER – 2005 – No Backup Support For Named Pipes
288 Aug 25, 2007 SQL SERVER – FIX : Error : msg 2540 – The system cannot self repair this error
287 Aug 24, 2007 SQL SERVER – 2005 – T-SQL Script to Attach and Detach Database
286 Aug 23, 2007 SQL SERVER – 2005 – Use of Non-deterministic Function in UDF – Find Day Difference Between Any Date and Today
285 Aug 22, 2007 SQL SERVER – T-SQL Script to Insert Carriage Return and New Line Feed in Code
284 Aug 21, 2007 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

283 Aug 20, 2007 SQLAuthority News – Principles of Simplicity
282 Aug 20, 2007 SQL SERVER – Find Monday of the Current Week
281 Aug 19, 2007 SQLAuthority News – Book Review – Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes
280 Aug 18, 2007 SQL SERVER – Find Last Day of Any Month – Current Previous Next
279 Aug 17, 2007 SQL SERVER – 2005 – Explanation and Script for Online Index Operations – Create, Rebuild, Drop
278 Aug 16, 2007 SQLAuthority News – Subscribed to SQLAuthority Emails
277 Aug 16, 2007 SQL SERVER – 2008 – Book On-Line Link
276 Aug 16, 2007 SQL SERVER – 2005 – Difference and Similarity Between NEWSEQUENTIALID() and NEWID()
275 Aug 15, 2007 SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO TABLE
274 Aug 14, 2007 SQLAuthority News – Book Review – Learning SQL on SQL Server 2005 (Learning)
273 Aug 14, 2007 SQL SERVER – What is SQL? How to pronounce SQL?
272 Aug 13, 2007 SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey Details
271 Aug 12, 2007 SQL SERVER – Fix : ERROR : Msg 1033, Level 15, State 1 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common t

270 Aug 11, 2007 SQL SERVER – UDF – Validate Integer Function
269 Aug 10, 2007 SQL SERVER – 2005 – Find Stored Procedure Create Date and Modified Date
268 Aug 09, 2007 SQL SERVER – 2005 – List All The Column With Specific Data Types
267 Aug 08, 2007 SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
266 Aug 07, 2007 SQL SERVER – 2005 – List Tables in Database Without Primary Key
265 Aug 06, 2007 SQL SERVER – Fix : Error 2596 The repair statement was not processed. The database cannot be in read-only mode
264 Aug 05, 2007 SQL SERVER – Stop SQL Server Immediately Using T-SQL
263 Aug 04, 2007 SQL SERVER – One Thing All DBA Must Know
262 Aug 04, 2007 SQLAuthority News – Download SQL Server 2005 Samples and Sample Databases
261 Aug 04, 2007 SQLAuthority News – Author Visit – Database Architecture and Implementation Discussion – New York, New Jersey
260 Aug 03, 2007 SQLAuthority News – Microsoft SQL Server Compact 3.5 Server Tools Beta 2 Released
259 Aug 03, 2007 SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
258 Aug 02, 2007 SQLAuthority News – Book Review – SQL Server 2005 Practical Troubleshooting: The Database Engine
257 Aug 02, 2007 SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details
256 Aug 01, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Search SQL
255 Aug 01, 2007 SQL SERVER – 2008 – July CTP Released
254 Jul 31, 2007 SQLAuthority News – My Favorite Articles of This Blog
253 Jul 30, 2007 SQLAuthority News – Birthday of SQL Authority Author
252 Jul 29, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers Complete List Download
251 Jul 28, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Part 3
250 Jul 27, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Part 2
249 Jul 26, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Part 1
248 Jul 25, 2007 SQLAuthority News – Interesting Read – Programming Concepts, Structured Thinking Language (STL) and Relationary
247 Jul 25, 2007 SQL SERVER – Data Warehousing Interview Questions and Answers – Introduction
246 Jul 24, 2007 SQL SERVER – 2005 – Server and Database Level DDL Triggers Examples and Explanation
245 Jul 23, 2007 SQL SERVER – UDF – Function to Get Previous And Next Work Day – Exclude Saturday and Sunday
244 Jul 23, 2007 SQL SERVER – UDF – Get the Day of the Week Function
243 Jul 22, 2007 SQLAuthority News – FQL – Facebook Query Language
242 Jul 21, 2007 SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database ‘yourdatabasename’. CREATE DATABASE is aborted.
241 Jul 20, 2007 SQL SERVER – Fix : Error Msg 4214 – Error Msg 3013 – BACKUP LOG cannot be performed because there is no current database backup
240 Jul 19, 2007 SQL SERVER – 2005 – SSMS – View/Send Query Results to Text/Grid/Files
239 Jul 19, 2007 SQL SERVER – SPACE Function Example
238 Jul 18, 2007 SQL SERVER – Restore Database Without or With Backup – Everything About Restore and Backup
237 Jul 17, 2007 SQL SERVER – CASE Statement in ORDER BY Clause – ORDER BY using Variable
236 Jul 16, 2007 SQL SERVER – Microsoft White Papers – Analysis Services Query Best Practices – Partial Database Availability
235 Jul 15, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – 15 Signs to Identify Bad DBA
234 Jul 14, 2007 SQL SERVER – 2005 Collation Explanation and Translation – Part 2
233 Jul 13, 2007 SQL SERVER – 2005 – Use ALTER DATABASE MODIFY NAME Instead of sp_renameDB to rename
232 Jul 12, 2007 SQL SERVER – Validate Field For DATE datatype using function ISDATE()
231 Jul 11, 2007 SQLAuthority News – SQL Blog SQLAuthority.com Comment by Mr. Ben Forta
230 Jul 11, 2007 SQL SERVER – 2005 – Features Comparison Chart
229 Jul 11, 2007 SQL SERVER – 2008 – Scheduled Launch at an Event in Los Angeles on Feb. 27, 2008
228 Jul 11, 2007 SQL SERVER – Count Duplicate Records – Rows
227 Jul 10, 2007 SQL SERVER – 2005 – List All Stored Procedure Modified in Last N Days
226 Jul 09, 2007 SQL SERVER – Result of EXP (Exponential) to the POWER of PI – Functions Explained
225 Jul 08, 2007 SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1
224 Jul 08, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Generic Quotes
223 Jul 07, 2007 SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT
222 Jul 06, 2007 SQL SERVER – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type
221 Jul 05, 2007 SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9
220 Jul 05, 2007 SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example
219 Jul 04, 2007 SQL SERVER – 2005 Best Practices Analyzer (July BPA)
218 Jul 04, 2007 SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause
217 Jul 03, 2007 SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable
216 Jul 02, 2007 SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC
215 Jul 01, 2007 SQL SERVER – Explanation of WITH ENCRYPTION clause for Stored Procedure and User Defined Functions
214 Jun 30, 2007 SQL SERVER – Fix : Error : Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000)
213 Jun 29, 2007 SQL SERVER – Recompile All The Stored Procedure on Specific Table
212 Jun 28, 2007 SQL SERVER – 2005 Improvements in TempDB
211 Jun 27, 2007 SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file
210 Jun 26, 2007 SQL SERVER – 2005 List All Tables of Database
209 Jun 26, 2007 SQL SERVER – Explanation and Example Four Part Name
208 Jun 25, 2007 SQL SERVER – Repeate String N Times Using String Function REPLICATE
207 Jun 24, 2007 SQLAuthority News – Book Review – Microsoft(R) SQL Server 2005 Unleashed (Paperback)
206 Jun 24, 2007 SQL SERVER – Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild – SQL SERVER 2000 and SQL SERVER 2005
205 Jun 23, 2007 SQL SERVER – 2005 Row Overflow Data Explanation
204 Jun 22, 2007 SQL SERVER – Explanation and Comparison of NULLIF and ISNULL
203 Jun 21, 2007 SQLAuthority.com News – iGoogle Gadget Published
202 Jun 21, 2007 SQL SERVER – Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
201 Jun 20, 2007 SQL SERVER – Find Length of Text Field
200 Jun 19, 2007 SQLAuthority.com News – Journey to SQL Authority Milestone of SQL Server
199 Jun 18, 2007 SQL SERVER – Delay Function – WAITFOR clause – Delay Execution of Commands
198 Jun 17, 2007 SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance
197 Jun 16, 2007 SQL SERVER – 2005 – UDF – User Defined Function to Strip HTML – Parse HTML – No Regular Expression
196 Jun 15, 2007 SQL SERVER – sp_HelpText for sp_HelpText – Puzzle
195 Jun 15, 2007 SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2
194 Jun 14, 2007 SQL SERVER – Easy Sequence of SELECT FROM JOIN WHERE GROUP BY HAVING ORDER BY
193 Jun 14, 2007 SQL SERVER – Explanation SQL SERVER Hash Join
192 Jun 13, 2007 SQL SERVER – Fix : Error 8629 The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or i

191 Jun 13, 2007 SQL SERVER – Download 2005 Books Online (May 2007)
190 Jun 13, 2007 SQL SERVER – Recovery Models and Selection
189 Jun 12, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Funny Quotes
188 Jun 12, 2007 SQL SERVER – LEN and DATALENGTH of NULL Simple Example
187 Jun 11, 2007 SQL SERVER – Cannot resolve collation conflict for equal to operation
186 Jun 11, 2007 SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table
185 Jun 10, 2007 SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice
184 Jun 10, 2007 SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.
183 Jun 09, 2007 SQL SERVER – Fix : Error : Msg 9514, Level 16, State 1, Line 1 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s).
182 Jun 09, 2007 SQL SERVER – Spatial Database Definition and Research Documents
181 Jun 08, 2007 SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
180 Jun 08, 2007 SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
179 Jun 07, 2007 SQL SERVER – 2005 Download New Updated Book On Line (BOL)
178 Jun 07, 2007 SQL SERVER – 2008 (Katmai) June CTP Released – Improvement Pillars – Diagram
177 Jun 07, 2007 SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.
176 Jun 06, 2007 SQL SERVER Database Coding Standards and Guidelines Complete List Download
175 Jun 05, 2007 SQL SERVER – Database Coding Standards and Guidelines – Part 2
174 Jun 04, 2007 SQL SERVER – Database Coding Standards and Guidelines – Part 1
173 Jun 03, 2007 SQL SERVER Database Coding Standards and Guidelines – Introduction
172 Jun 03, 2007 SQL SERVER – 2005 Explanation and Example – SELF JOIN
171 Jun 02, 2007 SQL SERVER – 2005 – Microsoft SQL Server Management Pack for Microsoft Operations Manager 2005 – Download SQL Server MOM 2005
170 Jun 02, 2007 SQLAuthority News – Subscribe to Feed in Email
169 Jun 01, 2007 SQLAuthority News – Dedicated Search Engine for SQLAuthority – Search SQL Solutions
168 Jun 01, 2007 SQL SERVER – 2005 Constraint on VARCHAR(MAX) Field To Limit It Certain Length
167 May 31, 2007 SQL SERVER – Retrieve Information of SQL Server Agent Jobs
166 May 31, 2007 SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility – Part 2 – Management Studio
165 May 31, 2007 SQL SERVER – Primary Key Must Not Contain NULL – Primary Key are NOT NULL
164 May 30, 2007 SQLAuthority.com News – Best SQL Job Search – Best SQL Job List – Find SQL Jobs
163 May 30, 2007 SQL SERVER – Trace Flags – DBCC TRACEON
162 May 30, 2007 SQL SERVER – Fix : Error : Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in table
161 May 29, 2007 SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility
160 May 29, 2007 SQL SERVER – User Defined Functions (UDF) Limitations
159 May 28, 2007 SQLAuthority News – Author Visit – Meeting with Readers – Top Three Features of SQL SERVER 2005
158 May 28, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – SP
157 May 27, 2007 SQL SERVER – Download Feature Pack for Microsoft SQL Server 2005
156 May 27, 2007 SQL SERVER – 2005 Limiting Result Sets by Using TABLESAMPLE – Examples
155 May 26, 2007 SQL SERVER – 2005 Replace TEXT with VARCHAR(MAX) – Stop using TEXT, NTEXT, IMAGE Data Types
154 May 26, 2007 SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key
153 May 25, 2007 SQL SERVER – Change Default Fill Factor For Index
152 May 25, 2007 SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object
151 May 24, 2007 SQL SERVER – Disadvantages (Problems) of Triggers
150 May 24, 2007 SQL SERVER – 2005 Retrieve Configuration of Server
149 May 23, 2007 SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases
148 May 23, 2007 SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator
147 May 23, 2007 SQLAuthority News – New Scoble Plugin of WordPress
146 May 22, 2007 SQLAuthority News – T-Shirts in Action
145 May 22, 2007 SQL SERVER – 2005 Comparison EXCEPT operator vs. NOT IN
144 May 21, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – T-Shirt
143 May 21, 2007 SQL SERVER – Top 15 free SQL Injection Scanners – Link to Security Hacks
142 May 21, 2007 SQL SERVER – 2005 Build List Link
141 May 20, 2007 SQL SERVER – SQL Code Formatter Tools
140 May 20, 2007 SQL SERVER – Script/Function to Find Last Day of Month
139 May 19, 2007 SQL SERVER – ASCII to Decimal and Decimal to ASCII
138 May 19, 2007 SQL SERVER – Math Functions for 2005
137 May 18, 2007 SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples
136 May 18, 2007 SQL SERVER – 2005 – SSMS Change T-SQL Batch Separator
135 May 17, 2007 SQLAuthority News – Limited Edition T-Shirts Arrived
134 May 17, 2007 SQL SERVER – Disable Index – Enable Index – ALTER Index
133 May 16, 2007 SQL SERVER – Fix : Error 1205 : Transaction (Process ID) was deadlocked on resources with another process and has been chosen as the deadlock victim. Rerun the transaction</strong

132 May 16, 2007 SQL SERVER – Fix: Error 130: Cannot perform an aggregate function on an expression containing an aggregate or a subquery
131 May 15, 2007 SQL SERVER – Binary Sequence Generator – Truth Table Generator
130 May 15, 2007 SQL SERVER – DBCC commands List – documented and undocumented
129 May 14, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Photo
128 May 14, 2007 SQL SERVER – MS TechNet : Storage Top 10 Best Practices
127 May 13, 2007 SQL SERVER – Query to Find First and Last Day of Current Month
126 May 13, 2007 SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String
125 May 12, 2007 SQL SERVER – 2005 – List all the database
124 May 12, 2007 SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support
123 May 11, 2007 SQL SERVER – Explanation SQL Command GO
122 May 11, 2007 SQL SERVER – Download Microsoft SQL Server 2005 System Views Map
121 May 10, 2007 SQL SERVER – 2008 Katmai – Download Datasheet Final from Microsoft
120 May 10, 2007 SQL SERVER – Fix: Error : HResult 0×2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server
119 May 10, 2007 SQL SERVER – 2008 Katmai – Your Data, Any Place, Any Time
118 May 09, 2007 SQL SERVER – Fix : Error 2501 : Cannot find a table or object with the name . Check the system catalog.
117 May 09, 2007 SQLAuthority News – Author Visit – MIS2007 Part II – Database Raid Discussion
116 May 08, 2007 SQL SERVER – Index Optimization CheckList
115 May 08, 2007 SQLAuthority News – Author Visit – The 2007 Marketing Innovation Summit, Las Vegas
114 May 07, 2007 SQL SERVER – Top 10 Hidden Gems in SQL Server 2005
113 May 07, 2007 SQL SERVER – 2005/2000 Examples and Explanation for GOTO
112 May 06, 2007 SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP
111 May 06, 2007 SQL SERVER – UDF – Function to Convert List to Table
110 May 05, 2007 SQL SERVER – 2005 Enable CLR using T-SQL script
109 May 05, 2007 SQL SERVER – UDF – User Defined Function to Find Weekdays Between Two Dates
108 May 04, 2007 SQL SERVER – Fix : Error : Msg 7311, Level 16, State 2, Line 1 Cannot obtain the schema rowset DBSCHEMA_TABLES_INFO for OLE DB provider SQLNCLI for linked server LinkedServ

107 May 04, 2007 SQL SERVER – Download SQL Server Management Studio Keyboard Shortcuts (SSMS Shortcuts)
106 May 03, 2007 SQL SERVER – DBCC commands to free several SQL Server memory caches
105 May 03, 2007 SQL SERVER – Enable Login – Disable Login using ALTER LOGIC – Change name of the ‘SA’
104 May 02, 2007 SQL SERVER – FIX : ERROR 1101 : Could not allocate a new page for database because of insufficient disk space in filegroup
103 May 02, 2007 SQL SERVER – 2005 TOP Improvements/Enhancements
102 May 01, 2007 SQL SERVER – User Defined Functions (UDF) to Reverse String – UDF_ReverseString
101 May 01, 2007 SQL SERVER – Copy Column Headers in Query Analyzers in Result Set
100 May 01, 2007 SQLAuthority.com 100th Post – Gratitude Note to Readers
99 Apr 30, 2007 SQL SERVER – Collate – Case Sensitive SQL Query Search
98 Apr 30, 2007 SQL SERVER – FIX : ERROR : Msg 3159, Level 16, State 1, Line 1 – Msg 3013, Level 16, State 1, Line 1
97 Apr 30, 2007 SQL SERVER – SET ROWCOUNT – Retrieving or Limiting the First N Records from a SQL Query
96 Apr 29, 2007 SQL SERVER – 2005 Security DataSheet
95 Apr 29, 2007 SQL SERVER – Random Number Generator Script – SQL Query
94 Apr 29, 2007 SQL SERVER – Replication Keywords Explanation and Basic Terms
93 Apr 28, 2007 SQL SERVER – Explanation SQL SERVER Merge Join
92 Apr 28, 2007 SQL SERVER – Restrictions of Views – T SQL View Limitations
91 Apr 28, 2007 SQL SERVER – Good, Better and Best Programming Techniques
90 Apr 27, 2007 SQL SERVER – Query to Retrieve the Nth Maximum Value
89 Apr 27, 2007 SQL SERVER – 2005 Locking Hints and Examples
88 Apr 27, 2007 SQL SERVER – SELECT vs. SET Performance Comparison
87 Apr 26, 2007 SQL SERVER – Difference Between Unique Index vs Unique Constraint
86 Apr 26, 2007 SQL SERVER – Enable xp_cmdshell using sp_configure
85 Apr 26, 2007 SQL SERVER – 2005 – DBCC ROWLOCK – Deprecated
84 Apr 25, 2007 SQL SERVER – Alternate Fix : ERROR 1222 : Lock request time out period exceeded
83 Apr 25, 2007 SQL SERVER – ERROR Messages – sysmessages error severity level
82 Apr 25, 2007 SQL SERVER – 2005 Take Off Line or Detach Database
81 Apr 24, 2007 SQL SERVER – TRIM() Function – UDF TRIM()
80 Apr 24, 2007 SQL SERVER – Six Properties of Relational Tables
79 Apr 24, 2007 SQL SERVER – 2005 Collation Explanation and Translation
78 Apr 23, 2007 SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server.
77 Apr 23, 2007 SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio
76 Apr 23, 2007 SQL SERVER – Query to Find Seed Values, Increment Values and Current Identity Column value of the table
75 Apr 23, 2007 SQL SERVER – Understanding new Index Type of SQL Server 2005 Included Column Index along with Clustered Index and Non-clustered Index
74 Apr 22, 2007 SQL SERVER – Raid Configuration – RAID 10
73 Apr 22, 2007 SQL SERVER – @@DATEFIRST and SET DATEFIRST Relations and Usage
72 Apr 22, 2007 SQL SERVER – Fix : Error: 1418 – Microsoft SQL Server – The server network address can not be reached or does not exist. Check the network address name and reissue the command</

71 Apr 21, 2007 SQL Server Interview Questions and Answers Complete List Download
70 Apr 20, 2007 SQL Server Interview Questions and Answers – Part 6
69 Apr 19, 2007 SQL Server Interview Questions and Answers – Part 5
68 Apr 18, 2007 SQL Server Interview Questions and Answers – Part 4
67 Apr 17, 2007 SQL Server Interview Questions and Answers – Part 3
66 Apr 16, 2007 SQL Server Interview Questions and Answers – Part 2
65 Apr 15, 2007 SQL Server Interview Questions and Answers – Part 1
64 Apr 15, 2007 SQL Server Interview Questions and Answers – Introduction
63 Apr 14, 2007 SQL SERVER – 64 bit Architecture and White Paper
62 Apr 14, 2007 SQL SERVER – CASE Statement/Expression Examples and Explanation
61 Apr 14, 2007 SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.
60 Apr 13, 2007 SQL SERVER – Stored Procedures Advantages and Best Advantage
59 Apr 13, 2007 SQL SERVER – Script to Find SQL Server on Network
58 Apr 13, 2007 SQL SERVER – 2005 – Disable Triggers – Drop Triggers
57 Apr 12, 2007 SQL SERVER – Fix : Error 1702 CREATE TABLE failed because column in table exceeds the maximum of columns
56 Apr 12, 2007 SQL SERVER – Fix : Error: 3902, Severity: 16; State: 1 : The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
55 Apr 12, 2007 SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System
54 Apr 11, 2007 SQL SERVER – UDF – User Defined Function to Extract Only Numbers From String
53 Apr 11, 2007 SQL SERVER – 2005 – Explanation of TRY…CATCH and ERROR Handling
52 Apr 10, 2007 SQL SERVER – 2005 – Silent Installation – Unattended Installation
51 Apr 10, 2007 SQL SERVER – SP Performance Improvement without changing T-SQL
50 Apr 09, 2007 SQL SERVER – 2005 Reserved Keywords
49 Apr 08, 2007 SQL SERVER – Search Text Field – CHARINDEX vs PATINDEX
48 Apr 07, 2007 SQL SERVER – DBCC Commands Introduced in SQL Server 2005
47 Apr 06, 2007 SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1
46 Apr 05, 2007 SQL SERVER – Performance Optimization of SQL Query and FileGroups
45 Apr 04, 2007 SQL SERVER – Fix: HResult 0×274D, Level 16, State 1 Error: Microsoft SQL Native Client : Login timeout expired.
44 Apr 03, 2007 SQL SERVER – T-SQL Paging Query Technique Comparison – SQL 2000 vs SQL 2005
43 Apr 02, 2007 SQL SERVER – 2005 – Performance Dashboard Reports
42 Apr 01, 2007 SQL SERVER – TempDB is Full. Move TempDB from one drive to another drive.
41 Mar 31, 2007 SQL SERVER – 2005 Best Practices Analyzer (February 2007 CTP)
40 Mar 30, 2007 SQL SERVER – Index Seek Vs. Index Scan (Table Scan)
39 Mar 29, 2007 SQL SERVER – Difference between DISTINCT and GROUP BY – Distinct vs Group By
38 Mar 28, 2007 SQL SERVER – Fix : Error 8101 An explicit value for the identity column in table can only be specified when a column list is used and IDENTITY_INSERT is ON
37 Mar 27, 2007 SQL SERVER – Fix : Error 701 There is insufficient system memory to run this query
36 Mar 25, 2007 SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record
35 Mar 23, 2007 SQL SERVER – Stored Procedure – Clean Cache and Clean Buffer
34 Mar 22, 2007 SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
33 Mar 21, 2007 SQL SERVER – 2005 Security Best Practices – Operational and Administrative Tasks
32 Mar 20, 2007 SQL SERVER – SQL Commandments – Suggestions, Tips, Tricks
31 Mar 16, 2007 SQL SERVER – Fix: Sqllib error: OLEDB Error encountered calling IDBInitialize::Initialize. hr = 0×80004005. SQLSTATE: 08001, Native Error: 17
30 Mar 15, 2007 SQL SERVER – DBCC RESEED Table Identity Value – Reset Table Identity
29 Mar 10, 2007 SQL SERVER – Union vs. Union All – Which is better for performance?
28 Mar 07, 2007 SQL SERVER – Download 2005 SP2a
27 Mar 07, 2007 SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running
26 Mar 05, 2007 SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation
25 Mar 01, 2007 SQL SERVER – Delete Duplicate Records – Rows
24 Feb 28, 2007 SQL SERVER – T-SQL Script to find the CD key from Registry
23 Feb 26, 2007 SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005
22 Feb 25, 2007 SQL SERVER – Restore Database Backup using SQL Script (T-SQL)
21 Feb 24, 2007 SQL SERVER – Download SQL Server 2005 Books Online (February 2007)
20 Feb 24, 2007 SQL SERVER – SQL Server 2005 Samples and Sample Databases (February 2007)
19 Feb 20, 2007 SQL SERVER – Creating Comma Separate List From Table
18 Feb 15, 2007 SQL SERVER – FIX : Error 15023: User already exists in current database.
17 Feb 10, 2007 SQL SERVER – Function to Convert List to Table
16 Feb 05, 2007 SQL SERVER – Primary Key Constraints and Unique Key Constraints
15 Feb 01, 2007 SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case
14 Jan 31, 2007 SQL SERVER – ReIndexing Database Tables and Update Statistics on Tables
13 Jan 30, 2007 SQL SERVER – Query Analyzer Short Cut to display the text of Stored Procedure
12 Jan 26, 2007 SQL SERVER – SQL Joke, SQL Humor, SQL Laugh
11 Jan 20, 2007 SQL SERVER – Query Analyzer Shortcuts
10 Jan 10, 2007 SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database
9 Jan 01, 2007 SQL SERVER – Simple Example of Cursor
8 Dec 30, 2006 SQL SERVER – Shrinking Truncate Log File – Log Full
7 Dec 20, 2006 SQL SERVER – Fix : Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.
6 Dec 10, 2006 SQL SERVER – Find Stored Procedure Related to Table in Database – Search in All Stored Procedure
5 Dec 01, 2006 SQL SERVER – Cursor to Kill All Process in Database
4 Nov 30, 2006 SQL SERVER – Simple Cursor to Select Tables in Database with Static Prefix and Date Created
3 Nov 20, 2006 SQL SERVER – Auto Generate Script to Delete Deprecated Fields in Current Database
2 Nov 10, 2006 SQL SERVER – Query to Find ByteSize of All the Tables in Database
1 Nov 01, 2006 SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database

Comments Off

  • Search
  • About Pinal Dave

    Pinalkumar Dave is a Microsoft SQL Server MVP and a Mentor for Solid Quality India. He has written over 1100 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He was awarded Regional Mentor for PASS Asia.


    LinkedIn - Pinal Dave Twitter - Pinal Dave facebook
    Feed Email

  • Blog Stats

    • 10,703,018 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
    Bookmark and Share
    AddThis Feed Button
  • Top 7 Commenters

      350 - Imran Mohammed
      133- Brian Tkatch
       53 - Jacob Sebastian
       48 - Tejas Shah
       47 - Jerry Hung
       46 - Kuldip Bhatt
       36 - Ashish Gilhotra
  • Categories

    • About Me (61)
    • Best Practices (90)
    • Business Intelligence (14)
    • Data Warehousing (30)
    • Database (267)
    • DBA (124)
    • MVP (97)
    • Poll (5)
    • Readers Contribution (37)
    • Readers Question (44)
    • Software Development (66)
    • SQL Add-On (91)
    • SQL Backup and Restore (54)
    • SQL BOL (10)
    • SQL Coding Standards (20)
    • SQL Constraint and Keys (50)
    • SQL Cursor (28)
    • SQL Data Storage (45)
    • SQL DateTime (37)
    • SQL Documentation (217)
    • SQL Download (222)
    • SQL Error Messages (125)
    • SQL Function (124)
    • SQL Humor (25)
    • SQL Index (93)
    • SQL Interview Questions and Answers (57)
    • SQL Joins (63)
    • SQL Optimization (63)
    • SQL Performance (219)
    • SQL Puzzle (25)
    • SQL Security (119)
    • SQL Server DBCC (42)
    • SQL Server Management Studio (28)
    • SQL Stored Procedure (100)
    • SQL String (19)
    • SQL System Table (50)
    • SQL Trigger (24)
    • SQL User Group (48)
    • SQL Utility (126)
    • SQL White Papers (34)
    • SQLAuthority (368)
      • SQLAuthority Author Visit (80)
      • SQLAuthority Book Review (18)
      • SQLAuthority News (338)
      • SQLAuthority Website Review (28)
    • SQLServer (74)
    • Tech (905)
      • Pinal Dave (895)
      • SQL Scripts (527)
    • Technology (1145)
      • SQL (1145)
      • SQL Authority (1145)
      • SQL Query (1145)
      • SQL Server (1145)
      • SQL Tips and Tricks (1145)
      • T SQL (1145)
  • 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 Interview Questions and Answers Complete List Download
    • 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 - Convert Text to Numbers (Integer) - CAST and CONVERT
    • 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 - 2008 - Interview Questions and Answers Complete List Download
    • SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
    • SQL SERVER - 2005 List All Tables of Database
    • SQL SERVER - Shrinking Truncate Log File - Log Full
    • SQL Server Interview Questions and Answers - Part 1
  • Authors

    • pinaldave
      • SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices
      • SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 4
      • SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 3
      • SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 2
      • SQLAuthority News – SQL PASS Summit, Seattle 2009 – Day 1
      • SQLAuthority News – 3 Year Old Blog – PASS Summit 2009 – 10.5 Million Views
      • SQL Authority News – Advanced T-SQL with Itzik Ben-Gan – Solid Quality Mentors
      • SQLAuthority News – New PASS President Rushabh Mehta
      • SQLAuthority News – India Market and Third Party SQL Server Tools
      • SQLAuthority News – Birds-of-a-Feather (BOF) Lunch – SQL PASS Summit, Seattle, 2009
  • Archives

    • November 2009
    • October 2009
    • September 2009
    • August 2009
    • 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

    • Resume
    • All Articles
    • SQL Interview Q & A
    • Contact Me
      • googledceeba0da7ad381a.html
      • Copyright
      • Contact Me – Archive 1
      • Contact Me – Archive 2
      • Contact Me – Archive 3
  • 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 Joins SQL Optimization SQL Performance SQL Query SQL Scripts SQL Security SQLServer SQL Server SQL Stored Procedure SQL Tips and Tricks SQL Utility Technology T SQL
  •  

    November 2009
    M T W T F S S
    « Oct    
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    30  
  • Add to Technorati Favorites
    Software blogs Blogarama - The Blog Directory
    Technology blogs Programming Blogs - BlogCatalog Blog Directory TopOfBlogs
    Blog Directory
    Visit blogadda.com to discover Indian blogs
    Page copy protected against web site content infringement by Copyscape

Blog at WordPress.com.

Theme: Mistylook by Sadish.