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”
Category: SQL Server 2008
Three Free Online Code Sandbox and Collaboration Tools for SQL, .NET, JavaScript
Being able to write and test code snippets in your Web browser in collaboration with others anywhere in the world is an empowering experience. This is especially true when the tool is free for anyone to use. I can see no better way for developers to learn new languages or code better applications when the old-school barriers of software and hardware are removed.
In the realms of coding for JavaScript, SQL, and .NET, I am aware of three very useful environments that I would suggest: JSFiddle, SQL Fiddle, and .NET Fiddle. In the article below I will briefly describe the capabilities of each tool and how they will give your programming efforts an edge. Continue reading “Three Free Online Code Sandbox and Collaboration Tools for SQL, .NET, JavaScript”
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”
Justin Cooney 