DBA should keep a list of tables which are not being used / referenced by anyone in last few weeks. At times, we come up with a requirement where developer asks, can I have list of unused tables or “Can you tell me the tables which are not being used in l

How do I know which deprecated features I’m using? To find out, run the following query: [code] SELECT instance_name AS 'Deprecated Feature', cntr_value AS 'Times Used' FROM sys.dm_os_performance_counters WHERE object_name = 'SQLServer:Deprecated Feat

Recently I got a requirement to display groups along with number of products in the group, where cost of product falls in certain range. Additional requirement is, even if a group doesn’t have any items in the range; still show that group with the Number

I just learned from Jacob sir that one can capture (only) the active window by using ALT + PrtScn command. Previosuly i used for snipping tool for capturing "active windows" but now having learned about ALT + PrtScn would make life easier. It's a nice keyb

I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query. Method #1 [code] SELECT a.name AS Table_Name,b.name As Index_Name FROM sys.tables a INNER JOIN sys.spatial_indexes b ON a.object_id=b.o

Sometimes while writing a query, we might have the requirement of dynamic sorting, i.e. sorting based on different column based on certain conditions. To do this often developers will use dynamic queries. Without resorting to Dynamic queries, we can writ

Often in web applications, while displaying some data, we often pad data with some characters for uniform look. Suppose, to display dates in a combo box, we might want to display them as 00,01,02...30. Similarly in a numeric box with range 1 to 100, we mi

While you are working in Query window, if you want to delete the current row, you have to highlight entire row and press delete key. Another alternate is to use SHIFT+DEL key. The cursor can be at any position and the entire row will be deleted

SQL Server History [code] Version Year Release Name Codename --------------- -------- ----------------------------------- -------------------- 1.0 (OS/2) 1989 SQL Server 1.0 (16bit) - 1.1 (OS/2)

In this very short tip I'd like to share my solution to a yesterday quesiton in MSDN forum - how to find the database the table belongs to. I use my favorite idea of dynamically constructing a query using INFORMATION_SCHEMA.TABLES view. [code] DECLARE