http://www.sqlcommunity.comMicrosoft SQL Server Communityen-USCopyright 2007 by www.sqlcommunity.comsqlgurus@sqlcommunity.com The following simple command used to uninstall SQL Server. rem    SQL2005 start /wait...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Nov 2008 09:04:25 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=357 There are times that may demand that we need to find the occurrence of any text within many databa...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 22 Aug 2008 10:44:35 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=331 Have you ever needed to find multiple occurrences of a column in a database schema? Consider using ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 16 Jun 2008 02:35:10 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=297/************************************************************************************ Full Version o...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 16 May 2008 16:51:28 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=259 INSERT offers the ability to insert into a table based upon a SELECT statement with the following s...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 24 Apr 2008 10:27:23 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=242 Did you know that Windows Server will allow you to operate without having a paging file but this is...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 10 Apr 2008 18:08:19 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=236 The creation of a fixed length file from the results of a SELECT statement presents challenges that...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 25 Mar 2008 20:30:27 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=224 This example can be very useful if you would want to add sequence number to a column.Below example ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Mar 2008 21:01:37 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=223 What happens when you try to restore a database called Sales over an existing database called Human...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Mar 2008 09:13:07 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=222 You must rebuild the Master database only when it is damaged and if it’s not damaged it’s highly r...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Mar 2008 08:54:00 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=221 It can be difficult to know how to configure the maximum degree of parallelism statement on each S...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Mar 2008 08:29:18 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=220   There are ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 19 Mar 2008 04:28:49 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=216 To view I/O statistics for database and log files, use fn_virtualfilestats. The arguments for t...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSat, 15 Mar 2008 04:57:33 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=210 The main reason for included columns is to allow you to have covering indexes in situations wher...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 11 Mar 2008 01:09:08 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=206 How do you make SQL Server Management studio to open Query Editor by default? SQL Server 2005 ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 10 Mar 2008 09:08:08 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=205Even after you have drop kicked SSRS by resetting the service credentials and the report snapshot wi...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSun, 09 Mar 2008 04:38:12 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=204Quite frequently, you have to load data from another system. One of the biggest hassles during this...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSun, 09 Mar 2008 04:29:45 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=203You've gotten SSRS configured properly, created a report, uploaded the report, and are now trying to...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSun, 09 Mar 2008 04:22:03 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=202 Upgrade your DTS Packages to SSIS (SQL Server Integration Services) If you are using DTS ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 07 Mar 2008 19:41:48 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=200 With SQL2000, the sp_sidmap procedure was used to fix orphaned windows and sql logins as detailed i...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 03 Mar 2008 20:16:08 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=196 SQL Server 2000 Books Online (BOL) has been updated only once in its entire tenure (a very welcome ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 03 Mar 2008 03:43:15 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=194 Have you ever needed to open SQL 2005 BOL but were discouraged by the slow speed with which SSMS lo...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 03 Mar 2008 03:27:07 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=193   When you use one of the fragmentation reporting tools, either DBCC SHOWCONTIG (for SQL Ser...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 28 Feb 2008 23:11:46 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=191 Customers often tell me that they avoid table variables owing to the lack of ability to index them....http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSat, 23 Feb 2008 03:24:05 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=186 Table variables are temporary table objects along with local & global temporary tables.  Table vari...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSat, 23 Feb 2008 03:13:32 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=185Windows XP installs IIS 5.1. SQL Server setup requires the .NET Framework 2.0. When you install th...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 13 Feb 2008 21:12:58 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=177Reporting Services has a dependency on IIS. If you do not have IIS installed, then SQL Server setup...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 13 Feb 2008 21:08:02 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=176 This is a feature I have been wanting for many years. I love the graphical showplan representation,...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 12 Feb 2008 03:05:44 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=172You can right click on a specific object and generate a script or you can launch the script generati...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:35:29 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=166If you ever need to sequentially number the rows in a table, you could design a process that utilize...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:34:33 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=165By default, all SQL Server instances are set to broadcast their presence on the network. The networ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:32:52 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=164SQL Server has allowed you to directly backup a database to a UNC path for several versions. Howeve...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:31:22 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=163By default, SQL Server will only retain 7 error logs (active + 6 archives). In disaster situations ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:30:25 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=162Each time you stop a SQL Server instance, the SQL Server error log is closed. Each time you restart...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:28:59 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=161In many cases you need to compare the contents of two tables of identical structure in order to dete...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:26:54 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=160One of the more dififcult things to do is to get accurate performance data when you are testing code...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 08 Feb 2008 20:23:25 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=159 The use of local variables within T-SQL is something that is very common. The two methods in which...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 07 Feb 2008 20:40:40 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=155   The User Education Team at Microsoft are some of my favorite people. They've put out a new too...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 06 Feb 2008 18:23:14 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=153 SQL Server 2005's new metadata gives us sys.traces, which contains all the information provided by ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 01 Feb 2008 17:21:16 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=138  In SQL Server 2005 TOP operator can be used for Deleting, Interting and Updating data. This can...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 30 Jan 2008 19:33:02 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=137 Consider a situation where your SQL Server installation has to be re-installed because the opera...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 28 Jan 2008 08:59:49 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=136 In the Management Studio, go to the Tools menu and choose Options. Under Environment, choose Keyboa...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 28 Jan 2008 00:02:25 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=135 Did you know that when SQL Server service account is configured with a Windows NT account, SQL Serv...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 25 Jan 2008 09:32:42 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=134 There may be times when you see spikes in Performance Monitor on your SQL Server machine, such as a...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 24 Jan 2008 20:55:09 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=132 ALTER INDEX .... REORGANIZE, requires the Index option "ALLOW_PAGE_LOCKS" enabled. Also, it canno...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 23 Jan 2008 23:33:13 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=131 A SQL Server Tips site posted a tip recently on how to retrieve the SET options for your current co...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 23 Jan 2008 05:42:38 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=130 I know I did when SSMS was released. That was until I found out I could get back my SQL Server 2000...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 22 Jan 2008 16:57:22 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=129 In SQL Server, data and log files are initialized to overwrite any existing data left on the disk f...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 21 Jan 2008 01:24:15 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=127The situation in which I use this the most is when building sample tables for testing purposes. I ca...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 18 Jan 2008 19:58:06 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=125If you are allowing SQL Server standard logins for access to your SQL Server, then you must ensure t...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 18 Jan 2008 06:49:23 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=123You can apply row filters to an article in order to only synchronize a subset of rows within a table...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 18 Jan 2008 06:20:42 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=122As of SQL Server 2005, you can replicate DDL change from publisher to subscriber. All DDL changes h...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 18 Jan 2008 06:10:21 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=121When you upgrade from SQL 2005 to SQL 2008, make sure to run sp_updatestats so that way the engine c...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 17 Jan 2008 16:39:41 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=120   SIMPLE Recovery Mode does NOT mean that your transactions are not logged. There will be loggin...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 14 Jan 2008 23:12:52 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=111 Did you know that when SQL Server service account is configured with a Windows NT account, SQL Ser...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 11 Dec 2007 23:14:05 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=108 Did you know that in SQL Server 2000, the engine used to maintain two copies/versions of each SQL ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 04 Dec 2007 08:32:47 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=106   Let's call the doctor DETA for issues related to databases.. ITW (Index Tuning Wizard) h...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 04 Dec 2007 08:27:39 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=105   With the introduction of SQL Server 2005, Microsoft added a command called  TABLESAMPLE that...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 04 Dec 2007 08:17:24 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=104 The Resource database is a read-only database that contains all the system objects that are include...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 26 Nov 2007 10:32:16 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=99 The master database records all the system-level information for a SQL Server system. This includes...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 26 Nov 2007 10:03:07 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=98 Are you getting "A required privilege is not held by the client" error when running a SQL Server A...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 15 Nov 2007 15:47:40 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=97 What to do when your Resource database becomes corrupt or if it needs to be moved to some other lo...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 15 Nov 2007 15:24:13 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=96 SQL Server 2005 introduces a new syntax with ALTER DATABASE statement for page verification, which...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 01 Nov 2007 18:44:43 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=95   Almost everyone using SQL Server knows the default port number for SQL Server and with ser...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 01 Nov 2007 18:39:06 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=94   Ever wondered how to get the accurate SQL Server location programatically? Below script can h...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 29 Oct 2007 01:03:58 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=92 You can now audit your changes using DML statements without even using TRIGGERS:   SQL S...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 24 Oct 2007 08:13:33 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=90 To determine how many tables you have in the database, number of rows in each table, size of table ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 24 Oct 2007 07:51:54 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=89 Make sure you run DBCC UPDATEUSAGE right after your databases are upgraded from SQL Server 20...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 22 Oct 2007 09:39:57 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=88 The following are a sample of commonly-used DBA features that are depreciated in SQL 2005 and ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 22 Oct 2007 09:26:51 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=87 Several of the components provided in DTS 2000 have been moved around, renamed, improved, or elimi...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 18 Oct 2007 14:52:12 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=85 How many times have you receieved an s tip we will talk about how T-Logs are shrunk and some of th...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 17 Oct 2007 10:56:21 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=84 With SQL Server 2005 you can now share job schedules that are owned by same user. For example if...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 16 Oct 2007 09:31:42 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=80 Many developers have always wanted to find out ways with which they can open SQL Server Query Edi...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 15 Oct 2007 09:23:45 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=76     SQL Server 2005 out of the box comes with a default trace that's always running which ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 15 Oct 2007 08:36:15 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=75   Did you know that you can auto-execute a stored procedure in SQL Server whenever SQL Ser...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 15 Oct 2007 08:31:42 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=74   Encryption functions introduced in SQL 2005 can be used to encrypt sensitive data such as ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 12 Oct 2007 06:51:27 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=72 Changing the date format at the server level.   There are times when you may want to c...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 12 Oct 2007 05:01:57 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=69 Q1) How many system databases do we have in SQL Server 2000? A) Your answer would be 4 (...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 11 Oct 2007 09:47:50 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=67   In SQL Server 2000 or it's earlier versions, if you perform a backup of a database out of s...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 10 Oct 2007 17:53:08 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=58     One of the common complaints I get is that SQL Server CPU started spiking excessively...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxWed, 10 Oct 2007 07:25:34 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=57 Keep in mind Named pipes are of two types: (Local and Network) Local Named Pipes: I...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSun, 07 Oct 2007 01:05:45 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=55     DBCC DBREINDEX command has been deprecated in SQL Server 2005 (Meaning that it will no l...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxFri, 05 Oct 2007 15:44:12 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=51 With SQL Server 2005 you can now share job schedules that are owned by same user. For exampl...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 04 Oct 2007 10:22:36 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=48 You are in a situation to execute a dbcc checkdb for a database which is mirrored to a second inst...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 04 Oct 2007 00:33:07 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=46 You can now create an alias for objects in SQL Server 2005. D'you remember how uneasy it was...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 02 Oct 2007 16:08:31 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=45 Do you know that identity column is always preferred rather than just a primary key to avoid page s...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 02 Oct 2007 15:32:42 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=44 If the  transaction log grows large and you want a quick way to shrink it without using SHRINK sta...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxTue, 02 Oct 2007 11:43:03 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=43   Say you have a glass fully filled with water and you try to put more water in that glass, w...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 01 Oct 2007 11:45:28 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=42 Being a DBA did you ever wanted to know who is logging on to your server and at what time? Ever fel...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSun, 30 Sep 2007 06:25:07 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=40 Tip submitted by: Saleem Hakani   Did you know that Non-clustered indexes have t...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSat, 29 Sep 2007 21:54:08 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=39   Tip submitted by: Saleem Hakani You must have experienced this scenar...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 27 Sep 2007 04:28:54 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=37   There may be times when you see spikes in Performance Monitor on your SQL Server machine,...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 27 Sep 2007 04:26:04 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=36 If you are using Enterprise Edition of SQL Server 2005, you can control the number of processo...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 27 Sep 2007 04:23:51 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=35   Tip submitted by: Saleem Hakani   Releases of SQL Server before SQL Serv...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 27 Sep 2007 04:20:40 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=34 Tip submitted by: Saleem Hakani Gone is the history when EXECUTE or EXEC ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:38:03 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=32 Tip submitted by: Saleem Hakani No, not the WIFI.. WIFI but Windows Instant File ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:32:52 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=31 Tip submitted by: Saleem Hakani RESTORING a database from backup is simply a ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:29:20 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=30 Tip submitted by: Saleem Hakani Say you have a linked server and you are issuing ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:25:38 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=29 Tip submitted by: Saleem Hakani With the release of SQL Server 2005, Microsoft ha...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:21:03 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=28 There are times when you may want to create indexes on large tables which may take huge amount...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:14:59 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=27 Tip submitted by: Saleem Hakani Starting with SQL Server 2005, putting user dat...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:10:14 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=26 Tip submitted by: Saleem Hakani The famous tool for rebuilding system databas...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxMon, 24 Sep 2007 07:05:49 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=25 Tip submitted by: Saleem Hakani One of the best features of SQL Server 2005 is ...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSun, 23 Sep 2007 23:38:16 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=24   Tip submitted by: Saleem Hakani When performing SQL Server 2005 disaster...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxSun, 23 Sep 2007 23:22:23 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=22   The famous tool for rebuilding system databases that existed until SQL Server 2000 is n...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 20 Sep 2007 19:28:50 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=21   Tip submitted by: Saleem Hakani   What if you have 100's of SQL Server...http://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspxThu, 20 Sep 2007 19:23:56 GMThttp://www.sqlcommunity.com/TipsTricks/SQLTipoftheDay/tabid/77/language/en-US/Default.aspx?id=20