How To's

This topic contains hints and procedures step by step about how to do DBA tasks on SQL Server Database.

Size of user tables on SQL database — by Vinícius Perallis — last modified 2008-04-09 06:02

procedure returns the size of every user tables for one specific database

Character Sort for SQL SERVER — by Vinícius Perallis — last modified 2008-04-09 06:03

Character Sort for SQL SERVER 2000 and SQL SERVER 2005

How To Retrieve Rows Randomically in SQL Server — by Gustavo Maia Aguiar — last modified 2009-01-29 17:54

 

Dynamic XML from SQL Server — by Josana Bujokas da Rosa — last modified 2009-01-29 17:53

In this article you have seen how to generate XML from a relational table using SQL server 2005 and with the introduction of the xml datatype in SQL we are able to store and retrieve XML data easily. While the FOR XML clause gives us the power to tailor the XML to our needs.

How To Retrieve All Tables and Number of Rows on SQL SERVER — by Gustavo Maia Aguiar — last modified 2009-01-29 17:52

This tip describes how to retrive all the tables names and the number of records of them

Moving SQL Server Database Files — by Josana Bujokas da Rosa — last modified 2009-01-29 17:53

Over time the requirements of a SQL Server system can change. Sometimes this will necessitate the relocation of databases from one disk or server to another. This can be easily achieved using the standard SQL functions to detach and attach databases.

How To Kill All Users In Specific Database On SQL Server — by Gustavo Maia Aguiar — last modified 2009-03-20 14:40

This tip describe how to kill all the users in specific database on SQL Server. Is very common to need to kill all the users to perform maintenance tasks like reindex, change some properties and so on.

How To Update Data In One Table Related To Another Table On SQL Server — by Gustavo Maia Aguiar — last modified 2009-01-29 18:53

This tip describes how to update data in one table with data related to another table. It's not uncommon to perform this since the RDBMS link all the tables via primary keys and foreign keys

Typical solutions to avoid using "NOT IN" on SQL Server — by Gustavo Maia Aguiar — last modified 2009-01-31 13:08

It's very common to use the operator NOT IN to retrive rows in table (or SQL statement) that are not in another table or other SQL Statement. This operator sometimes can slow down the performance and sometimes returns unexpected results. There are options to avoid it.

How to Import Blobs To SQL Server (2005 and Later) — by Gustavo Maia Aguiar — last modified 2009-02-06 09:22

This tip describes how to import blobs into SQL Server 2005 and Later using TSQL. In past versions, there is a command line tool to provide this feature called textcopy.exe. In SQL Server 2005 and later versions it's possible to do it using only TSQL. In this tip, I'll use an XML Document on the file system

How to check the status for a specific trigger in SQL Server — by Gustavo Maia Aguiar — last modified 2009-02-06 11:11

Sometimes it's necessary to check if the status of a specific trigger is enabled or disabled to know if some actions will be or not be performed. This task common lead the developers (and even DBAs) to check this using graphical tools like Enterprise Manager and SQL Server Management Studio. It's an option of course, but there is a way to discover it using TSQL commands.

How to discover which action fires a specific trigger in SQL Server — by Gustavo Maia Aguiar — last modified 2009-02-06 11:11

It's not uncommon the need to discover which action fires a specific trigger (in other words which actions that trigger is related).