This script will reindex (online) any index eligible to be reindexed online. Accepts a day of week parameter for full offline reindexing.
2011-04-18 (first published: 2008-10-01)
4,634 reads
The procedure below deletes all records from the specified database's(except master, model, msdb and tempdb) tables (except those from the schema 'sys').
2011-12-09 (first published: 2008-01-31)
4,118 reads
Procedure changes all databases' recovery mode to simple and shrinks them all (or at least it tries to).
2012-03-07 (first published: 2008-01-14)
3,876 reads
2011-09-20 (first published: 2008-01-11)
2,387 reads
This will sum all of the records of a specified database, excluding the 'sysdiagrams' table.
2013-10-23 (first published: 2007-12-17)
19,644 reads
That returns an answer, but not the correct answer. You've included parentheses which affect the order of computation. I suppose the QOD was really asking "Does SQL Server do algebraic computation or left-to-right computation?"
2004-06-18
2 reads
2004-06-15
I have had a similar problem with a large first transaction log backup. It turned out that, as part of the maintenance plan, there was a rebuild index step just before the full backup.By adding a truncate log step just before the full backup, the problem was solved.Maybe this will help. Erik
2004-06-03
Hi,In DTS designer, add a "Transform Data Task" object, giving the src as your csv file. After specifying the destination table, got to Transformations, add a new ActiveXScript, click properties, and add somthing like:Function Main() DTSDestination("dest_col_name") = DTSSource("src_col_name") ' or = DTSSource("col00x") Main = DTSTransformStat_OK End Function...with your 'date', you'll need to do a Cast […]
2004-05-26
Corrupted cluster index on a replicated table. I can fix the problem - I/O error (bad page ID) detected during read at offset. DBCC checkdb shows a corruption on an index. Normally I would drop/recreate the index or run checkdb with a repair_rebuild, but this table is replicated. What steps are needed to fix the […]
2004-01-29
2 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