Browse by Tags
All Tags »
tsql (RSS)
Recently I have received an email about unable to drop schemas that are adopted in the database design within an environment, here it goes. I'm setting up an automatic build process that also includes building one or more databases. Initially it was decided
Read More...
DMV - has got very special place for DBAs since the inception of SQL Server 2005. In this case one of the thme is very important to find out the index statistics within your database, such as sys.dm_db_index_physical_stats statement. Recently one of the
Read More...
Audit trace is very helpful when you want to monitor a particular processes on your SQL Server, even for the successful logins and recent users activity on the databsaes. But the default trace would have many columns with the information and you need
Read More...
Second time again I have been caught in performing the dynamic formatting, though this is more kind of development type of question and I was searching through Reporting Services side. The issue is to change/highlight the color of a row, base on its value,
Read More...
You may be aware the DML and DDL triggers can be nested up to 32 levels, because any reference to such trigger code counts as one-level in the nesting limit. Even though it is possible to control whether AFTER triggers can be nested through the nested
Read More...
SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc
Read More...
Have you ever gave a thought about writing a code within your development environment, I'm talking about writing TSQL scripts and not going for programming languages such as C# or ASP.net. So what is your favourite in this case: Look at this SQLBlog discussion,
Read More...