Monthly Archives: April 2009

Storing Images and BLOB files in SQL Server

CREATE TABLE BLOBTest ( TestID int IDENTITY(1,1), BLOBName varChar(50), BLOBData varBinary(MAX) ); INSERT INTO BLOBTest (BLOBName, BLOBData) SELECT ‘First test file’, BulkColumn FROM OPENROWSET( Bulk ‘C:\temp\nextup.jpg’, SINGLE_BLOB) AS BLOB Storing Images and BLOB files in SQL Server (databasejournal.com) Part 2

Posted in SQL Server 2005 | Leave a comment

Displaying sizes of SQL Server Database Tables

CREATE PROCEDURE dbo.TableSpaceUsed AS — Create the temporary table… CREATE TABLE #tblResults ( [name] nvarchar(20), [rows] int, [reserved] varchar(18), [reserved_int] int default(0), [data] varchar(18), [data_int] int default(0), [index_size] varchar(18), [index_size_int] int default(0), [unused] varchar(18), [unused_int] int default(0) ) — Populate … Continue reading

Posted in SQL Server 2005 | 1 Comment

SNMPLINK – ONLINE MIBS (Standards, Cisco, Juniper, Extreme, Brocade, Founrdy)

SNMPLINK – ONLINE MIBS for Standards Cisco Juniper Extreme Brocade

Posted in Uncategorized | Leave a comment