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
6 reads
Si vis pacem, para sql
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
8 reads
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...
2016-12-01
260 reads
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...
2016-12-01
824 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e81b52eda1f0195410103/] Even simple, this query was causing troubles on our production...
2016-11-11
4 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered. [crayon-5e96566159ca8644006533/] Even simple, this query was causing troubles on our production...
2016-11-11
17 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered.
SELECT
[GroupBy1].[A1] AS...
2016-11-11
261 reads
What does an Index mean to a Query
This post is about the importance of a right index to a query. The following simple query was considered.<?query --SELECT [GroupBy1].[A1]...
2016-11-11
334 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
14 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
2 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers