<br />Best Practice - Increase the Number of SQL Server Error Logs<br />http://www.mssqltips.com/tip.asp?tip=1835 Written By: Ashish Kumar Mehta -- 9/11/2009 -- 5 comments

Tips for Using SQL Server Performance Monitor Counters By : Brad McGeheeAug 24, 2005http://www.sql-server-performance.com/tips/sql_server_performance_monitor_coutners_p3.aspx One cause of excess I/Oon a SQL Server is page splitting. Pa

<br />http://forums.digitalpoint.com/showthread.php?t=1081939<br />What is pixel tracking?<br /> <br />   Pixel tracking, as in direct traffic measurement?<br /><br />    There are some sites out there that can help you keep track of your traffic. One ex

http://blog.sqlauthority.com/2010/05/03/sql-server-shrinkfile-and-truncate-log-file-in-sql-server-2008/UPDATE: Please follow link for SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008.Sometime, it looks impossible to shrinkthe Tru

http://www.codeproject.com/KB/database/DiagnoseProblemsSQLServer.aspxAs partof a series of articles on several data access optimization steps, thisarticle focuses on diagnosing performance problems in SQL Server.IntroductionImagine you are a doctor, or

Indexedviews can be created in any edition of SQL Server 2005. In SQL Server2005 Enterprise Edition, the query optimizer automatically considersthe indexed view. To use an indexed view in all other editions, theNOEXPAND table hint must be used.Refr

SQLAlso consider some online SQL formatting tools:SQLInform's online SQL formatter - requires Java in your browser.SQLRefactor from Red Gate - ~$300Instant SQL Formatter online at dpriver.com Apparently they have a SQL Management Studio plugin for $5

http://www.mssqlcity.com/Articles/Replic/SetupSR/SetupSR.htmSetup Snapshot replication: step by step guideAlexander Chigrikchigrik@mssqlcity.comIntroductionGeneral conceptsReplication topologiesReplication typesReplication agentsChecking necessary conditio

http://www.mssqltips.com/tip.asp?tip=1338ProblemSome tasks that are run in SQL Sever take along time to run and it is sometimes difficult to tell whether thesetasks are progressing or not.  One common way of determining thatstatus is to look at the

MARKETPLACE$2.95/mo Best Developer Web HostingUnlimited space, transfer, domains & emails. 99.9% Uptime & 24/7 Support!www.DailyRazor.comJava Website HostingShared & Private Tomcat Plans Avail Over 10yrs Of Java Web Hosting Exp!www.DailyRazor.comWeb based

--http://stackoverflow.com/questions/2554333/multi-statement-table-valued-function-vs-inline-table-valued-function -- http://sqlblogcasts.com/blogs/simons/archive/2008/11/03/TSQL-Scalar-functions-are-evil-.aspx  In researching Matt's comment, I have revise

<br />http://archive.databasepronews.com/databasepronews-51-20041207UsingPerformanceMonitortoIdentifySQLServerHardwareBottlenecks.html<br /> <br />The best place to start your SQL Serverperformance audit is to begin with the Performance Monitor (System

6 Different Ways To Get The Current Identity ValueFrom Wikihttp://wiki.lessthandot.com/index.php/6_Different_Ways_To_Get_The_Current_Identity_Value<br />Jump to: navigation, search<br />Thistip will show you how to get the current identity value from a

http://www.sql-server-performance.com/tips/rebuilding_indexes_p2.aspxPeriodically (daily, weekly, or monthly) perform a database reorganizationon all the indexes on all the tables in your database. This willrebuild the indexes so that the data is no lo

Posts Tagged Top 13 Mistakes<br />http://thesqlagentman.com/tag/top-13-mistakes/page/2/Top 13 SQL Server Mistakes and Missteps – #10 Default Database Autogrowth Settings<br />Jun1<br />Posted by sqlagentman in Best Practices, SQL, Syndicated | Co

SQL SERVER – Stored Procedure Optimization Tips – Best Practices<br />http://blog.sqlauthority.com/2010/02/16/sql-server-stored-procedure-optimization-tips-best-practices/<br />February 16, 2010 by pinaldave<br />Wewill go over how to optimize Stored Pro

Best Practice for renaming a SQL Server Databasehttp://www.mssqltips.com/tip.asp?tip=1891  Written By: Ashish Kumar Mehta -- 12/2/2009 -- 4 comments -- pr

Tips for Rebuilding Indexes<br />http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx By : Brad McGehee<br />Feb 21, 2007<br /> <br />Periodically (daily, weekly, or monthly) perform a database reorganizationon all the i

What is so bad about EAV, anyway? http://sqlblog.com/blogs/aaron_bertrand/archive/2009/11/19/what-is-so-bad-about-eav-anyway.aspxI see a lot of people trash-talking the EAV (entity-attribute-value) model.  If you want the full story on EAV, I recommend you

http://www.simple-talk.com/sql/performance/performance-tuning-tips-for-database-developers/Performance tuning is not easy and there aren’t any silver bullets, but you can go a surprisingly long way with a few basic guidelines. In theory, performance tuning

<br />DBA’s Quick Guide to Timeouts<br /> <br />http://vyaskn.tripod.com/watch_your_timeouts.htm<br />by Chris Kempster<br />The author of: SQL Server 2000 for the Oracle DBA<br />Click here for more information, sample chapters, or to purchase this e-

<br /><br /><br /><br /><br />http://blogs.msdn.com/b/tolong/archive/2006/11/21/max-pool-size-was-reached.aspx<br /> <br />Opening a database connection is a resource intensive and time consuming operation.Connection pooling increases the performance o

<br /><br />http://www.ifinity.com.au/Blog/EntryId/60/404-Error-in-IIS-7-when-using-a-Url-with-a-plus-sign-in-the-path<br />I recently hadreported problems when using IIS7 that Urls with a + in the url werefailing with 404 errors.  This was to do with

http://www.ifinity.com.au/Blog/EntryId/60/404-Error-in-IIS-7-when-using-a-Url-with-a-plus-sign-in-the-pathI recently hadreported problems when using IIS7 that Urls with a + in the url werefailing with 404 errors.  This was to do with the Url Master mod

<br /><br /> <br />http://dotnetperls.com/precompiled-aspnet<br /> <br />Target Location:<br />[Text input box]<br />This is where the published site will be put.<br />(The author suggests using a location on your disk C:/ for now.)<br /><br />"Allow this

<br /> <br />Before restore our database to the point in time, we need to make sure at least :<br /> our database recovery model is full we do have a latest database full backupwe do have a few transaction log backup<br />For #3, we can use Maintenance pla

<br /> Abstract - best practise of creating dll<br />A dynamic-link library (DLL) is shared code and data that an application can load and call at run time. Advantages of using DLLs include reduced code footprint, lower memory utilization due to single-cop