SQL Server: Understanding the Data Page Structure
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-15 (first published: 2012-08-12)
8,815 reads
We all know very well that SQL server stores data in 8 KB pages and it is the basic unit...
2012-08-15 (first published: 2012-08-12)
8,815 reads
I get a lot of e-mail and Twitter requests for advice about what laptop someone should buy. I don’t mind...
2012-08-14 (first published: 2012-08-11)
2,278 reads
Next Wednesday (Aug 15, 2012) my friend Brian Kelley (blog, LinkedIn, Twitter) is presenting for the PASS Professional Development chapter...
2012-08-10
439 reads
I haven’t done a #meme15 blog assignment in a while and figured I would pop one off as the weekend...
2012-08-10
759 reads
Last April I experienced the most amazing training event I have participated in so far in my life (yet).
I actually...
2012-08-10
670 reads
My standing desk experiment has worked out well. I have gotten used to standing there and I’ve slowly found places...
2012-08-10
1,214 reads
The PASS Data Architecture Virtual Chapter hosts none other than Dr. SQL Louis Davidson as he helps application and database...
2012-08-10
1,048 reads
The next Tampa Code Camp will be held October 13 at University of South Florida, 4202 East Fowler Avenue,Tampa, FL...
2012-08-10
500 reads
This coming Wednesday I will be speaking for the PASS Professional Development virtual chapter. My talk will be on my...
2012-08-10
2,125 reads
There are many free eBooks & resources available from Microsoft and members of the MVP community. This is a collection of...
2012-08-10
1,372 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