| 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 |
pinaldave
