-
When was the statistics last refreshed
Working with a few clients, I’ve noticed some issues with statistics in Sql Server 2005 not being updated frequently, even if auto stats is turned on at the database level and table level. I’ve noticed this often enough for me to cook up a quick script. Initially I thought that sys.stats catalog view might have…
-
BCP In automation script
A while ago I wrote an article on code generation using Sql. The script I gave in that article can generate BCP (in and out) scripts automatically. I helped out a friend recently, and thought I would share the WMI/VBScript I cooked up with you. This script assumes that all files within a folder need…
-
Bring back the mirror when the principal blows up and there is no witness
Here is the script you can use to bring the mirroring database out of its “Restoring…” coma: alter database MyDb set partner off restore database MyDb with recovery This is useful when you have high performance mirroring setup, your principal blows up, and there is no witness present. At this point, you will have to…
-
Character set and collation for simplified Chinese — MySQL
I am curious about character sets and collations, especially how they are used in databases. I got some time to play with them recently. I did some testing today on MySQL. I will do the same test on Sql Server, Oracle, and PostgreSql, time permitting. I am only dealing with simplified Chinese at this point.…
-
VMWare Converter and VMWare Server fun
I am playing with VMWare Converter and VMWare Server. Both are available for free. You do need to register to get the download link and serial numbers. Fake name, address, and email will do. VMWare Converter is pretty neat. It can suck the gut out of a physical machine, while it is running, and create…