http://www.sqlcommunity.comMicrosoft SQL Server Communityen-USCopyright 2007 by www.sqlcommunity.comsqlgurus@sqlcommunity.com   Introduction: This post describes a new feature in SQL Server 2008 – Grouping Sets T...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxSun, 28 Dec 2008 17:04:28 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=387 Please click on the download button to download this article. http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxFri, 19 Dec 2008 13:44:52 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=383 When you are involved with a group of DBA developers and you want to retrieve the objects that were...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxTue, 28 Oct 2008 15:12:20 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=352  Click on the Download button below to download a copy of this presentation. http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxSun, 26 Oct 2008 19:04:08 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=350 In any case, the above solutions would require some patience and hard-work. However, there’s a bet...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxMon, 06 Oct 2008 10:17:14 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=347 Compound Assignment operators and Direct Assignment support in SQL Server 2008 We all ha...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxFri, 05 Sep 2008 11:56:14 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=333BEST PRACTICES FOR WRITING BETTER SQL Background: The performance of SQL query that we write for d...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxSun, 10 Aug 2008 04:31:08 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=323 In addition to raw disk space you will want to consider number of physical disks, SAN vs. local di...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxTue, 15 Jul 2008 07:42:32 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=316 SQL Injection is a method where people are able to change the code submitted to SQL to something el...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxTue, 15 Jul 2008 07:35:51 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=315 (this is one of the article i posted on our local intranet repository; hope it will be helpful to o...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 10 Jul 2008 10:57:33 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=307 Hello Mates,     Today I am going to buzz on Error Handing in Sql Server 2005. ...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxTue, 01 Jul 2008 10:27:20 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=304 MICROSOFT SQL SERVER SUPPORT KNOWLEDGE BASE By Louis Nguyen   Microsoft Su...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxTue, 01 Jul 2008 04:38:26 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=303 HOW TO CONFIGURE MEMORY FOR SQL SERVER By Louis Nguyen MAXIMIZE DATA THROUGHPUT FOR NE...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 19 Jun 2008 15:54:38 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=299 SQL Community Introduces New OPSDB Section (SQL Server Automation Scripts) . Visit OpsDB Section ...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxTue, 03 Jun 2008 17:18:59 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=293 HOW TO LAYOUT DISK LUNS By Louis Nguyen EXISTING VANILLA DATABASES This article as...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 22 May 2008 15:01:35 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=262 Have you heard about the new Service Broker functionality in SQL Server but don't know where to s...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 15 May 2008 08:33:11 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=256 Finding out which build is the latest or what fixes are included in a particular build can be dif...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 15 May 2008 08:30:11 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=255 Row Constructors in SQL Server 2008 We all know the fact that ISUD transactions are the ...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxSun, 11 May 2008 18:19:55 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=247   People reading this post might really wonder of having read /heard about a concept on Depen...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxSat, 03 May 2008 15:30:45 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=245 Microsoft has recently revised the documentation on the below message due to our recent history wi...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxFri, 02 May 2008 08:11:55 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=244 A Universal Data Link (UDL) can be very useful in troubleshooting SQL Server and Analysis Services...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxFri, 02 May 2008 08:09:44 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=243 Sliding Window technique is commonly used with partitioned tables to manage large data volumes. It...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxMon, 14 Apr 2008 05:42:31 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=238   There’s not much reason to run 32bit at all anymore. All new hardware is 64bit, though you ca...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxMon, 14 Apr 2008 05:35:40 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=237 In this article we will share some of the common reasons for slow-running queries and what your ap...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxTue, 08 Apr 2008 21:50:49 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=235 In reviewing the scaling up and scaling out guidelines, it becomes clear that there is a spectrum ...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxWed, 02 Apr 2008 22:02:20 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=230 Ever wondered why sometimes the stored procedure performs bad when deployed on the production SQL ...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxMon, 31 Mar 2008 09:13:34 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=229 Do you put SQL Server and Analysis Services on the same machine or different machines? How do you c...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxWed, 26 Mar 2008 06:13:57 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=225 Some SQL Server troubleshooting and investigation requires checking operating system configuration...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 20 Mar 2008 19:28:05 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=218 For years now there's been a constant war between MS supporters and Oracle supporters. Oracle has t...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 20 Mar 2008 19:22:46 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=217 BELIEVE IT OR NOT !!  The size and physical placement of the tempdb database can affect the per...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxMon, 17 Mar 2008 20:55:02 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=213 That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type. ...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxMon, 17 Mar 2008 11:53:05 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=211   This article details the steps to automate the generation of Sql profiler traces in a Te...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxFri, 14 Mar 2008 08:14:09 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=209 Database snapshot performance is closely tied to the I/O capabilities of the system. This white pap...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 28 Feb 2008 08:25:17 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=190 When I execute DBCC SHOW_STATISTICS, there is a column in the first line of output called “strin...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxWed, 13 Feb 2008 21:59:06 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=178 SQL Server 2005 makes your DBCC CHECK* commands much more user-friendly by running them against a h...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxSun, 10 Feb 2008 22:32:47 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=169 Before I answer that question, let’s take a look at what parameter sniffing is all about. I will us...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxFri, 08 Feb 2008 03:43:39 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=157 When is it okay to let SQL Server to make a statistic for columns in your queries, and when shou...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxMon, 04 Feb 2008 18:08:58 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=149 A Question About Keys Kalen Delaney Originally published by SQL Server Prof...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxFri, 01 Feb 2008 17:49:56 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=139 If your database goes offline, you’re probably up a creek, right? If you’re using SQL Server 2005 ...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 24 Jan 2008 21:00:56 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=133 Writing Your Own System Procedures Kalen Delaney Originally published by SQL Server...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxSat, 19 Jan 2008 23:55:38 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=126Excerpt from the Caregroup Healthcare Case Study: CareGroup Healthcare System is responsible for pro...http://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspxThu, 17 Jan 2008 09:12:41 GMThttp://www.sqlcommunity.com/Articles/SQLServerArticlesCategorized/tabid/153/language/en-US/Default.aspx?id=118