PowerShell – Backup Specific group of SQL Databases
<#
.SYNOPSIS
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh...
2016-05-11
601 reads
<#
.SYNOPSIS
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh...
2016-05-11
601 reads
Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...
2016-05-11
1,557 reads
HI friends, most of the time we used DBCC FREEPROCCACHE to clear the procedure cache, clears the specific plan from...
2016-05-11
584 reads
[read this post on Mr. Fox SQL blog] Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a variety of application purposes. For those SQL DBA’s...
2016-05-10
29 reads
[read this post on Mr. Fox SQL blog]
Recently I have been using Azure DocumentDB (aka CosmosDB) to validate several business use cases for a...
2016-05-17 (first published: 2016-05-10)
3,142 reads
This month Wendy Pastrick is the host for T-SQL Tuesday #78. This month we have to “learn something new and blog...
2016-05-19 (first published: 2016-05-10)
3,516 reads
Tomorrow I’ll be presenting a new session for the PASSVirtualization Virtual Chapter called “Virtual SQL Servers, Actual Performance” tomorrow at...
2016-05-10
572 reads
Last week I did a little experimental webinar that was outside our (Pragmatic Works) norm. Instead of our traditional 1...
2016-05-19 (first published: 2016-05-10)
2,359 reads
SQL Server supports row and page compression on tables, indexes and partitions. This can lead to reduced I/O and better performance. However, it can also result in additional CPU...
2016-05-10
50 reads
One of the things I like best about joining in on Adam Machanic’s (b/t) TSQL Tuesday blog party is that...
2016-05-10
506 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