|
|
-
Hardik Doshi Posted 1 Years ago through Just Learned | 5 Points
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...
|
-
Hardik Doshi Posted 1 Years ago through Just Learned | 5 Points
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...
|
-
Hardik Doshi Posted 2 Years ago through Just Learned | 5 Points
My team mate was working with legacy code. Code used ISNULL and NULLIF functions, he got confused becauase of similar name.
Thought of sharing with you all.
ISNULL - Replaces NULL with the specified replacement value.
NULLIF - Returns a null ...
|
-
Hardik Doshi Posted 2 Years ago through Just Learned | 5 Points
My team mate was working with legacy code. Code used ISNULL and NULLIF functions, he got confused becauase of similar name.
Thought of sharing with you all.
ISNULL - Replaces NULL with the specified replacement value.
NULLIF - Returns a null ...
|
-
Hardik Doshi Posted 2 Years ago through Just Learned | 5 Points
I have just learned from Madhivanan's blog that we can use VALUES clause inside the FROM clause like:
[code]
DECLARE @value1 DECIMAL(5, 2) = 9.22
DECLARE @value2 DECIMAL(5, 2) = 8.34
SELECT *
FROM ( VALUES
( @Value1 ),
( @...
|
-
Hardik Doshi Posted 2 Years ago through Just Learned | 5 Points
I have just learned from Madhivanan's blog that we can use VALUES clause inside the FROM clause like:
[code]
DECLARE @value1 DECIMAL(5, 2) = 9.22
DECLARE @value2 DECIMAL(5, 2) = 8.34
SELECT *
FROM ( VALUES
( @Value1 ),
( @...
|
-
Hardik Doshi Posted 2 Years ago through Just Learned | 5 Points
Do you know we can get the definition of all the database programmable objects using a single query only?
You can get the definition of procedure, view, trigger and function using following query:
[code]
SELECT OBJECT_NAME(object_id),
def...
|
-
Hardik Doshi Posted 2 Years ago through Just Learned | 5 Points
Do you know we can get the definition of all the database programmable objects using a single query only?
You can get the definition of procedure, view, trigger and function using following query:
[code]
SELECT OBJECT_NAME(object_id),
def...
|