Multiple Tagging of TFS Work Items Using Excel
In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can...
2016-03-30
1,041 reads
In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can...
2016-03-30
1,041 reads
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the...
2016-03-30
797 reads
SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from...
2016-03-29
25 reads
Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You...
2016-04-12 (first published: 2016-03-29)
2,647 reads
Last week, I received an alert that the percentage of transaction log in use on one of our production databases...
2016-03-29
1,013 reads
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We...
2016-03-29
921 reads
It’s Tuesday, and the Monday post is late. A weekend of smoking quite a few pounds of pork kept me in...
2016-03-29
938 reads
The sa account is a well, known, built in account for SQL Server. Years ago, in previous
versions, I’d see...
2016-03-29
979 reads
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
500 reads
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some...
2016-03-29
968 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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