|
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
[code]
SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
-- Above 2 queries will not display DEFAULT constraints list
SELECT * FROM sys.objects
WHERE type_desc = 'PRIMARY_KEY_CONST...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
[code]
SELECT * FROM INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
-- Above 2 queries will not display DEFAULT constraints list
SELECT * FROM sys.objects
WHERE type_desc = 'PRIMARY_KEY_CONST...
|
-
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 knew 2 Years ago through Just Learned | 1 Point
Just learned from pinal's blog that by using DBCC SQLPERF, we can clear the wait stats.
[code]
DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR);
[/code]......
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
Just learned from pinal's blog that by using DBCC SQLPERF, we can clear the wait stats.
[code]
DBCC SQLPERF('sys.dm_os_wait_stats', CLEAR);
[/code]......
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
I always thought that for Clustered Index, Rows physically will store in a page in order. In our recent Chennai UG meet, speaker Ramkumar explained paul randall myths. He mentioned that records are not stored in order, only slot array will be in order. ...
|
-
Vishal Gajjar knew 2 Years ago through Just Learned | 1 Point
I always thought that for Clustered Index, Rows physically will store in a page in order. In our recent Chennai UG meet, speaker Ramkumar explained paul randall myths. He mentioned that records are not stored in order, only slot array will be in order. ...
|