Skills I Used Last Week
Ever thought about what your average week looks like? What are the real core skills your environment uses every day...
2013-09-09 (first published: 2013-09-03)
2,435 reads
Ever thought about what your average week looks like? What are the real core skills your environment uses every day...
2013-09-09 (first published: 2013-09-03)
2,435 reads
I will be presenting the session “Building an Effective Data Warehouse Architecture” today at 11am CST for the PASS DBA Fundamentals...
2013-09-03
922 reads
Welcome to SQLSaturday #250 in Pittsburgh
http://www.sqlsaturday.com/250/
SQLSaturday is a full day FREE training event for SQL Server professionals and those wanting to learn more about SQL...
2013-09-05 (first published: 2013-09-03)
1,329 reads
When I run “Script (say table) as” it isn’t (or is) (say generating scripts for indexes). How do I fix...
2013-09-03
783 reads
Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for Curacao in my queue. I had fully intended on...
2013-09-03
14 reads
Wow, more than two weeks past SQL Saturday in Curacao and I find a partially written wrap up post for...
2013-09-03
787 reads
I really like my Windows Phone. Yes, there are not as many apps as on a Droid or iPhone. But...
2013-09-03
552 reads
As a DBA, we're often asked to troubleshoot performance issues for stored procedures. One of the most common tools at...
2013-09-06 (first published: 2013-09-03)
3,284 reads
Have you heard about Hadoop but don't know much about it? What about "big data?" Would you like an intro...
2013-09-09 (first published: 2013-09-03)
2,117 reads
Wrote this email recently to a crew of developers who were shooting themselves in the foot with a database rich...
2013-09-05 (first published: 2013-09-03)
3,233 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,...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
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...
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