Browse Blog Posts by Tags

MVP WordPress Blogs

Browse Blog Posts by Tags

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

SQL Server DBA Manageability practices: Central Management Servers - how best you want to utilize them?

SQL Server 2008 version added a new face within SQL Server Management Studio that can help users to administer/manage/execute queries against multiple servers by designating Central Management Servers (CMS) and creating server groups. This means as an...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, May 4 2011
Filed under: Filed under: sql server, security, dba, best practices, beginners, system catalog, central management server, ucp
SQL Server Transaction log size problems - SHRINK :: understanding recovery models

Transaction log issues - one of the common problems that every DBA needs to tackle, if there is no DBA then its a FAQ in forums complaining database transaction log is not reducing when we take backups. Well, if you are a DBA then you don't need any...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Thu, Dec 2 2010
Filed under: Filed under: sql server, transaction log, dba, simple, shrink, best practices, full, bulk-logged, recovery model, beginners, truncated, system catalog
SQL Server TSQL to find detailed CONSTRAINTS information

TO enforce the integrity of the data in the columns, CONSTRAINTS are very useful. In this regard SQL Server provides various mechanims in enforcing such integrity: PRIMARY KEY Constraints FOREIGN KEY Constraints UNIQUE Constraints CHECK Constraints DEFAULT...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Fri, Oct 1 2010
Filed under: Filed under: sql server, tsql, primary key, information schema, constraint, referential integrity, system catalog, index usage, foreign key
SQL Server get current executing statements - SP_WHO or SP_WHO2 or sys.dm_exec_requests

As a SQL Server user or DBAs using SP_WHO or undocumented stored procedure SP_WHO2 is a common occurrence. For this there are times when you will need to run sp_who on your SQL Server to figure out who is on and what are they doing. The output is quite...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) by on Wed, Jul 30 2008
Filed under: Filed under: sql server, dmv, users, sp_who, statement, system catalog

Page 1 of 1 (4 items)

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.

MVP WordPress Blogs

Tags

Browse Blog Posts by Tags

SQL Server DBA Manageability practices: Central Management Servers - how best you want to utilize them?

SQL Server Transaction log size problems - SHRINK :: understanding recovery models

SQL Server TSQL to find detailed CONSTRAINTS information

SQL Server get current executing statements - SP_WHO or SP_WHO2 or sys.dm_exec_requests