Getting Started With SQL Server 2014 the Easy Way
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,170 reads
You know you want to at least take a look at the new Client Technology Preview (CTP) of SQL Server...
2013-07-05 (first published: 2013-07-01)
2,170 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-07-01
489 reads
I was trying to create a Named set in SSAS 2008 using the MDX calculations. I wanted to include all...
2013-07-05 (first published: 2013-07-01)
1,706 reads
If you have lost the password for sa account or does not have any administrative account and you are locked...
2013-07-03 (first published: 2013-07-01)
4,216 reads
Last month saw SQL Relay, Tech Ed, SQL Saturday Dublin, oh and the small matter of a CTP for SQL...
2013-07-01
683 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-28
1,177 reads
Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI...
2013-06-28
4,518 reads
From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about...
2013-06-28
1,634 reads
This week has been the week of the release: We’ve had the Visual Studio 2013 Preview and now the SQL Server 2014 CTP1. And that’s just the ones I’m...
2013-06-28
19 reads
In the Part 1 about SQL server Statistics, we have discussed about density vector information stored in the the statistics. In...
2013-06-27
16,317 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