Cool Tool – SQL Space Map
I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation...
2013-04-17
900 reads
I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation...
2013-04-17
900 reads
The 12th cumulative update release for SQL Server 2008 R2 Service Pack 1 is now available for download at the...
2013-04-17
982 reads
WOW! This week I was featured on the ITCentralStation.com home page as their Reviewer of the Week with my review of...
2013-04-17
596 reads
First off, I’m sorry this space has been dead for so long. I’m sure I’ve dropped off many an RSS...
2013-04-16
874 reads
Last week at the PASS Business Analytics Conference in Chicago, Microsoft disclosed a public preview of GeoFlow for Excel (download). GeoFlow” is...
2013-04-16
889 reads
by Steve Bolton
Anyone who’s gotten this far in this series of amateur self-tutorials on SQL Server Data Mining (SSDM)...
2013-05-02 (first published: 2013-04-16)
3,030 reads
In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In...
2013-04-16
1,253 reads
The default install of SSIS only allows users with local admin rights on the server to connect. This can be...
2013-04-16
67 reads
We all have a bucket list – that list of things that we want to accomplish before one, well, kicks the...
2013-04-16
751 reads
I began this post back in October of 2012 after learning that I had passed the SQL Server 2008 MCM Knowledge exam. I had set it aside in hopes...
2013-04-16
21 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...
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