SQL Server – How to Download and Install the ‘right’ AdventureWorks Sample Database
One of the first things I did when I began my journey with SQL Server was installing a sample database....
2013-07-31
1,610 reads
One of the first things I did when I began my journey with SQL Server was installing a sample database....
2013-07-31
1,610 reads
by Steve Bolton
…………As expected, I’ve run into quite a few obstacles while trying to deploy and debug my first plug-in...
2013-07-31
1,088 reads
Hello Dear Reader! This week finds me up in Jacksonville at Pragmatic Works HQ. I'm a little behind in getting...
2013-07-30
1,739 reads
If you like free SQL Server training you're in luck – starting at 12:00 PM GMT/8:00 AM EDT, July 31 (that's...
2013-07-30
1,355 reads
The latest 24 Hours of PASS (24HOP) event will start at 12:00 GMT on July 31, with 24 back-to-back one...
2013-07-30
1,323 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-07-30
1,751 reads
In SQL Server 2012, a new feature was added called Columnstore Indexes that resulted in huge query performance improvements. In SQL...
2013-07-30
3,107 reads
Must read blog: Sacha Chua. Lots of info on going solo, being productive, sketch noting.Related, if you’re trying to manage...
2013-07-30
1,139 reads
On one of the newsgroups I follow, I received a message that David Solomon will no longer be teaching seminars...
2013-07-30
1,435 reads
For our front office alone, I manage about 15-20 SQL database servers. Add to that other database servers that I...
2013-07-30
1,366 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