1-10 of 64 Hubssort by Hot Best Latest
69Explanation of SQL Join: Obtaining data from multiple tables using Join
Explanation of SQL Join: Obtaining data from multiple tables using Join. Learn what exactly database join is. Know the syntax of joinging with easy detail explanation. And just remember the types of joining...
0 comments
81SQL Server Database Consistency Check Errors are Reported by DBCC CHECKDB
Microsoft SQL Server includes an inbuilt utility, called DBCC CHECKDB, to check the consistency and integrity of MDF (Master Database File). However, sometimes the DBCC CHECKDB process does not complete...
3 comments
74MS SQL Server Data Archive / Archiving
Discusses SQL Server Data Archiving utilities and how it's important in your disaster recovery plans.
1 comment
68Recovering SQL Server database from Error: 5171
MS SQL Server is the most preferred relational database management system by database users all over the world.
0 comments
65C-sharp, how to create a SQL connection
This article will show you how to create a SQL Client connection in C#. A connection is needed when an application interface or web interface want to connect to the MS SQL database. System.Data.SqlClient...
1 comment71MS SQL Server Interview Questions
What kind of ERP systems have you worked with? Manufacturing, service, accounting, sales tax? SQL Server Optimizations What are some of the optimization strategies you've employed? Triggers What's the most challenging trigger you've written,...
1 comment74Troubleshooting Error 'Msg 7105' in Microsoft SQL Server Database
Microsoft SQL Server supports LOB (Large Object) data types to store large amounts of data. Such data types include BLOB (Binary LOB), CLOB (Character LOB), and DBCLOB (Double-byte Character LOB). They...
0 comments57An insight into MS SQL Server 2005 enhancements, inconsistencies and some appropriate resolution measures
Microsoft offers several security enhancements for the SQL server 2005 but it still gets corrupt or damaged due to several reasons. A corrupt SQL server database can be restored from clean backup.
0 comments64Discussing Error 7991 in SQL Server 2000 and guidelines to perform SQL recovery
MS SQL Server stores information related to various objects, data types, constraints, etc. in system base tables. This information is known as metadata. The system base tables usually exist in the master database. These tables are not visible by...
0 comments60Tips to resolve “Table error … offset 0xADDRESS is invalid” Error
A table in MS SQL database can be corrupted due to various reasons. One of the most common being the corruption in metadata structure, caused due to damage of SQL Server damage. Once the table gets...
0 comments
