Wednesday, March 10, 2010 Register   Login   
SQL Server
       SQL Server Community Login
       Labs
       SQL Server News
       Register with SQL Community (Free)
       Events
          Submit a SQL Server Event
          SQL-FEST

SQL Server Forums
       SQL Server Discussion Groups (ALL)
       General Discussions
       Troubleshooting Discussions
       Disaster Recovery
       Best Practices
       Performance Tuning
       High Availability
       SQL Security
       Developer Discussions
       DBA Discussions
       Analysis Services
       Reporting Services
       Integration Services
       SQL Server 2008 
       SQL Server Data Services (SSDS)

Articles
       SQL Server Articles Library
       SQL Server Articles (Categorized)
       Database Mirroring Articles
       Installation & Migration Articles
       Service Packs and Hotfixes
       Recent TechNet & MSDN Articles
       Submit an Article
       SQL Clinic
          SQL Server Technology Clinics
          Database Mirroring Clinic

Scripts/Tools
       SQL Server Scripts
       SQL Server Scripts Categorized
       SQL Server Utilities
       Submit SQL Server Scripts
       Submit a SQL Utility / Tool
       SQL Server Tools from SQL Community
          SQL_ConfigSPY
          SQL_ConfigSPY Download
       OpsDB - Operations Database for SQL Server

Tips & Tricks
       SQL Server Tips and Tricks
       SQL Tip of the Day
       Submit a SQL Server Tip

Blogs
       SQL Server Blogs
       -------------------------------
       XML Team
       Data Platform Team
       Data Services
       SQL Protocols 
       ADO.NET 
       Native Client

Job Board
       SQL Server Job Opportunities
       Submit your Resume
       Post a SQL Server Job Opening
       SQL Server Job Postings 

Videos

Community
       Evangelize SQL Server Community
       Request SQL Hotfix
       Submit a SQL Server Bug/Feedback
       Submit Your SQL Server Wish
       SQL-FEST Registrations
       SQL Server Community Regional Manager
       SQL Server Community Newsletter 
       SQL_ConfigSPY
       Resources
          SQL Server Headlines
          SQL Server FAQ's and Resources
          SQL Server Lab
          SQL Server Upgrade Central
          SQL Server Wikipedia
          SQL Server Teams at Microsoft
             SQL Server Best Practices by SQLCAT Team
             SQL Server Storage Engine Team
             SQL Server Protocols Team
             SQL Server Performance Engineering Team
             SQL Server CLR Integration Team
             SQL Server Programability & API Development Team
             SQL Server Product Support Services Team
             SQL Server Query Processing Team
             SQL Server Managaebility Team
             SQL Server ISV PM Team
             SQL Server OS Team
             SQL Server Security Team
             SQL Server Service Broker Team
             SQL Server User Education Team
          SQL Server 2008
          Microsoft Community Codeplex
          SQL Server by Microsoft Employees
             Reporting Services by Bob Meyers
             Reporting Services by Brian Welcker
             Database Administration by Buck Woody
             SQL Server by Euan Garden
             Spatial Data by Isaac Kunen
             Analysis Services by Jamie MacLenaan
             Reporting Services by John Gallardo
             Integration Services by Kirk Haselden
             Reporting Services by Chris Hays
             XML by Michael Rys
             Data Platform by Roger Doherty
             Data Management and SOA by Roger Walter
             SQL Server Compact Edition by Steve Lasker
             Data Platform by Zack Owens
             SQL Server by Vipul Shah
             SQL Server by Dan Jones
          SQL Server Downloads 
             SQL Server 6.x / 7.0 Downloads
             SQL Server 2000 Downloads
             SQL Server 2005 Downloads
          SQL Server Best Practices
       Bellevue College - DBA-232 Class
       About SQL Community
   You Are Here: Tips & Tricks » SQL Server Tips and Tricks      

Submit Articles  Upload Scripts   Submit Tips   Start a Blog   Upload Tools   Post Job Openings   Submit Your Resume   About SQL Community
  

SQL Server Tips (Tips, Tricks & Techniques by SQL Server Gurus)

SQL Server TipAuthorDate
To find second highestvalue in the columnArjun PatilAug 03, 2009
Database High AvailabilitySilin KuangJun 16, 2009
SQL Server DBA & Developer Tools & UtilitiesSQL Server CommunityApr 21, 2009
Uninstall SQL ServerKishore PNov 24, 2008
Findind Occurrences of Text in the DatabaseJohn MagnaboscoAug 22, 2008
Finding An Occurrence of a ColumnJohn MagnaboscoJun 15, 2008
List Indexes for all Tables in a Databasephani tataMay 17, 2008
UPDATE Based Off of A TableJohn MagnaboscoApr 24, 2008
Configuring Virtual Memory for SQL Server SystemSQL Server CommunityApr 10, 2008
Using the REPLICATE MethodJohn MagnaboscoMar 25, 2008
Update column sequentiallyAmol RajmaneMar 24, 2008
The hidden safety feature of RESTORE operation in SQL Server 2005.SQL Server CommunityMar 24, 2008
Planning on rebuilding Master database?SQL Server CommunityMar 24, 2008
Guidelines for configuring MAXDOP in your environmentCindy GrossMar 24, 2008
Maintain High Availability of Large Tables during Index CreationSaleem HakaniMar 19, 2008
Querying I/O StatisticsJohn MagnaboscoMar 15, 2008
Included ColumnsKalen DelaneyMar 10, 2008
Configuring Management Studio to load Query Window by defaultSaleem HakaniMar 10, 2008
Report will not display from a snapshotMichael HotekMar 08, 2008
Quickly compare rows to determine if anything changedMichael HotekMar 08, 2008
Report Snapshot generation returns an errorMichael HotekMar 08, 2008
DTS changes introduced in SSISSaleem HakaniMar 07, 2008
Fixing Orphaned Windows Logins in SQL 2005louis nguyenMar 03, 2008
BOL: Keep it Updated by Clicking Here + Bonus ContentaspiringgeekMar 02, 2008
SQL 2005 BOL: Launch dexplore for Stand-Alone Version w/o SSMSaspiringgeekMar 02, 2008
FragmentationKalen DelaneyFeb 28, 2008
Table Variables: One Index or Two?aspiringgeekFeb 22, 2008
Table VariablesaspiringgeekFeb 22, 2008
SQL Server Speedy File InitializationSaleem HakaniFeb 14, 2008
Determine SET options for a sessionKalen DelaneyFeb 14, 2008
Defrag your indexes the right way using "ALTER INDEX.. REORGANIZE"Ramanuj BrahmacharyFeb 14, 2008
What you MUST know about starting and stopping SQL Server Services.Saleem HakaniFeb 14, 2008
Create your own hotkeysKalen DelaneyFeb 14, 2008
Re-Using SQL Server System Database files during SQL Server Installation.Saleem HakaniFeb 14, 2008
Chunking Data Modifications/Deletions in SQL Server 2005Saleem HakaniFeb 14, 2008
Examining trace informationKalen DelaneyFeb 14, 2008
Quick BOL Search onlineKalen DelaneyFeb 14, 2008
Choosing SET vs. SELECTJohn MagnaboscoFeb 14, 2008
Reliably benchmarking code in isolationMichael HotekFeb 14, 2008
Determine if the data in two tables is exactly the sameMichael HotekFeb 14, 2008
123
  
SQL Server  |  SQL Server Forums  |  Articles  |  Scripts/Tools  |  Tips & Tricks  |  Blogs  |  Job Board  |  Videos
Copyright 2007 by www.sqlcommunity.com    Terms Of Use   Privacy Statement