http://www.sqlhacks.com/Site/AllRecentChanges?action=rss Site.AllRecentChanges Thu, 22 Apr 2010 03:35:23 GMT http://www.sqlhacks.com/Main/HomePage Syv 2010-04-22T03:35:23Z Thu, 22 Apr 2010 03:35:23 GMT http://www.sqlhacks.com/Main/Feedback Syv Ritch 2010-04-15T04:24:03Z Thu, 15 Apr 2010 04:24:03 GMT http://www.sqlhacks.com/Administration/Administration Web pages related to the administration of Microsoft SQL Server Syv 2010-04-15T04:16:26Z Thu, 15 Apr 2010 04:16:26 GMT http://www.sqlhacks.com/Optimize/Not-Shrink Why you should NOT shrink a Microsoft SQL Server database Syv Ritch 2009-01-16T01:49:15Z Fri, 16 Jan 2009 01:49:15 GMT http://www.sqlhacks.com/FAQs/Connecton-SessionID Connection vs Session_ID with Microsoft SQL Server Syv Ritch 2008-05-19T04:01:36Z Mon, 19 May 2008 04:01:36 GMT http://www.sqlhacks.com/FAQs/ProcessingLogic It's important to understand in which order does MS SQL Server process SQL statements syv Ritch 2008-05-18T23:46:06Z Sun, 18 May 2008 23:46:06 GMT http://www.sqlhacks.com/Administration/Empty-Log How to completely empty the transaction log with Microsoft SQL Server Syv Ritch 2008-05-15T16:58:21Z Thu, 15 May 2008 16:58:21 GMT http://www.sqlhacks.com/Administration/Transactions-In-Logs What are the transaction in the log with Microsoft SQL Server Syv Ritch 2008-05-12T20:53:30Z Mon, 12 May 2008 20:53:30 GMT http://www.sqlhacks.com/Summary/Row-Count Row count for all the tables in a database with Microsoft SQL Server Syv Ritch 2008-05-08T18:39:20Z Thu, 08 May 2008 18:39:20 GMT http://www.sqlhacks.com/Administration/Row-Count-Inaccurate Inaccurate row count with Microsoft SQL Server Syv Ritch 2008-05-05T16:29:43Z Mon, 05 May 2008 16:29:43 GMT http://www.sqlhacks.com/Administration/ShrinkDB-Backup-Logs What is the difference between ShrinkDB and backup logs with Microsoft SQL Server Syv Ritch 2008-05-02T16:19:15Z Fri, 02 May 2008 16:19:15 GMT http://www.sqlhacks.com/Administration/Difference-Performance-Monitor Difference in monitoring performance between Microsoft SQL Server 2000 and Microsoft SQL Server 2005/2008 Syv Ritch 2008-04-24T00:59:58Z Thu, 24 Apr 2008 00:59:58 GMT http://www.sqlhacks.com/Retrieve/Duplicates How to find duplicate rows with Microsoft SQL Server Syv Ritch 2008-04-09T20:42:03Z Wed, 09 Apr 2008 20:42:03 GMT http://www.sqlhacks.com/Retrieve/InlineViews How to use alias and inline views with Microsoft SQL Server Syv Ritch 2008-03-11T21:18:28Z Tue, 11 Mar 2008 21:18:28 GMT http://www.sqlhacks.com/Optimize/SmallDateTime What's the difference between SmallDateTime and DateTime with MS SQL Server syv Ritch 2008-03-05T15:44:24Z Wed, 05 Mar 2008 15:44:24 GMT http://www.sqlhacks.com/Dates/DateFunctions Microsoft SQL Server and date functions Syv Ricth 2008-03-03T17:04:10Z Mon, 03 Mar 2008 17:04:10 GMT http://www.sqlhacks.com/Optimize/SlowNegativeQueries Why are negative so slow with Microsoft SQL Server Syv Ritch 2008-02-29T15:59:55Z Fri, 29 Feb 2008 15:59:55 GMT http://www.sqlhacks.com/Dates/Monday-To-Frida How to cover the dates of Monday to Friday for a business week with Microsoft SQL Server Syv Ritch 2008-02-25T16:49:32Z Mon, 25 Feb 2008 16:49:32 GMT http://www.sqlhacks.com/FAQs/Naming-Conventions How to name columns with Microsoft SQL Server Syv Ritch 2008-02-22T16:27:02Z Fri, 22 Feb 2008 16:27:02 GMT http://www.sqlhacks.com/FAQs/Table-Names How to name tables with Microsoft SQL Server Syv Ritch 2008-02-21T15:39:37Z Thu, 21 Feb 2008 15:39:37 GMT http://www.sqlhacks.com/FAQs/Index-Names How to name keys with Microsoft SQL Server Syv Ritch 2008-02-20T16:45:41Z Wed, 20 Feb 2008 16:45:41 GMT http://www.sqlhacks.com/FAQs/Uptimes Uptimes and consequences Svy Ritch 2008-02-19T16:17:40Z Tue, 19 Feb 2008 16:17:40 GMT http://www.sqlhacks.com/Summary/Group-By-All How to create empty groups with Microsoft SQL Server Syv Ritch 2008-02-18T17:25:56Z Mon, 18 Feb 2008 17:25:56 GMT http://www.sqlhacks.com/Administration/Db-Status What the fastest way of finding the databases and their status with Microsoft SQL Server Syv Ritch 2008-02-15T16:37:32Z Fri, 15 Feb 2008 16:37:32 GMT http://www.sqlhacks.com/FAQs/Stored-Procedures-Text What are the definitions of the MS stored procedures Syv Ritch 2008-02-14T22:14:25Z Thu, 14 Feb 2008 22:14:25 GMT http://www.sqlhacks.com/FAQs/Lock-Escalation Lock Escalation with Microsoft SQL Server Syv Ritch 2008-02-13T17:35:52Z Wed, 13 Feb 2008 17:35:52 GMT http://www.sqlhacks.com/FAQs/Critical-System-Tables What are the Microsoft SQL Server critical system tables Syv Ritch 2008-02-12T17:45:57Z Tue, 12 Feb 2008 17:45:57 GMT http://www.sqlhacks.com/FAQs/Dynamic-Views-2005 Dynamic Management Views with Microsoft SQL Server 2005 Syv Ritch 2008-02-08T17:29:35Z Fri, 08 Feb 2008 17:29:35 GMT http://www.sqlhacks.com/Dates/UTC-Vs-Local-Time How to deal with different local time zones with Microsoft SQL Server Syv Ritch 2008-02-07T19:19:03Z Thu, 07 Feb 2008 19:19:03 GMT http://www.sqlhacks.com/Retrieve/Retrieve-Every-N-Row How to select every 12345th row with Microsoft SQL Server 2005 Syv Ritch 2008-02-05T17:43:43Z Tue, 05 Feb 2008 17:43:43 GMT http://www.sqlhacks.com/Optimize/Release-Unused-Space How to release database unused space with Microsoft SQL Server 2005 Syv Ritch 2008-02-04T17:34:38Z Mon, 04 Feb 2008 17:34:38 GMT http://www.sqlhacks.com/FAQs/Deprecated-System-Management-Views-2005 Deprecated system tables in Microsoft SQL Server 2005 syv Ritch 2008-02-01T17:18:58Z Fri, 01 Feb 2008 17:18:58 GMT http://www.sqlhacks.com/Optimize/Deprecate-Text Why is Text and Ntext slow on Microsoft SQL Server 2005 Syv Ritch 2008-01-31T17:30:41Z Thu, 31 Jan 2008 17:30:41 GMT http://www.sqlhacks.com/Retrieve/Emulate-Boolean How to emulate a boolean with Microsoft SQL Server Syv Ritch 2008-01-30T17:02:19Z Wed, 30 Jan 2008 17:02:19 GMT http://www.sqlhacks.com/Administration/Memory-Usage How is Microsoft SQL Server using memory? Syv Ritch 2008-01-29T17:44:25Z Tue, 29 Jan 2008 17:44:25 GMT http://www.sqlhacks.com/Retrieve/Round-Nearest-Point5 How to round to the nearest .5 with Microsoft SQL Server Syv Ritch 2008-01-28T17:13:52Z Mon, 28 Jan 2008 17:13:52 GMT http://www.sqlhacks.com/Dates/Person-Age How to calculate somebody's age with Microsoft SQL Server Syv Ritch 2008-01-25T22:30:14Z Fri, 25 Jan 2008 22:30:14 GMT http://www.sqlhacks.com/Retrieve/File-Exist How do you know if your file exists with Microsoft SQL Server Syv Ritch 2008-01-24T16:53:24Z Thu, 24 Jan 2008 16:53:24 GMT http://www.sqlhacks.com/Retrieve/Database-Exist How do you know if your database exists with Microsoft SQL Server Syv Ritch 2008-01-24T15:52:24Z Thu, 24 Jan 2008 15:52:24 GMT http://www.sqlhacks.com/Administration/Stored-Procedures What are the stored procedures with Microsoft SQL Server Syv Ritch 2008-01-22T21:07:38Z Tue, 22 Jan 2008 21:07:38 GMT http://www.sqlhacks.com/Retrieve/Isnumeric-problems Why does isnumeric incorrectly identify numeric values in Microsoft SQL Server Syv Ritch 2008-01-22T17:05:21Z Tue, 22 Jan 2008 17:05:21 GMT http://www.sqlhacks.com/Administration/Dedicated-Administrator-Command-Line How to access a running instance of SQL Server Database Engine to troubleshoot MSSQL Microsoft SQL Server from the command line Syv Ritch 2008-01-21T16:55:46Z Mon, 21 Jan 2008 16:55:46 GMT http://www.sqlhacks.com/Retrieve/Sort-Order What's the sort order with Microsoft SQL Server Syv Ritch 2008-01-18T15:59:34Z Fri, 18 Jan 2008 15:59:34 GMT http://www.sqlhacks.com/Administration/Remote-Dedicated-Administrator-Connection How to access a running instance of SQL Server Database Engine to troubleshoot Microsoft SQL Server from a remote computer Syv Ritch 2008-01-17T16:53:06Z Thu, 17 Jan 2008 16:53:06 GMT http://www.sqlhacks.com/Administration/Dedicated-Administrator-Connection-Studio How to access a running instance of SQL Server Database Engine to troubleshoot Microsoft SQL Server with SQL Server Management Studio Syv Ritch 2008-01-16T16:49:03Z Wed, 16 Jan 2008 16:49:03 GMT http://www.sqlhacks.com/Dates/Search-By-Month-Year How to search and group by month and year with Microsoft SQL Server Syv Ritch 2008-01-15T19:21:38Z Tue, 15 Jan 2008 19:21:38 GMT http://www.sqlhacks.com/Dates/Search-By-Year How to search and group by year with Microsoft SQL Server Syv Ritch 2008-01-14T19:43:26Z Mon, 14 Jan 2008 19:43:26 GMT http://www.sqlhacks.com/Optimize/Tempdb-Stats How busy is Tempdb in Microsoft SQL Server Syv Ritch 2008-01-11T17:53:36Z Fri, 11 Jan 2008 17:53:36 GMT http://www.sqlhacks.com/Retrieve/Sort-Nulls-Last How to sort NULLs so they appear last instead of first with Microsoft SQL Server Syv Ritch 2008-01-10T17:51:56Z Thu, 10 Jan 2008 17:51:56 GMT http://www.sqlhacks.com/Retrieve/Sort-IP-Address How to sort and deal with IP addresses in Microsoft SQL Server Syv Ritch 2008-01-09T17:18:03Z Wed, 09 Jan 2008 17:18:03 GMT