T-SQL Simple Example of Finding Records with More than One Entry

Here is a super-simple example of using a T-SQL query to find records that have more than one table entry. Continue reading “T-SQL Simple Example of Finding Records with More than One Entry”

T-SQL Find Highly Populated Tables in a Database

When you are working with an unfamiliar database, such as a third-party SQL Server database, you want to find out which tables actually store the important data. If there is no clean database diagram, then the best option is to write a T-SQL query in SQL Server Management Studio (SSMS).

If you are interested in this topic, then I’d suggest also reading my article on batch searching your SQL Server database to find out in which tables the information is being stored.

Continue reading “T-SQL Find Highly Populated Tables in a Database”

Correcting: SELECT failed because the following SET options have incorrect settings: ‘ARITHABORT’

This error showed up on a stored procedure that I was trying to execute from an ASP.NET Web page. The strange part was that I could execute the stored procedure directly from SSMS without any problems.

The procedure was very simple in its design, but the database I was working in was new to me and I had very limited access. The procedure was set up to receive an XML parameter and then to do a bulk insert into a table from the XML. Continue reading “Correcting: SELECT failed because the following SET options have incorrect settings: ‘ARITHABORT’”