culture independent format
network bind order
sql 2008 r2
SQL Server Configuration Manager
SQL Server SQLServer 2008R2
User-Defined Server Roles
Browse by Tags
Tagged Content List
Check your SQL – default Trace
Every installation of SQL has a default trace. The default trace was introduced in SQL 2005, It is the same trace that we know from the profiler or server but it is a preconfigured trace that is enabled as default. The default trace create five *.TRC file that are been recycle when they arrive to 20...
21 Jan 2013
Four Tips for SQL Tuning for SharePoint Part 3 TEMPDB
One of the focal points in SQL Server Tuning for SharePoint is around the TEMPDB. A lot of performance issues are caused by the performance of the TEMPDB. TEMPDB is one of the four system databases. Master is the database that contains all the information about the configuration of the...
14 Jul 2012
Four Tips for SQL tuning for SharePoint Part 2 - Shrink DB
SharePoint DB’s - To shrink or not to shrink the data file, this is the question: SQL Server provides you the ability to shrink the DB or shrink the files [MDF, NDF & LDF]. Shrinking the log file/LDF is quite different from shrinking the data file/MDF, NDF. Usually we do not have to...
3 Mar 2012
SQL & SIDs why we need it and what the hell is it?
Service SID and Or ice age Sid Lately I was asked about service SID during the installation of SQL 2008 Cluster. So I thought about it and wrote this blog post: During the times of SQL 2005, while installing SQL in a cluster configuration we needed to assign elevated permission to a domain group...
16 Feb 2012
Four Tips for SQL tuning for SharePoint Part 1 - MAX DOP
Lately I have been thinking about some of my latest work; mainly I have focused on an one day work shop with one of my colleagues, Amir, who is a SharePoint PFE. Now I’d like to share with you some of the SQL Best Practices for SharePoint. In this post, we will talk about MAXDOP and why MAXDOP...
1 Feb 2012
Page 1 of 1 (5 items)
© 2013 Microsoft Corporation.
Privacy & Cookies