SQL Tips http://blog.namwarrizvi.com By Namwar Rizvi Mon, 05 Apr 2010 21:18:51 +0000 http://wordpress.org/?v=2.7 en hourly 1 Online Content Vacuum Technology in SQL Server 2008 http://blog.namwarrizvi.com/?p=268 http://blog.namwarrizvi.com/?p=268#comments Mon, 05 Apr 2010 21:18:51 +0000 namwar http://blog.namwarrizvi.com/?p=268 http://blog.namwarrizvi.com/?feed=rss2&p=268 Search anything in your Database schema right from SSMS http://blog.namwarrizvi.com/?p=266 http://blog.namwarrizvi.com/?p=266#comments Mon, 29 Mar 2010 09:06:56 +0000 namwar http://blog.namwarrizvi.com/?p=266 http://blog.namwarrizvi.com/?feed=rss2&p=266 How to Install SQL Server 2005 Client Tools? http://blog.namwarrizvi.com/?p=259 http://blog.namwarrizvi.com/?p=259#comments Mon, 31 Aug 2009 22:34:29 +0000 namwar http://blog.namwarrizvi.com/?p=259 http://blog.namwarrizvi.com/?feed=rss2&p=259 How to Query Active Directory (AD) from SQL Server http://blog.namwarrizvi.com/?p=254 http://blog.namwarrizvi.com/?p=254#comments Sun, 30 Aug 2009 22:13:13 +0000 namwar http://blog.namwarrizvi.com/?p=254 http://blog.namwarrizvi.com/?feed=rss2&p=254 What is not Data Mining? - A Myth Buster http://blog.namwarrizvi.com/?p=252 http://blog.namwarrizvi.com/?p=252#comments Sat, 20 Jun 2009 23:49:55 +0000 namwar http://blog.namwarrizvi.com/?p=252 http://blog.namwarrizvi.com/?feed=rss2&p=252 SQL Server Client Tools Setup Fails due to MSXML 6 http://blog.namwarrizvi.com/?p=250 http://blog.namwarrizvi.com/?p=250#comments Mon, 13 Apr 2009 19:34:02 +0000 namwar http://blog.namwarrizvi.com/?p=250 http://blog.namwarrizvi.com/?feed=rss2&p=250 How to create Custom Database Role and Manage its permissions http://blog.namwarrizvi.com/?p=248 http://blog.namwarrizvi.com/?p=248#comments Sun, 05 Apr 2009 20:57:56 +0000 namwar http://blog.namwarrizvi.com/?p=248 http://blog.namwarrizvi.com/?feed=rss2&p=248 TSQL Function to encode HTML Text http://blog.namwarrizvi.com/?p=243 http://blog.namwarrizvi.com/?p=243#comments Tue, 20 Jan 2009 21:43:39 +0000 namwar http://blog.namwarrizvi.com/?p=243 http://blog.namwarrizvi.com/?feed=rss2&p=243 How to use more than 4GB RAM on SQL Server? http://blog.namwarrizvi.com/?p=241 http://blog.namwarrizvi.com/?p=241#comments Thu, 15 Jan 2009 21:49:50 +0000 namwar http://blog.namwarrizvi.com/?p=241 http://blog.namwarrizvi.com/?feed=rss2&p=241 TSQL Function to convert decimal to Hex, Octal or any other base http://blog.namwarrizvi.com/?p=238 http://blog.namwarrizvi.com/?p=238#comments Mon, 12 Jan 2009 22:15:41 +0000 namwar http://blog.namwarrizvi.com/?p=238 http://blog.namwarrizvi.com/?feed=rss2&p=238 Search all columns of all tables for a particular value http://blog.namwarrizvi.com/?p=236 http://blog.namwarrizvi.com/?p=236#comments Thu, 08 Jan 2009 19:37:17 +0000 namwar http://blog.namwarrizvi.com/?p=236 http://blog.namwarrizvi.com/?feed=rss2&p=236 How to find relationship between tables http://blog.namwarrizvi.com/?p=232 http://blog.namwarrizvi.com/?p=232#comments Sat, 03 Jan 2009 21:01:33 +0000 namwar http://blog.namwarrizvi.com/?p=232 http://blog.namwarrizvi.com/?feed=rss2&p=232 Two quickest ways to find file information of a given database http://blog.namwarrizvi.com/?p=224 http://blog.namwarrizvi.com/?p=224#comments Fri, 02 Jan 2009 00:06:23 +0000 namwar http://blog.namwarrizvi.com/?p=224 http://blog.namwarrizvi.com/?feed=rss2&p=224 Review of SQL Server 2005 Service Pack 3 http://blog.namwarrizvi.com/?p=222 http://blog.namwarrizvi.com/?p=222#comments Thu, 01 Jan 2009 23:40:06 +0000 namwar http://blog.namwarrizvi.com/?p=222 http://blog.namwarrizvi.com/?feed=rss2&p=222 Generate rows for missing dates http://blog.namwarrizvi.com/?p=217 http://blog.namwarrizvi.com/?p=217#comments Mon, 10 Nov 2008 21:16:50 +0000 namwar http://blog.namwarrizvi.com/?p=217 http://blog.namwarrizvi.com/?feed=rss2&p=217 Quick technique to retrieve alphanumeric values by using regular expression in TSQL http://blog.namwarrizvi.com/?p=214 http://blog.namwarrizvi.com/?p=214#comments Sun, 14 Sep 2008 00:39:18 +0000 namwar http://blog.namwarrizvi.com/?p=214 http://blog.namwarrizvi.com/?feed=rss2&p=214 Resource Governor in SQL Server 2008 - Beware of catches http://blog.namwarrizvi.com/?p=212 http://blog.namwarrizvi.com/?p=212#comments Thu, 28 Aug 2008 22:06:08 +0000 namwar http://blog.namwarrizvi.com/?p=212 http://blog.namwarrizvi.com/?feed=rss2&p=212 How to copy query results with column headers? http://blog.namwarrizvi.com/?p=209 http://blog.namwarrizvi.com/?p=209#comments Wed, 27 Aug 2008 22:08:20 +0000 namwar http://blog.namwarrizvi.com/?p=209 http://blog.namwarrizvi.com/?feed=rss2&p=209 Deleting ununsed primary keys http://blog.namwarrizvi.com/?p=204 http://blog.namwarrizvi.com/?p=204#comments Tue, 26 Aug 2008 22:39:37 +0000 namwar http://blog.namwarrizvi.com/?p=204 http://blog.namwarrizvi.com/?feed=rss2&p=204 Welcome to SQL Server 2008 http://blog.namwarrizvi.com/?p=202 http://blog.namwarrizvi.com/?p=202#comments Thu, 07 Aug 2008 21:39:43 +0000 namwar http://blog.namwarrizvi.com/?p=202 http://blog.namwarrizvi.com/?feed=rss2&p=202