Binaryworld - VB, VB.net, ASP, SQL Server Articles, Codes, Tutorials and Programming Resources

Code / Articles / Tutorials for VB, VB.net, SQL Server, ASP.net and VC++

PostedOn	Language	Category	Code Name
11/09/2003	SQL Server	Stored Procedure	SQL Server 2000 useful undocumented stored procedures
11/09/2003	SQL Server	Stored Procedure	Useful undocumented extended stored procedures
11/09/2003	SQL Server	Indexing	Index Optimization Tips
11/09/2003	SQL Server	T-SQL	OLE Automation in SQL server
11/09/2003	SQL Server	T-SQL	Working with COM objects from within T-SQL
11/09/2003	SQL Server	Performance	Some Useful Undocumented SQL Server 7.0 and 2000 DBCC Commands
11/09/2003	SQL Server	Stored Procedure	generate script for all stored procedures for the given database.
11/09/2003	SQL Server	Stored Procedure	Get all databse objected created between specified daterange
11/09/2003	SQL Server	Stored Procedure	Get table size and number of records for all tables in the specified database
11/09/2003	SQL Server	Stored Procedure	Get all objects created before a specified date
11/09/2003	SQL Server	Stored Procedure	Change Object Owner
11/09/2003	SQL Server	Stored Procedure	search and replace substring
11/09/2003	SQL Server	Stored Procedure	Advanced lock monitor stored procedure
11/09/2003	SQL Server	Stored Procedure	Run Script for each user
11/09/2003	SQL Server	Stored Procedure	Check integrity of all tables
11/09/2003	SQL Server	Stored Procedure	Rebuild All Indexes
11/09/2003	SQL Server	Stored Procedure	Defragment of Indexes
11/09/2003	SQL Server	Stored Procedure	Generate Insert Statements
11/09/2003	SQL Server	Stored Procedure	Export data to word file
11/09/2003	SQL Server	Stored Procedure	Export data to excel file
11/09/2003	SQL Server	BLOB (Text-Image)	Copy text or image into or out of SQL Server
11/09/2003	SQL Server	Performance	Retrive record count of all tables in the database . This is the fastest way to get record count.
11/09/2003	SQL Server	Performance	The fastest way to retrieve number of records in a table. This is an alternative of the standard "select count(*)...".
09/30/2003	SQL Server	T-SQL	Displaying random data from SQL table
10/08/2003	VB.net	ADO.net	UpdateDataAdapter - Update a data source through a DataAdapter
10/08/2003	VB.net	ADO.net	SetCommandsTransaction - Assign a transaction to the DataAdapter's commands
10/08/2003	VB.net	ADO.net	RestoreDatabase - Restoring a SQL Server database
10/08/2003	VB.net	ADO.net	IsSqlServerDatabasePresent - Checking whether a SQL Server database is present
10/08/2003	VB.net	ADO.net	GetTableColumns - Retrieving the column names of a table in a database
10/08/2003	VB.net	ADO.net	GetSqlServerDatabases - Retrieving the name of the installed SQL Server databases

(Page 98 of 133)

3985 Result(s) found