http://www.dbatodba.com These are the search results for the query, showing results 1 to 8. http://www.dbatodba.com/sql-server/how-tos/how-to-discover-which-action-fires-a-specific-trigger-in-sql-server It's not uncommon the need to discover which action fires a specific trigger (in other words which actions that trigger is related). No publisher gmaguiar 2009-02-06T13:11:58Z Page http://www.dbatodba.com/sql-server/how-tos/how-to-check-the-status-for-a-specific-trigger-in-sql-server 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. No publisher gmaguiar 2009-02-06T13:11:28Z Page http://www.dbatodba.com/sql-server/how-tos/how-to-import-blobs-to-sql-server-2005-and-later 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 No publisher gmaguiar 2009-02-06T11:22:14Z Page http://www.dbatodba.com/sql-server/how-tos/typical-solutions-to-avoid-using-not-in-on-sql-server 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. No publisher gmaguiar 2009-01-31T15:08:48Z Page http://www.dbatodba.com/sql-server/how-tos/how-to-update-data-in-one-table-related-to-another-table-on-sql-server 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 No publisher gmaguiar 2009-01-29T20:53:45Z Page http://www.dbatodba.com/sql-server/how-tos/how-to-retrieve-all-the-tables-and-number-of-rows This tip describes how to retrive all the tables names and the number of records of them No publisher gmaguiar 2009-01-29T19:52:24Z Page http://www.dbatodba.com/sql-server/how-tos/how-to-retrieve-rows-randomically-in-sql-server No publisher gmaguiar 2009-01-29T19:54:14Z Page http://www.dbatodba.com/sql-server/how-tos/how-to-kill-all-users-in-specific-database-on-sql-server 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. No publisher gmaguiar 2009-03-20T17:40:17Z Page