Last Weeks Top “Reading” Links #36
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-10
525 reads
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of...
2013-06-10
525 reads
One of my friend requested me to give a mutli server script to pull SQL Service related details. Here is...
2013-06-10
1,749 reads
One of my favorite additions to SQL Server 2012 is the Availability Groups, referred to as AlwaysOn. These things are...
2013-06-10
825 reads
After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works...
2013-06-10
4,085 reads
Multiple value parameters are a common tools used in SSRS. You can use this tool to select which columns actually...
2013-06-12 (first published: 2013-06-10)
3,705 reads
To get database size information we can use sys.master_files catalog view. This view contains a row per file of a...
2013-06-10
1,302 reads
Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has...
2013-06-10
722 reads
It’s that time of year again… end of the school year, graduation, Fathers’ Day and of course; time to take...
2013-06-10
506 reads
Introduction
A week late and more than a few dollars short, this blog post is focusing on a few of the features announced for SQL Sever 2014. I’ve watched the...
2013-06-10
21 reads
PASS Summit is the world's largest and most intensive technical training conference for Microsoft SQL Server and BI professionals. But more...
2013-06-09
686 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