number of rows and columns of an instance
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
533 reads
Get the number of rows, columns, and space used by all tables in all databases
2018-10-03 (first published: 2018-09-20)
533 reads
Script to stop the default Data Collection sets, clear the cache files and then restart collection sets.
2018-10-02 (first published: 2018-09-25)
1,482 reads
Order records based on a different column depending on which absolute value is greater.
2018-10-01 (first published: 2018-09-26)
678 reads
2018-09-26
517 reads
A copy of the late Robert Davis' dba_copylogins stored procedure with a bug fix. The SP copies logins, roles, and permissions between servers.
2018-09-24 (first published: 2018-08-28)
1,812 reads
2018-09-21 (first published: 2018-06-01)
2,168 reads
2018-09-20 (first published: 2018-08-28)
927 reads
Didn't find anything, so hope this will help someone with similar need.
Note I did a similar set-based version, and unless the input is more towards non-zeros in all eight 2-byte fields, the set-based performs not as well
2018-09-19 (first published: 2018-09-12)
619 reads
2018-09-04 (first published: 2018-08-23)
341 reads
This scripts helps to generate ADD / DROP Constraints against single Database.
2018-09-03 (first published: 2018-08-14)
273 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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