Problem where you can only browse Google websites
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution...
2016-12-01
544 reads
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution...
2016-12-01
544 reads
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs...
2016-12-01
271 reads
Wooo!OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline. However, I just stumbled across a feature in SSIS that I...
2016-12-01
116 reads
Not a technical post today (not that I am technical) but still an important one. I have been using Azure...
2016-12-01
646 reads
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs...
2016-12-01
844 reads
Wooo!
OK - maybe too much of a celebration... and I do have meatier topics in the article pipeline. However, I just...
2016-12-08 (first published: 2016-12-01)
1,584 reads
Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. They are usually...
2016-12-01
590 reads
Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB...
2016-11-30
885 reads
Awhile back I was working in SSMS and saw this window.
It threw me off since I was trying to write...
2016-12-16 (first published: 2016-11-30)
1,843 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-30
830 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