New Vacancy on the PASS Board
Last week James Rowland-Jones announced that he would be resigning from the PASS Board to accept a position with Microsoft....
2015-12-11 (first published: 2015-12-07)
1,554 reads
Last week James Rowland-Jones announced that he would be resigning from the PASS Board to accept a position with Microsoft....
2015-12-11 (first published: 2015-12-07)
1,554 reads
Learning a programming language is largely an act of using that language to do stuff. Done.
However, the big thing about...
2015-12-07
1,267 reads
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,310 reads
New Year, new powerful SQL queries!
Start the New Year off with some great Transact-SQL training and join me for...
2015-12-07
463 reads
What's New in SQL Server 2016
Benefits of SQL Server 2016:
Enhanced in-memory performance provides up to 30x faster transactions, more than...
2015-12-07
138 reads
Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.
Adam...
2015-12-03
1,422 reads
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times...
2015-12-03
23 reads
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations...
2015-12-03
3,034 reads
I’m starting the new year with a trip to Nashville for SQLSaturday #480 to do presentation on automating restores. New topic,...
2015-12-03
577 reads
This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....
2015-12-03
563 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