First steps with Extreme Transaction Processing – Hekaton
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...
2013-07-02 (first published: 2013-06-25)
3,883 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
A few hours...
2013-07-02 (first published: 2013-06-25)
3,883 reads
CTP 1 of SQL Server 2014 was released this evening. If you have an MSDN or TechNet account you can...
2013-06-25
685 reads
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major problem.
In this post I share with you what I...
2013-06-25
24 reads
Your actions as a Database Administrator can make the difference between a disaster being a minor nuisance or a major...
2013-07-01 (first published: 2013-06-25)
2,884 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-28 (first published: 2013-06-25)
2,799 reads
It is here! the first CTP for SQL 2014 is available for download from the Technet evaluation centre... Just downloaded...
2013-06-25
607 reads
This month, Thursday, June 27, 2013, the NYC SQL User Group be doing something a little different. Instead of a technical presentation,...
2013-06-25
946 reads
As I mentioned in my blog post describing the new features in the next version of SQL Server (see SQL Server...
2013-06-25
1,223 reads
by Steve Bolton
…………In my last post in this amateur series of self-tutorials on SQL Server Data Mining (SSDM), I got...
2013-06-27 (first published: 2013-06-25)
2,759 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-24
1,129 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