Checking the Instance Fill Factor
I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill...
2013-01-03
2,531 reads
I was reading a post from Paul Randal recently and noted that he recommends not changing the instance’s default fill...
2013-01-03
2,531 reads
When installing Master Data Services (MDS) in SQL Server 2012 or installing SQL Server 2012 sp1 (and possibly a CU),...
2013-01-03
2,570 reads
If you’re over in the UK, or close to it, you’ve probably heard of SQL Bits even if you haven’t...
2013-01-07 (first published: 2013-01-03)
1,541 reads
Do your civic duty, and vote today!
Voting is now open for SQLBits, to be held in Nottingham, UK this...
2013-01-07 (first published: 2013-01-03)
1,604 reads
Sometimes when you insert row on heap, even if the page has enough free space, the new row can not...
2013-01-03
982 reads
The WordPress.com stats helper monkeys prepared a 2012 annual report for this blog.
Here’s an excerpt:
600 people reached the top of...
2013-01-03
736 reads
I have read much about SQL Saturday’s but I have yet to attend one, that is about to change. I...
2013-01-03
837 reads
For at least a year, I’ve been considering changing blog platforms. I set up my blog on TimMitchell.net using BlogEngine.NET...
2013-01-03
911 reads
This third part in my series of self-tutorials in SQL Server Data Mining (SSDM) was delayed for several weeks due...
2013-01-03
1,932 reads
Recently I have been supporting our move from TFS from 2010 to TFS 2012. The database instances is stored on a server that I do not have log on...
2013-01-03
20 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