Sqlserver - Revision history

T1t0 at 16:42, 25 January 2020

2020-01-25T16:42:40Z

← Older revision		Revision as of 16:42, 25 January 2020
Line 1:		Line 1:
	== System query ==		= System query =

	==== Show all tables sizes ====		== Show all tables sizes ==

	<pre>		<pre>
Line 15:		Line 15:
	</pre>		</pre>

	== Links ==		= Links =

	* [http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record « Journey to SQL Authority with Pinal Dave]		* [http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record « Journey to SQL Authority with Pinal Dave]
Line 23:		Line 23:
	* [http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/ SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice « Journey to SQL Authority with Pinal Dave]		* [http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/ SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice « Journey to SQL Authority with Pinal Dave]
	* [http://msdn.microsoft.com/en-us/magazine/cc164047.aspx#S5 Data Points: Exploring SQL Server Triggers]		* [http://msdn.microsoft.com/en-us/magazine/cc164047.aspx#S5 Data Points: Exploring SQL Server Triggers]



	[[Category:database]]		[[Category:database]]
	[[Category:sqlserver]]		[[Category:sqlserver]]

T1t0 at 18:20, 19 January 2020

2020-01-19T18:20:41Z

← Older revision		Revision as of 18:20, 19 January 2020
Line 1:		Line 1:
			== System query ==

			==== Show all tables sizes ====

			<pre>
			SELECT s.Name AS SchemaName, t.NAME AS TableName, CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS NUMERIC(36, 2)) AS TotalSpaceMB
			FROM sys.tables t
			INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id
			INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
			INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id
			LEFT OUTER JOIN sys.schemas s ON t.schema_id = s.schema_id
			WHERE t.type_desc = 'USER_TABLE'
			GROUP BY t.Name, s.Name, p.rows
			ORDER BY TotalSpaceMB DESC, t.Name
			</pre>

			== Links ==

	* [http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record « Journey to SQL Authority with Pinal Dave]		* [http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record « Journey to SQL Authority with Pinal Dave]
	* [http://ss64.com/sql SQL Server 2005 commands]		* [http://ss64.com/sql SQL Server 2005 commands]

imported>T1t0 at 12:59, 7 February 2012

2012-02-07T12:59:16Z

← Older revision		Revision as of 12:59, 7 February 2012
Line 5:		Line 5:
	* [http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/ SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice « Journey to SQL Authority with Pinal Dave]		* [http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/ SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice « Journey to SQL Authority with Pinal Dave]
	* [http://msdn.microsoft.com/en-us/magazine/cc164047.aspx#S5 Data Points: Exploring SQL Server Triggers]		* [http://msdn.microsoft.com/en-us/magazine/cc164047.aspx#S5 Data Points: Exploring SQL Server Triggers]



			[[Category:database]]
			[[Category:sqlserver]]

imported>T1t0 at 04:02, 2 December 2011

2011-12-02T04:02:24Z

New page

* [http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record SQL SERVER – @@IDENTITY vs SCOPE_IDENTITY() vs IDENT_CURRENT – Retrieve Last Inserted Identity of Record « Journey to SQL Authority with Pinal Dave]
* [http://ss64.com/sql SQL Server 2005 commands]
* [http://technet.microsoft.com/en-us/library/ms187965.aspx GRANT (Transact-SQL)]
* [http://blogs.msdn.com/b/sqlcat/archive/2006/04/10/sql-server-sequence-number.aspx SQL Server Sequence Number - Microsoft SQL Server Development Customer Advisory Team - Site Home - MSDN Blogs]
* [http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/ SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice « Journey to SQL Authority with Pinal Dave]
* [http://msdn.microsoft.com/en-us/magazine/cc164047.aspx#S5 Data Points: Exploring SQL Server Triggers]