Volume 1: Monday, Aug 4th 2008 (For worldwide release)                                    Register with SQL Server Community Worldwide Microsoft SQL Server Community Worldwide SQLCOMMUNITY.COM The worldwide hub for SQL Server Professionals. (in 104 countries and growing)         Home    SQL Discussion Forums     SQL Articles     SQL Scripts     SQL Tips     SQL Blogs     OpsDB     SQL Clinic     Dear friend, please feel free to forward this newsletter to your friends, colleagues, and other SQL Server professionals.   Become a SQL Community Manager/Leader   Are you passionate about SQL Server? Would you like to change the SQL Server world? SQL Community is looking for volunteers from India and USA to lead the regional SQL Community chapters.   Click here to volunteer   Knowledge Sharing   Be recognized in the SQL Server world by sharing your knowledge with other SQL Server Professionals from 102+ countries   Share SQL Server Articles Share SQL Server Scripts Share SQL Server Tips     SQL-FEST (Atlanta, USA) SQL Server Community is gearing up to launch the first SQL-FEST Technical Summit in Atlanta, GA on Sep 19th 2008 (Full day event). This technical event is open to all SQL Server professionals who are part of www.sqlcommunity.com   This event focuses on SQL Server 2008 (This is a free technical event) *Limited Registrations     Unique Opportunity for SQL Server Professionals Would you like to be recognized across the globe by sharing your SQL Server knowledge in an upcoming SQL Server 2008 book?   Here’s a unique opportunity for the members of SQL Community:   SQL Community is looking for contributors (Database Administrators/Engineers, Program Managers, Developers, etc) who can share their real-life / challenging experiences with SQL Server with the world.   Your article (if selected) would be published along with your name in a new SQL Server 2008 book from Microsoft Press. If interested, please email books@sqlcommunity.com     Boise SQL Server User Group Launched The newly formed Boise SQL Server User Group kicked off its first meeting with Kalen Delaney on June 25, 2008!   Kalen, of Inside SQL Server fame, met with the local SQL Server enthusiasts and shared some of her vast SQL Server knowledge with the local user group! For more details visit: http://boise.sqlcommunity.org       Quick Community Links SQL Tips & Tricks SQL Blogs SQL Discussion Forums SQL Automation Central SQL Community Articles SQL Laboratory SQL Wikipedia SQL Server RADIO SQL World Wide Events SQL Job Listings SQL Clinics WWW.SQLCOMMUNITY.COM   For advertisements: ads@sqlcommunity.com   Questions/Concerns:  Jenny@sqlcommunity.com Top SQL Server Community Articles   Should you install SQL Server on a 32-bit or 64-bit box? Author: Cindy Gross There’s not much reason to run 32bit at all anymore. All new hardware is 64bit, though you can install a 32bit OS on it. The differences in configuration and management, other than max memory allowed and how virtual address space is capped/divided, are not major but can be annoying if you don’t account for them. [READ MORE]   Multiple INSERTS using ROW constructors in SQL Server 2008 Author: Sirisha Kommushetty The concept ‘Row Constructors in SQL Server 2008’ basically deals with the crux of multiple inserts performed at one shot. To get a brief picture of why we need multiple inserts and the advantage it has we firstly need to understand all possible ways of INSERTING Data into a Table [READ MORE]   How to Layout Disk LUNS for SQL Server? Author:Louis Nguyen This article assumes we're not developing a new database or performance tuning an existing database. Instead we're trying to design storage for existing databases, for applications we have minimal knowledge of. The databases are vanilla databases with one MDF and one LDF file. This article addresses the standard case where a Microsoft SQL Server instance hosts multiple vanilla databases. [READ MORE]   Should SQL Server and Analysis Services be on the same box? Author: Cindy Gross Do you put SQL Server and Analysis Services on the same machine or different machines? How do you configure memory on an AS box to avoid conflicts with other applications? [READ MORE]   Automating SQL Server Profiler Author: Rohit Nayak This article details the steps to automate the generation of Sql profiler traces in a Testing environment. The facility is useful when an application is User Acceptance Testing phase where a bunch of test users logon to the Testing site and use the application. The resulting profiler traces can be used for many different things, starting from narrowing down expensive queries to being used as an input for Database Tuning Advisor (DTA) [READ MORE]   Top SQL Server Community Tips, Tricks, & Techniques Have you future proofed your DBA career? A pension's a good start, but do you save enough time for your own professional development? It's not always easy, but Red Gate's DBA tools can help you conserve enough office hours for DBA training aplenty. Be an Exceptional DBA and download your free trials now.   Using REPLICATE method in SQL Server Author:John Magnabosco The creation of a fixed length file from the results of a SELECT statement presents challenges that are not considered in a standard query. One of these challenges is that the values returned from the query must often be either pre-pended or post-pended with repeating characters to pad the fixed length field. [READ MORE]   Determine SET options for a Session Author: Kalen Delaney A SQL Server Tips site posted a tip recently on how to retrieve the SET options for your current connection. It used the system function @@options and bitwise operators to decode the value. Although this solution is very geeky and may impress your boss and co-workers, there are actually much better ways to do the same thing. [READ MORE]   Configuring Virtual Memory for SQL Server Machines Author: SQL Server Community Did you know that Windows Server will allow you to operate without having a paging file but this is not recommended. The more RAM your server has, the faster your programs will generally run and lesser the RAM you have on your computer more virtual memory would be used, virtual memory helps with more physical memory requirement by moving the data from RAM to a disk file called "Page File" [READ MORE]   Maintaining Availability on Large Tables during Index creation Author: Saleem Hakani There are times when you may want to create indexes on large tables which could take a lot of time and yet you want to make the data available during the creation of Index.   Join the worldwide SQL Server Community by Clicking Here Together, we will change the SQL Server World…. Free ebook on the 'Art of High Performance SQL Code' by Grant Fritchey. Try out the SQL Toolbelt and get your complimentary copy. 200 pages of execution plan magic plus 14 days of SQL Toolbelt heaven. Download here.   How are we doing? Questions/Concerns: leaders@sqlcommunity.com Support/affiliate questions: support@sqlcommunity.com Auto-Create & Analyze Traces Author: Gilles Comeau This script creates a trace, loads it into SQL Server and then prints out the worst running stored procedures for analysis. To Index or to Defrag Author: Saleem Hakani This scriptallows you to quickly get the facts on how much percentage of fragmentation you have in tables/indexes for a single database or for all the databases. This tool even takes away the pain of reading the cryptic values returned by DMV's to identify the amount of fragmentation you have on your SQL Server system. Not just that but it even tells you what action you can take to fix the problem. Audit Tables and Track Changes Author: Marco Mascioli This script will take any table from any database and create an audit table alongside with the name Audit_@tableName.  A trigger is created on the original table so that any inserts, updates, and deletes get copied to the audit table automatically.  SQL_RoboPERF Author: Saleem Hakani Obtain quick information on: Top 50 SQL Server statements that are CPU intensive, Detect real time locking information, View current SQL Statements from TempDB, View SQL Server Job details, View which indexes are being used. Logins Permissions Report Author: Louis Nguyen Generates a detailed SQL login permissions report.  Compatible with SQL2000 and up. SQL_DataGROWTH Author: Saleem Hakani This script allows you to record daily data growth for all the objects from all the databases. This helps in analyzing daily data growth for your database system. Run T-SQL on Multiple Servers Author: Vipul Shah There are many cases when DBA wants to query all of his SQL Servers in farm or deploy a server script on all the servers in the farm.   this script will help achieving that.   Here you can pass a comma separated list of servers or point it to your server inventory table to fetch the server name and loop through each server to run the script.  You can also specify the dbname on which you want to run this script on each server.   Quickly Get Database Report Author: Saleem Hakani This script helps you quickly obtain the following information: Name of the database, Logical filenames of files/filegroups, size of each data/log files, drive on which each data/log files are residing, type of file/filegroup, location of each physical files. SQL Server Space Utilization Author: Saleem Hakani This script helps in obtaining drive space related information from your server. It provides you with: Drive Letter, Total Size in MB, Used Space in MB, Free Space in MB, Total Percent of Free disk space, Total percent of disk being used, Total space occupied by SQL Server on that drive, Current date and time when this information was generated (Good for maintaining history) Auto-Failover SQL Jobs in DBM Author: Saleem Hakani Automatically failover SQL Server agent jobs from Principal to Mirror and Mirror to Principal in a database mirroring environment.