CPU Spikes Caused by Periodic Scheduled Jobs
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation....
2016-12-01
12 reads
In this article I’ll show you how to eliminate periodic spikes in the CPU that are caused by the jobs that execute periodically. Figure 1 shows such a situation....
2016-12-01
12 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
272 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
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