|
|
-
Sineetha Liked 1 Years ago through Just Learned | 1 Point
I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out...
Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which i...
|
-
Sineetha Learned 1 Years ago through Just Learned | 1 Point
I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out...
Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which i...
|
-
Sineetha Liked 1 Years ago through Just Learned | 1 Point
I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out...
Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which i...
|
-
Sineetha Learned 1 Years ago through Just Learned | 1 Point
I have always heard about the terms sargable and non-sargable but never really understood how they help in developing efficient sql code. Here is what I have found out...
Try to avoid WHERE clauses that are non-sargable. The term “sargable” (which i...
|
-
Sineetha 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...
|
-
Sineetha 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...
|
-
Sineetha 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...
|
-
Sineetha 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...
|
-
Sineetha 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
|
-
Sineetha Liked 2 Years ago through Just Learned | 1 Point
Often in many stored procedures, we will throw same error message by using RaiseError(). Instead we can register that error message using sp_addmessage and use the error message in all the stored procedures.
For example, often we will throw same ty...
|
RKA
91
·
2% ·
598
|
|