Calculate Length - Most Advanced UOC
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
888 reads
This function is used to calculate the actual unit of conversion for length.
2015-02-06 (first published: 2014-12-15)
888 reads
2015-02-05 (first published: 2013-03-22)
4,517 reads
Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.
2015-02-03 (first published: 2015-01-25)
3,018 reads
This function is used to calculate the actual unit of conversion for volume.
2015-01-30 (first published: 2014-12-16)
855 reads
Run this stored procudure to update statistics for those SQL Server databases where you have permission
2015-01-27 (first published: 2015-01-08)
1,280 reads
This script is useful to remove SQL backup files except latest one for same day from Backup Path.
2015-01-26 (first published: 2014-12-12)
1,129 reads
This function is used to calculate the actual unit of conversion for power.
2015-01-23 (first published: 2014-12-16)
887 reads
This script is useful to copying latest backup files from job Backup path during Instance/Database Migration
2015-01-21 (first published: 2014-12-15)
1,009 reads
This function is used to calculate the actual unit of conversion for time.
2015-01-19 (first published: 2014-12-15)
1,051 reads
This function is used to get the particular string occurences count from the given input string.
2015-01-16 (first published: 2014-12-16)
1,145 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