|
|
-
emy_math Liked 11 Months ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
emy_math liked 11 Months ago through Interview Questions
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|
|
|
-
emy_math Liked 1 Years ago through Just Learned
I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query.
Method #1
[code]
SELECT a.name AS Table_Name,b.name As Index_Name
FROM sys.tables a
INNER JOIN sys.spatial_indexes b
ON a.object_id=...
|
-
emy_math Learned 1 Years ago through Just Learned
I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query.
Method #1
[code]
SELECT a.name AS Table_Name,b.name As Index_Name
FROM sys.tables a
INNER JOIN sys.spatial_indexes b
ON a.object_id=...
|
-
emy_math Liked 1 Years ago through Just Learned
I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query.
Method #1
[code]
SELECT a.name AS Table_Name,b.name As Index_Name
FROM sys.tables a
INNER JOIN sys.spatial_indexes b
ON a.object_id=...
|
-
emy_math Learned 1 Years ago through Just Learned
I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query.
Method #1
[code]
SELECT a.name AS Table_Name,b.name As Index_Name
FROM sys.tables a
INNER JOIN sys.spatial_indexes b
ON a.object_id=...
|
-
emy_math Answered 1 Years ago through Quizzes
Triggers are stored TSQL code that is used to automatically perform a task when some type of SQL Server action occurs. As their name implies, a Trigger is triggered or set off by some monitored action.
These monitored actions can be one of three categ...
|
-
emy_math Liked 1 Years ago through Just Learned
I just learned one new thing today."How to get spatial index details with using T-SQL" check out following query.
Method #1
[code]
SELECT a.name AS Table_Name,b.name As Index_Name
FROM sys.tables a
INNER JOIN sys.spatial_indexes b
ON a.object_id=b.o
|
-
emy_math Liked 1 Years ago through Puzzles
This challenge invites you to solve a payroll challenge which requires special calculation of holidays and absences that are adjacent to holidays.
|