SQL Server - Revision history

Rkdrm at 04:30, 2 May 2017

2017-05-02T04:30:18Z

2017-05-02T03:46:47Z

2017-05-02T03:44:53Z

2017-05-02T03:43:44Z

‎Identify 'missing' indexes

2017-05-02T03:42:13Z

2017-05-02T03:41:03Z

2011-08-08T02:07:20Z

2011-08-08T02:06:09Z

2010-06-18T06:55:57Z

2010-05-11T06:59:29Z

@@ Line 14: / Line 14: @@
   where i.object_id = t.object_id
    and i.type_desc = 'NONCLUSTERED'
 </nowiki>

@@ Line 7: / Line 7: @@
   GROUP BY DB_NAME(sP.dbid)
   ORDER BY 1;
 === Identify 'missing' indexes ===

@@ Line 9: / Line 9: @@
 === Identify 'missing' indexes ===
-<nowiki>
+ <nowiki>
   SELECT
      CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *

@@ Line 9: / Line 9: @@
 === Identify 'missing' indexes ===
   SELECT
      CONVERT(decimal(28, 1), migs.avg_total_user_cost * migs.avg_user_impact *
@@ Line 37: / Line 38: @@
      migs.avg_total_user_cost * migs.avg_user_impact * (migs.user_seeks +
                                                         migs.user_scans) DESC
 === List permissions each table in a database ===

@@ Line 7: / Line 7: @@
   GROUP BY DB_NAME(sP.dbid)
   ORDER BY 1;
 === List permissions each table in a database ===

← Older revision		Revision as of 03:41, 2 May 2017
Line 1:		Line 1:
	* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]		* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]
		+
		+	=== Count database connections in database ===
		+	SELECT DB_NAME(sP.dbid) AS the_database
		+	, COUNT(sP.spid) AS total_database_connections
		+	FROM sys.sysprocesses sP
		+	GROUP BY DB_NAME(sP.dbid)
		+	ORDER BY 1;

	=== List permissions each table in a database ===		=== List permissions each table in a database ===

@@ Line 3: / Line 3: @@
 === List permissions each table in a database ===
 Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects
 === Run a command on each table in a database ===

← Older revision		Revision as of 02:06, 8 August 2011
Line 1:		Line 1:
	* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]		* [http://msdn.microsoft.com/en-us/library/aa302392.aspx Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication]

		+	=== List permissions each table in a database ===
		+	Use the sp_helprotect system stored proc. Run with no arguments it list permissions on all database objects

	=== Run a command on each table in a database ===		=== Run a command on each table in a database ===

← Older revision		Revision as of 06:55, 18 June 2010
Line 35:		Line 35:

	Open SS Management Studio, expand server roles and check you are in the sysadmin role.		Open SS Management Studio, expand server roles and check you are in the sysadmin role.
		+
		+	==== Create AdventureWorks Sample Cube for 2008/R2 Analysis Services ====
		+	* [http://msftdbprodsamples.codeplex.com/wikipage?title=Installing%20Analysis%20Services%20Database Installing Analysis Services Database (CodePlex)]

@@ Line 2: / Line 2: @@
-== Run a command on each table in a database ==
+=== Run a command on each table in a database ===
 Use the sp_msforeachtable undocumented system stored proc, for example:
@@ Line 19: / Line 19: @@
    @whereAnd = 'and uid = 1'
 </nowiki>