Month: June 2015
http://www.extendoffice.com/documents/excel/670-excel-add-text-to-beginning-end-of-cell.html#formula There are two formulas to add specified text to the beginning or end of all selected cells in Microsoft Excel. Method 1: & formula Enter the =”Class A: “&A1 in Cell E1, and copy this formula to other cells with dragging the bottom right…
http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/10/20/consistency-checking-options-for-a-vldb.aspx DBCC CHECKDB includes: DBCC CHECKALLOC DBCC CHECKCATALOG DBCC CHECKTABLE http://sqlmag.com/blog/unkillable-dbcc-checkdb DBCC CHECKDB(‘DatabaseName’) WITH NO_INFOMSGS, ALL_ERRORMSGS http://www.bpsoftware.com/Blog/post/2008/11/25/SQL-DBCC-CHECKTABLE-on-multiple-tables.aspx — set options SET NOCOUNT ON; SET ANSI_PADDING ON; SET ANSI_NULLS ON; SET QUOTED_IDENTIFIER ON; DECLARE @tablenames TABLE (TableName VARCHAR(255)); — populate table with tablenames INSERT INTO…