Database maintenance progress
Often we need to know on which stage is a maintenance operation such as: backup, restore, check database. You can get this information using my script.
2018-01-17 (first published: 2018-01-12)
533 reads
Database Maintenance
Migrating Databases Checklist Part1
SQL Server databases move around as an organisation’s data grows, applications are enhanced or new versions of the database software are released. If not anything else, servers become old and unreliable and databases eventually need to find a new home. Here's what to do when migrating your databases.
2013-06-12
4,842 reads
How much space could you get shrinking all databases
This is script is useful when you are short of space on a drive and you need to know how much space can you get shrinking your databases
2014-02-28 (first published: 2012-11-08)
2,727 reads
Turbocharge Your Database Maintenance With Service Broker: Part 1
Are your maintenance windows too wide? Find out how to shrink them with Service Broker.
2012-07-09
8,433 reads
RE: Storing images and pdf files in SQL Server 2000
We also conducted reseach as to where the best place to store images/documents. Our orignal plan was to store the images in the file system and use Availl to replicate the images through the firewall. We were having difficulty getting this to work properly, so opted for Plan B, storing the images in sql server. […]
2005-03-11
RE: Getting one column from a sp_help_Job
OK I tried creating a table but sp_help_job must create a table wothin the procedure because I am getting "An INSERT EXEC statement cannot be nested". So let me ask my question another way. I am trying to determine if a job started within a procedure is still running. How can I do that? I want […]
2004-02-11
RE: NT 4 support, when will it end ?
It's a phased retirement; explained here:http://www.microsoft.com/ntserver/ProductInfo/Availability/Retiring.asp
2004-01-13
RE: DeadLock
Although I don't have enough experience in resolving deadlocks to make a recommendation for you, I did just recently find an excellent resource on deadlocks. The Professional Association for SQL Server (PASS) web site now has three presentations from last year's conference that non-members can access for free, including a PowerPoint about deadlocks. Here is […]
2003-08-29
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers