| 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 this feature. See help for the stored procedure sp_dbcmptlevel |
| 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 might be necessary to rebuild the log. |
| 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 linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server |
| 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 from a table |
| 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 current command” |
| 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.sql) |
| 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 component is turned off as part of the security configuration for this server |
| 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 |
|