|
|
-
Krishnrajsinh Rana Learned 1 Years ago through Just Learned | 1 Point
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 i...
|
-
Krishnrajsinh Rana Liked 1 Years ago through Just Learned | 1 Point
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 F...
|
-
Krishnrajsinh Rana Learned 1 Years ago through Just Learned | 1 Point
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 F...
|
-
Krishnrajsinh Rana Liked 1 Years ago through Just Learned | 1 Point
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 F...
|
-
Krishnrajsinh Rana Learned 1 Years ago through Just Learned | 1 Point
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 F...
|
-
Krishnrajsinh Rana Liked 1 Years ago through Just Learned | 1 Point
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
|
-
Krishnrajsinh Rana Liked 1 Years ago through Just Learned | 1 Point
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
|
-
Krishnrajsinh Rana Liked 1 Years ago through Just Learned | 1 Point
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 w...
|
-
Krishnrajsinh Rana knew 1 Years ago through Just Learned | 1 Point
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 w...
|
-
Krishnrajsinh Rana Liked 1 Years ago through Just Learned | 1 Point
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 w...
|