Browse by Tags

SQL Server Management Studio snap-in - get alerted when executing a TSQL code!

Published 15 February 8 4:26 AM | SSQA.net

Do you like color-coded alert say when you are executing a TSQL script or code against a SQL Server instance, say if its a production server with 'red' indicator or 'green' when it is on testing platform! I have no doubt in stating the...

Filed under: sql server, management, ssms, download, demo, alert, sample, tsql, code, toolkit, management studio, snap-in

TSQL to get a quick information on detailed distribution of memory allocated

Published 10 January 8 3:4 PM | SSQA.net

By design the components that are aware of the SQL Server memory management mechanisms use the buffer pool for small memory allocations. If the allocation is bigger than 8 KB, these components use memory outside of the buffer pool through the multi-page...

Filed under: sql server, management, memory, dmv, tsql, allocated, distribution, memory_clerk