Browse Blog Posts by Tags

All Tags » sql server » best practice (RSS)

MVP WordPress Blogs

Browse Blog Posts by Tags

Showing related tags and posts for the Blogs application. See all tags in the site

Master SQL Chef series: Troubleshooting multi-server instances with #sql2k8r2cookbook

Managing multiple instances of SQL Servers and databases is a challenging task, having a third party tool is not a problem however it is always BEST to manage the show using SQL Server Management Studio (SSMS). SQL Server tools are easy to use and help...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 16 2012
Filed under: Filed under: sql server, management, ssms, dba, best practice, beginners, cookbook, ucp, #sql2k8r2cookbook, data tier, utility control point
Master SQL chef series: Designing a best practice approach - Upgrading SQL Server data platform #sql #sql2k8r2cookbook

There is no doubt that SQL Server users have been keeping up their knowledge up to the level since last few years (at least since 2008 version release). In this regard the Upgrade of SQL Server data platform has taken utmost priority that can offer advantage...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Jan 2 2012
Filed under: Filed under: sql server, database, best practice, platform, updates, deprecated features, upgrade advisor, cookbook, discontinued featuers, #sql2k8r2cookbook
SQL Server Optimization series: Recompiles, query plans, cache - manage them efficiently

Query plan - an efficient way to guide the query execution, but how best you can help the query optimizer to prepare and compile the plan quickly for the better results. Whenever you are involved in the query performance exercise then ensure that the...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jul 19 2011
Filed under: Filed under: sql server, compiled, stored procedure, best practice, performance monitoring, auto update, fixed plan
Microsoft SQL Server 2008 R2 Administration Cookbook - eBook and paperback Book - quick answers to common problems #sql #book

This is something big in my life to announce, it gives immensive pleasure and happiness to share about my first book (hard paper) and eBook release, titled : Microsoft SQL Server 2008 R2 Administration Cookbook is released and out now. share my experience...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, May 24 2011
Filed under: Filed under: sql server, performance, availability, mvp, dba, programming, best practice, monitoring, beginners, ebooks, architects, scalability, experience, book, packt, real-world
SQL Server service account permissions and gotchas #sql #bpa #sqlservice

The number of services related to SQL Server has been doubled since SQL Server 2005 is released and 2008 R2 version has got few more to watch. The various services that are required/related to SQL Server are as follow and each of them will run as a seperate...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, May 13 2011
Filed under: Filed under: sql server, security, dba, best practice, monitoring, service account, server restart, user right, windows nt
SQL Server Performance series: Parametrized Index optimization to handle each fragmentation group

As a DBA handling SQL Server platform performance issues is not an easy task in a multi-server and multi-database environment, in order to keep up the availability and scalability it is important to manage the database fragmentation on SQL Server in addition...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Jan 9 2011
Filed under: Filed under: sql server, performance, dba, optimization, best practice, update statistics, index rebuild, reorg
Cumulative Update package 4 for SQL Server 2008 R2 released

SQL Server 2008 R2 has got another instalment of Cumulative Update 4 package release, that contains the hotfixes that have been packaged since the release of R2 RTM release. The build number for this release will be 10.50.1746.0, by default these builds...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Oct 19 2010
Filed under: Filed under: sql server, ssms, download, encryption, best practice, testing, cumulative update, tde, mds, master data management, cu4, parallel data warehouse
SQL Server magazine Community Choice Award - vote for Ola Hallengren SQL Server maintenance solution

If you are a DBA then you will know the best results of Ola Hallengren's SQL Server maintenance solution. Ola has done excellent work helping the numerous DBAs with the excellence of maintaining the databases easily with a script. Refer to http:/...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Sep 6 2010
Filed under: Filed under: sql server, community, best practice, Database Maintenance, award, mainstream, ola
Cumulative Update #3 for SQL Server 2008 R2 RTM

If you are following the patching of your SQL Server instances with Cumulative Updates then here is another instalment available for testing & deployment. KBA2261464 refers the release of CU3 hotfixes for the SQL Server 2008 R2 issues that have been...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Aug 17 2010
Filed under: Filed under: sql server, download, best practice, testing, cumulative update, rtm, sql server 2008 r2, cu3
List of versions and bugs fixed on SQL Server 2008 Service Pack 2 (CTP)

I had to answer bunch of questions around version number and fixes that are released for SQL Server 2005 & 2008, during a SQL Server platform health check for a client yesterday.. First one was, what is easy way to determine which version (service...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jul 21 2010
Filed under: Filed under: sql server, download, ctp, service pack2, best practice, fix, versions
SQL Server 2008 R2 new features specific to OS related Dynamic Management Views - DMV

How many times have you taken help from SQL Server DMVs? How many of them are useful for your day-to-day data platform management? Well, they are closely attached to my day-to-day work. I'm excited to get my hands on upcoming client's project...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Jul 9 2010
Filed under: Filed under: sql server, memory, dmv, dba, cpu, best practice, sql server 2008 r2, database user, server scope, sys.dm_os_
Loading Spatial Data the SSIS Way - SQL Server Standard magazine :: SQLPASS

What am I thinking about the subject line - SSIS & Spatial data, how can both of the features fit in and how to accomplish? Here is the excellent magazine article by fellow MVP MIchael Coles on SQLPASS SQL Server Standard magazine, with a deep-dive...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jul 1 2010
Filed under: Filed under: sql server, ssis, standard, spatial, best practice, sqlpass, magazine
Leverage Query and Index performance with MAXDOP/Max Degree of Parallelism option in SQL Server

No matter how best you adopt the indexing practices, few times you have to tweak the resources to obtain optimized performance. This is where a degree of parallelism needs to be applied for your complex/large resulted queries on your SQL Server, having...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jun 24 2010
Filed under: Filed under: sql server, performance, dba, query, best practice, parallel execution, max worker threads, numa, benchmarking, performance monitoring, latches, maxdop, threads
SQL Server 2008 R2 Update for Developers Training Kit get June 2010 Update

Are you interested to obtain a training kit to update your SQL Server 2008 R2 knowledge? Then here is the elegant way to obtain such resources from Developer & Platform Evangelism team, there are array of capabilities for developers that build upon...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jun 22 2010
Filed under: Filed under: sql server, video, presentation, best practice, learning, beginners, training, version 2008, demos, developer training kit, hands-on
SQL Server 2008 R2 Deprecated Features : will be removed from future version of SQL Server

It is always a best practice to read about or know more on DEPRECATED features whenever a new version of SQL Server is released, as I did for recent 2008 R2 version here are few important ones that I would like to present. Since the release of SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Tue, Jun 1 2010
Filed under: Filed under: sql server, best practice, samples, unable
SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: You receive a "Provider Load Failure" error message or the WMIPRVSE.EXE process stops responding...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Mon, Apr 19 2010
Filed under: Filed under: sql server, performance, ssas, ssrs, kba, x64, best practice, database mail, dbcc checkdb, enterprise edition, standard edition, ssiss
Cumulative Update Package 10 for SQL Server 2008 - have a look at list of bug fixes

In the recent times Microsoft Release Services adopted the 935897 Incremental Servicing Model (ISM) for SQL Server team to deliver hotfixes for reported problems, also the new 822499 naming schema for Microsoft SQL Server software update packages. In...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Mar 17 2010
Filed under: Filed under: sql server, package, kba, database mirroring, build, service pack, best practice, cumulative update
SQL Server Memory Cache - take help of DMV for optimal query plans

SQL Server query optimization and keepup of performance is not a black-art, it can be achieved in a fair manner if you treat your queries with plans with a are reused or recompiled plans that can help you design well-performing applications. There are...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Feb 24 2010
Filed under: Filed under: sql server, memory, technet, security, query, cache, BOL, best practice, configuration, plan guide, benchmarking
SQL Server Management Studio - Obtain Misisng Indexes information and its limitations!

It is a common criteria that using Dynamic Management Views (DMVs) you can easily obtain the system & database state on a SQL instance. It may not be easy for a starter DBA to ensure what kind of DMV is used to obtain information on Recent Expensive...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Jan 14 2010
Filed under: Filed under: sql server, performance, ssms, query, best practice, management studio, database tuning advisor, execute plan
How fast you can obtain information about missing indexes? Its easy and quick!

On the subject line the process to find the answer is not a short one! By design SQL Server engine takes care when the query optimizer generates a query plan, it analyzes what are the best indexes for a particular filter condition. If the best indexes...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Sun, Nov 22 2009
Filed under: Filed under: sql server, performance, indexes, dmv, best practice, execution plan, monitoring, dbas, index hint, view server state

Page 1 of 5 (87 items) 1 2 3 4 5 Next >

Questions? Contact Susan at Susan-at-msmvps.com. Each post's copyright held by the original author. All rights reserved. Blog site is an independent site not sponsored by Microsoft.
Our servers would like to thank www.ownwebnow.com and www.exchangedefender.com. We wouldn't be here without the generosity of Vlad Mazek and his companies.

Powered by Community Server (Commercial Edition), by Telligent Systems

Theme based on the Paperclip Blog Theme included in Community Server.
Enhanced to a Site-Wide Theme by Interscape Technologies.