Changing physical locations of all DBs
I got a request this week from an application engineer. The request was to move ALL physical database files from...
2012-07-09 (first published: 2012-07-02)
4,475 reads
I got a request this week from an application engineer. The request was to move ALL physical database files from...
2012-07-09 (first published: 2012-07-02)
4,475 reads
Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:
1. Indirect Checkpoint
Prior to...
2012-07-01
2,163 reads
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-01
1,644 reads
When SQL Server 2005 launched, it included a slew of dynamic management objects (DMOs) that were meant to replace the...
2012-07-01
1,125 reads
I have written following Microsoft SQL Server T-SQL scirpt to quickly determine space used for each table in a SQL...
2012-07-01
4,455 reads
I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.
2012-07-01
978 reads
In this blog article I will give an overview of performance tuning based on common situation that occur on small...
2012-07-01
480 reads
Let’s say that you are in the market to buy a new laptop or ultra book to replace that old...
2012-06-30
2,341 reads
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging
I was having a discussion with Idera (@idera_software) dev lead Vicky...
2012-06-30
2,222 reads
In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management...
2012-06-30
5,366 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