Thank you for your comments.Anyway, I found no errors in the LOG before the query was run.Furthermore, I restored a backup to recover the database and then ran a DBCC CHECKDB with no errors. I thought it was OK, but the client ran a batch and a couple of queries (very similar to the one described above). […]
2004-09-01
how do i calculate no. of days between 2 dates in oracle. select expiry_Dt-sysdate as noofdays from oracle ?? how exactly
2004-08-05
1 reads
Good approach Gregory.Make a small set of high level Database Administration Standards. Covering the setup of Sql Servers and Databases, including the following: Security Backup Size, growth and placement of Data & Logfiles (not autogrow 10% until disk crammed) Collations Database Options ... Naming standards for (new) databases, jobs ...Write a script that checks a server […]
2004-07-20
I get the above message in ActiveX script when I use Excel_Workbook.Save If I click Continue the files save OK. I have tried manually overwriting the templates on the Production server using Excel 97 but this does not seem to resolve the problem when I rerun the package. Apart from completely rebuilding the templates starting […]
2004-07-13
23 reads
Hi, thanks for your response. The insert is done inside the the SP2 as foolowsSP1 is called with ther 4 paramsSP1 'C', 'TEST', 'fdfdfd', 'myTableName',As you can see the 4th one is a table name.Inside this SP, the call to SP2 is done through the dynamic SQL which it's 4th param is a table. Inside this […]
2004-06-12
Here is a script from the BOL that will defragment indices without going into single user mode:/*Perform a 'USE <database name>' to select the database in which to run the script.*/ /* This will make a table called IndexFragmintation List the lists the index info */ /* For best results, run this with query results […]
2004-04-15
Old School:loop through all SP's exec sp_helptext 'proc name' search text break (when found)end
2004-04-09
1 reads
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...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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