Last Weeks Top “Reading” Links #24
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-03-18
637 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-03-18
637 reads
GAAAAAAAHHHHH!!!!
I feel slightly better, but only slightly.
I started watching Star Trek: The Next Generation on Netflix just to unwind my...
2013-03-18
1,151 reads
When you create a new database in SQL Server without explicitly specifying database file locations, SQL Server created files in...
2013-03-18
2,233 reads
This past Saturday March 16th, I had the opportunity to speak once again the .Net Orlando Code Camp. I presented...
2013-03-18
812 reads
I meet Steve this past November in Seattle at the PASS Summit. Reading his series on XMLA and Analysis Services...
2013-03-17
648 reads
In the last post, we have discussed about non clustered index on a clustered table.In this post we will discuss...
2013-03-17
7,837 reads
One common surprise I have encountered in almost all my DBA environments is that a sql job that usually runs...
2013-03-17
948 reads
Today I had the pleasure of speaking at the inaugural SQL Saturday event in Detroit, MI. I spoke on one of my...
2013-03-16
626 reads
I had the opportunity to present a full-day preconference session on Friday, March 15, 2013 for SQLSaturday #188 in Lisbon,...
2013-03-16
737 reads
CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have...
2013-03-19 (first published: 2013-03-15)
2,465 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