important links sql Server

Evaluation edition to paid edition upgrade and trace flag sp_procoption for DBCC

==============================================================

http://www.mssqlgirl.com/category/dba

Analysis services administration notes
=========================================

http://blogs.msdn.com/b/karang/archive/2010/08/11/how-to-deal-with-corruption-in-analysis-services.aspx

http://blogs.msdn.com/b/karang/archive/2009/11/01/tampering-master-vmp-file-may-result-in-losing-all-analysis-services-databases.aspx

http://sqlserverpedia.com/wiki/MSAS_-_Using_Profiler_for_Performance_Monitoring

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/07024324-8328-4a92-83fc-32dbabd44aa7

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/3ff5cd79-5563-43f7-b815-a4a905829753

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2010/02/08/microsoft-sql-server-2008-analysis-services-consolidation-best-practices.aspx

Stats
======

http://blogs.msdn.com/b/saponsqlserver/archive/2007/05/22/sap-application-leveraging-sql-server-automatic-update-statistics.aspx

Parallelism
===========

http://sqlblog.com/blogs/adam_machanic/archive/2010/05/28/sql-university-parallelism-week-part-3-settings-and-options.aspx

SSRS
======

http://blogs.msdn.com/b/jgalla/archive/2008/06/30/all-those-temporary-files-rstempfiles.aspx

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/06/26/report-server-catalog-best-practices.aspx

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx

http://www.mssqltips.com/sqlservertip/2778/how-to-add-reporting-services-to-an-existing-sql-server-clustered-instance/

SSIS over cluster

================

http://msdn.microsoft.com/en-in/library/ms345193%28v=sql.105%29.aspx

 

Concurrency Series: Why do I get blocking when I use Read Uncommitted isolation level or use NOLOCK hint?
==================================================================================================

http://sqlcat.com/sqlcat/b/msdnmirror/archive/2011/02/20/concurrency-series-why-do-i-get-blocking-when-i-use-read-uncommitted-isolation-level-or-use-nolock-hint.aspx

Restore over network
=====================

http://ms-abhay.blogspot.in/2008/02/restoring-database-on-network-using-unc.html

–It is possible to delete the data/log files in SQL Express Edition even if the Instance is UP

http://ms-abhay.blogspot.in/2008/02/it-is-possible-to-delete-datalog-files.html

http://ms-abhay.blogspot.in/2010/11/error-1706-installation-package-for.html

Storage Best practices
=====================

http://sqlcat.com/sqlcat/b/top10lists/archive/2007/11/21/storage-top-10-best-practices.aspx

OBJECT_NAME enhancement and OBJECT_SCHEMA_NAME addition in SQL Server 2005 SP2
============================================================================

http://blogs.msdn.com/b/sqlperf/archive/2007/03/23/object-name-enhancement-and-object-schema-name-addition-in-sql-server-2005-sp2.aspx

Storage Modes in Analysis Services
===================================

http://blogs.msdn.com/b/sqlperf/archive/2007/02/12/storage-modes-in-analysis-services.aspx

Lock Escalation in SQL2005
============================

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/05/17/lock-escalation.aspx

Bulk Import Optimizations (Minimal Logging)
===========================================

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/02/05/bulk-logging-optimizations-minimal-logging.aspx

sunil agarwal
==============

http://social.msdn.microsoft.com/Profile/sunil%20agarwal/activity

http://blogs.msdn.com/b/chrissk/archive/2010/01/28/troubleshooting-transactional-replication-part-1.aspx

Memory pressure, Lock pages in memory
===================================================

http://www.sqlpassion.at/blog/CategoryView,category,SQLServer.aspx

http://blogs.msdn.com/b/karang/archive/2012/07/30/title_2d00_all_2d00_possible_2d00_scenarios_2d00_of_2d00_changing_2d00_ssas_2d00_data_2d00_directories.aspx

http://tenbulls.co.uk/2012/04/17/whos-active-on-sql-2000/

https://cmg.vlabcenter.com/prerequisites.aspx?moduleid=80373e91-6a9e-48d0-a8d6-4990c535cdc4

================
SAP on sql server
================

http://blogs.msdn.com/b/saponsqlserver/archive/2012/08/20/how-update-statistics-really-works-in-sap-bw.aspx

http://www.sqlpassion.at/blog/CategoryView,category,SQLServer.aspx

http://msdn.microsoft.com/en-us/library/ms173730%28v=sql.90%29.aspx

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/21/downgrading-a-database-you-can-t-get-there-from-here.aspx

http://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx

Quick Fix Engineering, CTPs, RTM,HotFixes,Service Packs,CUs Sql Server
=======================================================

http://weblogs.sqlteam.com/joew/archive/2008/05/07/60591.aspx

Behavior of SQL Server default instance on a NON-Default port
==========================================================

http://blogs.msdn.com/b/karthick_pk/archive/2009/01/15/sql-server-default-instance-behavior-on-a-non-default-port.aspx

What types of objects are useful in SQL CLR?
==============================================

http://sqlblog.com/blogs/greg_low/archive/2011/02/25/what-types-of-objects-are-useful-in-sql-clr.aspx

http://blogs.msdn.com/b/sanchan/archive/tags/32_2d00_bit+vs+64_2d00_bit+world/

http://www.englishtosql.com/english-to-sql-blog/2010/9/13/t-sql-tuesday-10-applying-indexes-to-replicated-tables.html

trans Replication sync with backup
========================================

http://www.sqlservercentral.com/blogs/aschenbrenner/2012/08/05/initialize-a-transactional-replication-from-a-database-backup/

sys.dm_db_index_physical stats
===============================

http://www.sqlskills.com/blogs/paul/post/Inside-sysdm_db_index_physical_stats.aspx

DBCC reindex and alter index
==============================

http://www.sqlservercentral.com/blogs/james-sql-footprint/2012/06/23/rebuild-index-with-alter-index-rebuild-or-dbcc-dbreindex/

Using Bulk Logged recovery model for Bulk Operations will reduce the size of Transaction log backups – Myths and Truths
=======================================================================================================================

Checking for CPU pressure via sys.dm_os_schedulers
====================================================

http://blogs.msdn.com/b/joesack/archive/2009/04/08/checking-for-cpu-pressure-via-sys-dm-os-schedulers.aspx

http://blogs.msdn.com/b/sqlserverfaq/archive/2011/01/07/using-bulk-logged-recovery-model-for-bulk-operations-will-reduce-the-size-of-transaction-log-backups-myths-and-truths.aspx?PageIndex=2#comments

About these ads