It is never a good idea to let your users be the ones to tell you of database server outages. It is far better to be able to spot potential problems by being alerted for the most relevant conditions on your servers at the best threshold. This will take time and patience, but the reward will be an alerting system which allows you to deal more effectively with issues before they involve system down-time.
2011-09-01
3,959 reads
If your SQL Server’s tempdb database is heavily used by your application(s), consider locating it on an array of its own (such as RAID 1 or RAID 10). This will allow disk I/O to be more evenly distributed, reducing disk I/O contention issues, and speeding up SQL Server’s overall performance.
2011-08-31
5,236 reads
Total Information Awareness can destroy your sanity. Get used to it.
2011-08-30 (first published: 2009-09-02)
11,273 reads
Part 4 of a series from Matt Perdeck on speeding up your database access. This is a great series for developers. This is based on the book ASP.NET Site Performance Secrets.
2011-08-30
10,448 reads
A report might contain multiple data series on a chart, which can have considerably varying scales but common category groups. In such cases where this a big difference in scales, the data series with the lower scale can become obscured. In this tip we will take a look at how to solve this problem using Chart Areas.
2011-08-30
17,832 reads
Nothing new for many developers, but I still like the way you can maintain the stack throughout the call chain.
2011-08-29
6,791 reads
The sequential nature of early data storage devices such as punched card and magnetic tape once forced programmers to devise algorithms that made the best of sequential access. These ways of doing data-processing have become so entrenched that they are still used in modern relational database systems. There is now a better way, as Joe Celko explains.
2011-08-29
3,057 reads
In this tip you will learn how to design aggregations for a partition and optimize it for performance.
Solution
2011-08-26
3,561 reads
2011-08-25 (first published: 2009-08-26)
11,040 reads
A look at how the OVER clause is changing in SQL 11, based on the CTP 3 released to the public.
2011-08-25
9,415 reads
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Following on from my previous post on building The Burrito Bot, I want to...
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers