Security Questions: Migrate Logins Between Servers
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-13
589 reads
As I mentioned in the introductory post, during the Introduction to SQL Server Security session for Pragmatic Work’sTraining on the T’s, I...
2013-06-13
589 reads
The Big 5 IT consulting companies (Accenture, Deloitte Consulting, PwC (formerly PricewaterhouseCoopers LLP), KPMG, Ernst & Young) have various titles given to consultants along...
2013-06-13
1,089 reads
I recently had the opportunity to review a pre-published copy of the “Instant” series book “Creating Data Models with PowerPivot...
2013-06-13
602 reads
I'm surprised there isn't an option in the Report Manager for allowing you to include on the print out of...
2013-06-17 (first published: 2013-06-13)
6,225 reads
A good many companies still have servers chugging along on SQL Server 2000 (or even, as some of us noted...
2013-06-13
913 reads
I was working with an auditor today who is working through a system with an external audit agency. The external...
2013-06-13
2,140 reads
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may...
2013-06-13
1,492 reads
With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in...
2013-06-12
1,443 reads
SQL Server Agent Jobs are crucial to any SQL Server environment as they are created and scheduled to perform critical business...
2013-06-12
894 reads
Checkout the part-2 of my two part article series on SQL Server Transactions and Lockinghere, in which you will learn...
2013-06-12
604 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