2018-02-23 (first published: 2018-02-19)
221 reads
2018-02-23 (first published: 2018-02-19)
221 reads
2018-02-19 (first published: 2018-02-07)
1,043 reads
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
2,116 reads
2018-02-12 (first published: 2018-01-24)
354 reads
What to do when you have several sql scripts to run in your DB? Put all in a folder and use this...
2018-02-09 (first published: 2018-01-24)
2,287 reads
Below script will remove database encryption key, database certificate and master key on all the user databases.
For tempdb database, you need to restart the SQL Server Instance to complete the process.
Note: It is advisable to take transaction log backup before this activity is performed.
2018-02-08 (first published: 2018-01-29)
2,248 reads
This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :-
exec proc_check_linked_servers 'profiler name','E-mail ID'
2018-02-07 (first published: 2018-01-30)
797 reads
2018-01-26 (first published: 2018-01-18)
12,698 reads
During a database migration or a side by side database upgrade project we need to migrate the MS SQL Server Agent jobs. This script compare jobs by names and shows unmatched jobs.
2018-01-25 (first published: 2018-01-20)
3,553 reads
How to insert data into a SQL Server Table using Powershell using Invoke-SQLcmd Commandlet
2018-01-24 (first published: 2018-01-11)
31,387 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...
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