|
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
I just learned this from MSDN. Below script is used to find what are the stored procs are created with "Recomplie" option.
SELECT OBJECT_NAME(sm.object_id) AS ProcedureName,definition as SQLText
FROM sys.sql_modules SM
INNER JOIN sys.procedures S...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
I just learned this from MSDN. Below script is used to find what are the stored procs are created with "Recomplie" option.
SELECT OBJECT_NAME(sm.object_id) AS ProcedureName,definition as SQLText
FROM sys.sql_modules SM
INNER JOIN sys.procedures S...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned | 1 Point
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned | 1 Point
Just learned from Pinal's blog that Try_parse() and parse() functions are CLR functions and it will throw an error if CLR is not installed. Both these functions can be converted from string to numerics/datetime. These will give better performance compar...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|
-
Vishal Gajjar Liked 2 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|
-
Vishal Gajjar Learned 2 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|
-
Vishal Gajjar Learned 2 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|