It is listed as freeware under the downloads option and not under the regular product section. I have used it before and found it to be effective. Here is the linkhttp://www.lumigent.com/downloads/schemaalert/
2004-06-24
Like this???Select SX.Status From StatusXref SX join ITRegInfo ITRI on SX.StatusId = ITRI.StatusSteve
2004-06-22
2004-06-22
http://www.lazydba.com hosts a DB2 mailing list. You might want to post there.
2004-06-22
When trying to export data from a table to a flat text file, I am suddenly encountering a failure, with the error message stating that the transaction log of tempdb is full and it needs to be backed up.I'm using the DTS wizard to create the export, the data is being pulled from one table, […]
2004-06-17
2 reads
pwdencrypt is not a documented feature of SQL Server (in other words, don't use it, get some real encryption).But hey, in anycase, it returns a varbinary result, not a nvarchar result, so mashing it into a nvarchar will probably earn you problems.QA is going biserk because its expecting double-byte unicode to come out of the […]
2004-06-17
Index Creation Guidelines for SQL Server can be pretty sparse. Usually there are a couple, clustered index for ranges, nonclustered, etc. Leo Peysakhovich has taken some time to write down his guidelines based on his experience for creating indexes and the rational for doing so. He's also taken a few minutes to look at which indexes NOT to create, something that might be worth knowing..
2007-10-02 (first published: 2004-06-16)
41,406 reads
Oops. I found the problem myself - persistence is the key. I omitted the "New" keyword when I declared the DataSet variable.
2004-06-11
This script is supported only in SQL SERVER 2000, This shows only indexes created by users in tables.Parameter @tabela--> You can put the table name and get the information about users indexes in this table.OrYou can put nothing (NULL) and see all tables on the schema and how many indexes each table have.
2004-09-10 (first published: 2004-06-08)
229 reads
Thank you for your reply.The server has currently got 4Gb RAM, I have tried setting the memory to fixed starting with 0 min to 1536 max. Reason for 1536 is because it is running standard edition and I read it somewhere that it can only access up to 2Gb of RAM, plus the fact that […]
2004-06-03
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers