Oh, The Free Stuff!
Ah, Shwag
I’ve been doing the whole conference thing for a while. Not as long as some but quite a while....
2013-10-08
898 reads
Ah, Shwag
I’ve been doing the whole conference thing for a while. Not as long as some but quite a while....
2013-10-08
898 reads
It’s T-SQL Tuesday time, the second Tuesday of the month when we all coordinate our blog posts on a particular...
2013-10-08
996 reads
I have talked about the Business Intelligence Maturity Model (see Business Intelligence Maturity Assessment), but I wanted to dig further into...
2013-10-08
2,262 reads
If you’ve been working with Azure for a while you probably signed up before they had the ability to create...
2013-10-08
826 reads
There could be a number of reasons why you would want to change the default view on a SharePoint library....
2013-10-08
805 reads
One of the secret weapons in performance tuning with SQL Server is understanding wait statistics. Every time a process (spid)...
2013-10-08
2,033 reads
The host for T-SQL Tuesday #47 is Kendal Van Dyke (blog|twitter), and his topic of choice is about the best...
2013-10-08
980 reads
Where does he get all those wonderful toys? In the line made famous by Jack Nicholson’s Joker in the original...
2013-10-08
1,539 reads
I started a new job a month ago, but didn’t want to just figure things out as they came to...
2013-10-08
854 reads
It’s time for T-SQL Tuesday again and this time Kendal Van Dyke is asking for Your Best SQL Server SWAG....
2013-10-08
762 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