MSSQL Useful Links

Good Articles

------------

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

http://www.dmreview.com/article_sub.cfm?articleId=5658

http://www.databasejournal.com/features/mssql/article.php/1466951

http://msdn.microsoft.com/en-us/library/aa174545(SQL.80).aspx -- physical architecture for sql 2000

http://www.mssqltips.com/tip.asp?tip=1015

http://support.microsoft.com/kb/325335

database engine tuning advisor - DTA with workload file

http://safari.oreilly.com/0201700476/ch22lev1sec6

http://support.microsoft.com/kb/935563

http://www.mssqltips.com/tip.asp?tip=1270

http://books.google.com/books?id=aup_ppJfgMcC&pg=PA357&lpg=PA357&dq=concurrent+snapshot&source=web&ots=3cvC-GSkuY&sig=KS6z0RnIfDWczxpTYZ0UziRNOAc&hl=en#PPA355,M1

http://msdn2.microsoft.com/en-us/library/aa179423(SQL.80).aspx

http://www.sqlservercentral.com/articles/Transactional+Replication/62446/

http://www.mssqltips.com/tip.asp?tip=1239 - index

http://blogs.msdn.com/psssql/

http://blogs.msdn.com/sqlprogrammability/archive/2007/01/22/3-0-changes-in-caching-behavior-between-sql-server-2000-sql-server-2005-rtm-and-sql-server-2005-sp2.aspx

sql server memory

http://sqljunkies.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

http://support.microsoft.com/kb/244455 -- waittypes

http://blogs.msdn.com/sqlqueryprocessing/ - sql 2005

http://support.microsoft.com/kb/271624 -- dbcc memorystatus

http://www.sqljunkies.ddj.com/Tutorial/0D4FF40A-695C-4327-A41B-F9F2FE2D58F6.scuk

dbmail

------

http://www.sqlserverclub.com/articles/article05.aspx

http://www.sql-server-performance.com/articles/dba/email_functionality_p2.aspx

blocking topics - very good to learn

http://support.microsoft.com/kb/224453

Table Partitioning in sql 2000/2005

RAID concepts/types

Load Balancing/server clustering - how many instances

views in detail

DDL triggers:

-------------

http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx

--------------------

http://dba-sql-server.com/sql_server_tips/t_super_sql_164_server_collation_lcid.htm

http://support.microsoft.com/kb/822747

Isolation Levels

XML

Triggers - DDL & DML

http://www.sql-server-performance.com/articles/dba/monitor_with_dts_p2.aspx - very good blat the execution status of jobs:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=38993

blocking topics - very good to learn

http://support.microsoft.com/kb/224453

Database Mirroring

http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

Clustering

----------

How to change service accounts for a clustered computer that is running SQL Server?

http://support.microsoft.com/kb/239885

Good one basics- http://www.databasejournal.com/features/mssql/article.php/1583581

Fulltext Catalog

----------------

Catalog not visible in EM and item count shows 0

------------------------------------------------

http://support.microsoft.com/kb/817301

MAX DOP

-------------

http://support.microsoft.com/kb/322385

http://www.simple-talk.com/sql/performance/sql-server-performance-crib-sheet/

http://blogs.technet.com/mat_stephen/archive/2005/02/08/369120.aspx

http://blogs.msdn.com/psssql/ - Good stuff

http://www.sqlservercentral.com/columnists/hroggero/managingmaxdegreeofparallelism.asp

Load Balancing/Failover clustering

-------------------------------------

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1134473,00.html

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1127807,00.html

http://support.microsoft.com/kb/260758

Database snapshot - SQL 2005

------------------------------

http://www.sqlservercentral.com/columnists/akhosla/2733.asp

http://www.sqlskills.com/whitepapers.asp - SQL 2005 complete

http://blogs.msdn.com/sqlcat/archive/2007/06/06/querying-a-database-snapshot.aspx

UMS Scheduler and concurrency diagnostics - sp_configure:

----------------------------------------------------------

New concurrency and scheduling diagnostics have been added to SQL Server

http://support.microsoft.com/kb/319892

SQL 2005 -- Logon triggers

--------------------------

http://decipherinfosys.wordpress.com/2007/05/02/logon-triggers-in-sql-server-2005-sp2/

http://www.sqlservercentral.com/columnists/FVandeputte/sqlserver2005logontriggers.asp

http://www.vandeputte.org/2006/11/sql-server-logon-triggers-part-2.html

SQL 2005 - New features

------------------------

http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/WhatsNewSQL2005SP2.htm

Full Text Catalog

------------------

http://support.microsoft.com/kb/240867

http://blogs.msdn.com/krichie/archive/2006/07/20/673339.aspx

http://www.codeproject.com/useritems/sqlfulltextindexing.asp

http://www.microsoft.com/technet/community/chats/trans/sql/sq0529pm.mspx

http://www.databasejournal.com/features/mssql/article.php/3441981

Buffer pool

-----------

http://www.sqlteam.com/article/what-data-is-in-sql-server-memory

Troubleshooting performance problems

----------------------------------

http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx

tempdb space usage:

-------------------

http://sqlblog.com/blogs/kevin_kline/archive/2007/10/23/tempdb-space-usage.aspx

workign with tempdb

--------------------

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

http://blogs.msdn.com/psssql/Default.aspx?p=2 -- Indepth SQL

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx - working with tempdb sql 2005

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=863910&SiteID=1 - Work tablepage issue

http://support.microsoft.com/kb/307487 -- Methods to shrink tempdb

http://sqlserver2000.databases.aspfaq.com/why-is-tempdb-full-and-how-can-i-prevent-this-from-happening.html

service broker

---------------

http://rusanu.com/2007/10/31/error-handling-in-service-broker-procedures/

http://blogs.msdn.com/remusrusanu/archive/2006/06/17/635608.aspx

http://blogs.msdn.com/remusrusanu/

security

---------

http://sqlserver-qa.net/blogs/perftune/default.aspx

windowsitpro.com/Common/adforceimages/ch12Petkovic.pdf

Partitions

----------

http://blogs.techrepublic.com.com/datacenter/?p=139

http://www.simple-talk.com/sql/sql-server-2005/partitioned-tables-in-sql-server-2005/

Clustered and Nonclustered:

--------------------------

http://dis4ea.blogspot.com/2006/02/non-unique-clustered-index-rebuild-in.html

http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html

Checksum

---------

http://blogs.msdn.com/psssql/archive/2008/05/22/how-it-works-sql-server-2005-possible-data-recovery-when-checksum-failure-reported.aspx

AWE & PAE

----------

http://blogs.msdn.com/chadboyd/archive/2007/03/24/pae-and-3gb-and-awe-oh-my.aspx

page splits

-------------

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/06/28/what-is-a-page-split-what-happens-why-does-it-happen-why-worry.aspx

pages & extents

-------------

https://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/28/649884.aspx

GAM,SGAM and PFS

------------------

http://blogs.msdn.com/sqlserverstorageengine/archive/2006/07/08/under-the-covers-gam-sgam-and-pfs-pages.aspx

good stuffs

-----------

http://blogs.msdn.com/sqlserverstorageengine/default.aspx?p=3

DBCC commands

---------------

http://www.sqlservercentral.com/articles/Administration/sqlserver2005dbcccommandquickreference/1628/

DBCC commands

--------------

http://www.sqlservercentral.com/articles/Administration/sqlserver2005dbcccommandquickreference/1628/

Rebuild Master Database in SQL Server 2008.

--------------------------------------------

http://blogs.msdn.com/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

Page updated

Google Sites

Report abuse