In the Oracle world, great importance is attached to "instrumenting" your application code. However, it seems not to be an issue that is much discussed in SQL Server. Tony Davis wonders why...
2009-02-23
506 reads
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
2009-02-23
201 reads
One thing most DBAs try to avoid whenever possible is unexpected downtime. It still happens, and we have to deal with it. This Friday Steve Jones asks in the poll how much it happens to you.
2009-03-13 (first published: 2009-02-20)
294 reads
These days more and more systems gather data all the time, but are we using that data? Steve Jones comments on the glut of information and some of the problems that creates.
2009-02-19
171 reads
DBAs are expensive, so isn't their time valuable? Are you aware of what you cost the company and use your time wisely? Steve Jones talks a bit about how to choose on what you should be working.
2013-08-29 (first published: 2009-02-18)
325 reads
In which Phil Factor toys with the thought of producing quality metrics for SQL code, before dismissing the idea as foolhardy.
2019-04-30 (first published: 2009-02-17)
637 reads
Testing software is important, and the use of state models can help. This week Steve Jones talks about a new book that exposes software testing at Microsoft.
2009-02-16
115 reads
Steve Jones takes a break today and gives you a fun reel of mistakes and bloopers.
2009-02-16
74 reads
What type of leadership do you want in your company? Steve Jones asks who you want to help steward you through these tough economic times.
2009-02-13
84 reads
What does global warming have to do with BI? Steve Jones explains.
2009-02-12
199 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Comments posted to this topic are about the item Changing the Recovery Time
Comments posted to this topic are about the item Getting More Time from AI
Comments posted to this topic are about the item When Page Prefetching Takes a...
I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?
ALTER DATABASE Finance SET TARGET_RECOVERY_TIME = 12 xxx;See possible answers