Show Table, Index and Image/Text size.
This is a simple script that show size from a table and yours related objects.
2012-12-24 (first published: 2007-09-27)
2,749 reads
This is a simple script that show size from a table and yours related objects.
2012-12-24 (first published: 2007-09-27)
2,749 reads
This script will query across all databases, returning a result of objects recently created or modified.
2012-12-21 (first published: 2012-11-27)
2,107 reads
2012-12-20 (first published: 2012-12-04)
1,744 reads
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,214 reads
2012-12-14 (first published: 2012-11-27)
1,943 reads
Get information about how often, how fast your reports run and how big they are.
2012-12-12 (first published: 2012-11-27)
1,666 reads
This script will return all the Adhoc Single use Plans currently in your Plan Cache.
It also excludes Plan Shells created from auto/forced parameterization. Works for 2005/2008
2012-12-11 (first published: 2012-11-26)
853 reads
2012-12-07 (first published: 2012-11-19)
1,407 reads
Script to loop thru multiple linked server and get agent scheduled jobs for the next XX hours.
2012-12-06 (first published: 2012-11-16)
938 reads
2012-12-03 (first published: 2012-11-07)
2,070 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers