Script move of DB files from one location to another
Generates Scripts to move DB files from one location to another SQL and powershell scripts
2016-04-11 (first published: 2014-03-19)
4,340 reads
Generates Scripts to move DB files from one location to another SQL and powershell scripts
2016-04-11 (first published: 2014-03-19)
4,340 reads
This can be used for data warehouses as well as truncating table with foreign key constraints.
2016-04-08 (first published: 2014-07-07)
2,660 reads
Sometimes you want to copy all the alerts that you've got set up on one server to add them to another
2016-04-06 (first published: 2014-05-13)
6,251 reads
New set-based T-SQL solution for Sudoku puzzle using binary data and bitwise operations.
2016-04-05 (first published: 2015-06-08)
1,974 reads
2016-04-01 (first published: 2016-03-23)
893 reads
SCRIPT TO DELETE OLDER THAN N' DAYS BACKUP FROM A DEFAULT BACKUP DIRECTORY. IF DAYS = 0, PROVIDED,
IT WILL DELETE ALL BACKUP FILES FROM THE BACKUP LOCATION.
2016-03-31 (first published: 2015-03-16)
5,683 reads
This script shows the total time between two dates.
2016-03-29 (first published: 2014-07-09)
3,125 reads
This script scans all DB-s in the instance & send result to the email. I use sp_MSforechdb function & missing index finding script what i found here https://technet.microsoft.com/en-us/magazine/jj128029.aspx
2016-03-28 (first published: 2016-03-23)
1,079 reads
2016-03-25 (first published: 2015-01-30)
2,751 reads
From a plain text containing multiple instance names you can deploy EXCEL files to report just changing your query text
2016-03-24 (first published: 2016-03-08)
1,244 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