Higher Education Retention Analytics using Power BI
Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This...
2016-06-06 (first published: 2016-06-01)
2,393 reads
Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This...
2016-06-06 (first published: 2016-06-01)
2,393 reads
Welcome to an exciting new FREE class that I am launching today! Over the next year (that’s right year!) I...
2016-06-01
2,259 reads
The Azure Data Platform is taking off. I’m seeing more and more interest on the forums, at conferences and in...
2016-06-01
440 reads
That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the...
2016-06-08 (first published: 2016-06-01)
2,715 reads
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage was over. The big deal wasn’t that it didn’t...
2016-06-01
82 reads
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage...
2016-06-01
547 reads
This happens at my instance of SSMS and at the colleagues' one it doesn't. The SQL Server Agent duplicates its...
2016-06-01
237 reads
In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do...
2016-06-08 (first published: 2016-06-01)
2,044 reads
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...
2016-06-01
190 reads
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and...
2016-05-31
1,194 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