Menu

Category: Microsoft SQL

Who is Active for MSSQL
06/26/2014
| No Comments
| Microsoft SQL

Who is Active is free SQL tool that you can download and use for personal, educational, and internal corporate purposes. If you work with MSSQL server and notice slowness this is a great tool for monitoring SQL transactions and performance in SQL server.  I personally use this tool for monitoring SQL deadlocks in the database. You can find more information in this page: http://sqlblog.com/blogs/adam_machanic/archive/2012/03/22/released-who-is-active-v11-11.aspx You can download the SQL script from here: http://sqlblog.com/files/folders/beta/entry42453.aspx The installation process is very simple:…

Read More

Understanding Microsoft SQL Server System Databases
02/28/2014
| No Comments
| Microsoft SQL

A database server application such as Microsoft SQL Server uses a lot of information in order to operate. Considering the purpose of a database is to store information, it only makes sense that SQL Server dips into its own technology for storing and accessing the information required for operating in a set of its own databases. Each of the databases used plays a specific role in the operation of the SQL Server. The system databases use the same components…

Read More

Determing SQL Server Table Size within a Database
01/24/2012
| No Comments
| Microsoft SQL, T-SQL Code

A common problem that I have recently encountered was trying to identity which table within a database was the biggest one (in record size), therefore, taking up the most physical storage space. I found and modify this store procedure to work with MSSQL 2000, MSSQL 2005, and MSSQL 2008  that will perform all needed data calls and will return a result set with the data on all tables. T-SQL Code:   USE DWDATA GO CREATE PROCEDURE GetAllTableSizes AS /* Obtains spaced used data for ALL user tables in the database */…

Read More

© 2019 www.myw0.com . All Rights Reserved
Design www.tenemaza.com