Blogroll
- BioTeck.NET
- Calvyn/IT Engineer
- Certless Designer
- Documentation
- Dreamnetworkz
- e-leaguers – Web design
- easy make money online
- Gadget news, Tech blog
- GaryOoi
- GeekAdviser.com
- Heartbeat
- iappsgeek
- increase traffic free
- Jayce Ooi’s Paradise
- PhotoshopSlave
- Plugins
- Portachi web directory
- Pricing Strategies
- Software Tips
- techetron.com
- Themes
- Wordpress Blog Tips
Database Archive
-
Overview of SQLCMD command in Microsoft SQL Server
Posted on January 2, 2012 | 1 CommentMicrosoft SQL Server provides a tool to connect to the SQL Server database to run SQL queries all from the command line. This is useful for database administrators who need to quickly connect to run a SQL command without having to start the SQL Server... -
How-to Snippet: SQL Server 2005 Internal error. Buffer provided to read column value is too small.
Posted on June 24, 2011 | No CommentsSome of you may have come across this error message in SQL Server 2005. SQL Server 2005: “Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption”. If you run a DBCC CHECKDB, it will return... -
HOW TO: PIVOT in SQL Server 2005 to produce cross tabulation
Posted on June 8, 2011 | No CommentsThere was no easy way to produce a cross tabulation in SQL Server 2000 but in SQL Server 2005, this is achievable using the PIVOT command. Here is a example on how to produce a cross tabulation in SQL Server 2005. In the example below,... -
Creating indexed views in SQL Server 2005 – Quick Guide
Posted on January 10, 2011 | 1 CommentHere’s a quick guide on how to create indexed views in SQL Server 2005. How do you create indexed views in SQL Server 2005? 1) Create a table in your database, e.g. CREATE TABLE [dbo].[TestTableSC] ( [ID] [INT] NOT NULL, [name] [varchar] (100) NULL, [description]... -
SQL Mail deprecated in SQL Server 2005 64-bit
Posted on December 7, 2010 | No CommentsThe legacy SQLMail support is no longer available in SQL Server 2005 64-bit. In lower version, i.e. SQL Server 2005 32-bit, SQL Mail is marked as a legacy functionality but you can still setup SQLMail and use it in your Stored Procedures. SQLMail has been...
