by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id...
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
Lets see if I can explain how to rename a files using the File System Task in BIDS or SSIS. First you will need to add a File System Task to your Control Flow. (Drag and Drop it to the Form) Open the task and change the Opertaion to Rename File. Set the...
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
We were attempting to use Responsive SharePoint from CodePlex, They’ve done a lot of heavy lifting with regards to implementing Twitter Bootstrap within SharePoint 2013. After some testing we found that certain sites were becoming corrupt and throwing Errors and...
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
/****** Object: StoredProcedure [dbo].[SearchAllTables] Script Date: 3/14/2013 8:01:42 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROC [dbo].[SearchAllTables] ( @SearchStr nvarchar(100) ) AS BEGIN — Copyright © 2002 Narayana Vyas...
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
So one day, suddenly I find my development environment out of drive space, never good, but its my dev box and not a production system. So that’s the good news. Production Environment Fix(Contentdb): So I start poking around and find that the content database is...
by jeremy@bondbyte.com | Apr 23, 2014 | Uncategorized
http://tech.pro/tutorial/1155/obtaining-method-caller-information-in-c