|
|
-
Rishabh Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Rishabh Commented 1 Years ago through Interview Questions
@@Marc: Clustered index define how the data is logically stored not physically. The data can be stored at any address only the slots are maintained according to the index key values...
|
-
Rishabh Commented 1 Years ago through Interview Questions
I would personally not go for such a large number of rows as index columns..side effects could be increase number of levels also SQL maintains statistics on the leading column. It would be nice to include the other columns with include option...
|
-
Rishabh Commented 1 Years ago through Interview Questions
yes..but you cannot truncate the table if it is referenced by the foreign key...so in that case DBCC checkIdent is proves to be useful...
|
-
Rishabh liked 1 Years ago through Interview Questions
Interview questions and answers on various SQL Server areas such as Database Administration, TSQL Development, BI etc....
|
-
Rishabh Liked 2 Years ago through What is New
Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"...
|
-
Rishabh Commented 2 Years ago through What is New
Hi Jacob, Where I Can find the syntax of these newly introduced features?...
|
|
|
-
Rishabh Commented 2 Years ago through Puzzles
IF OBJECT_ID('TC1_BIRDS','U') IS NOT NULL BEGIN
DROP TABLE TC1_BIRDS
END
GO
CREATE TABLE TC1_BIRDS(
Code INT,
Name VARCHAR(10)
)
GO
INSERT INTO TC1_BIRDS(Code,Name)
SELECT 1,'Pigeon' UNION ALL
SELECT 2,'Sparrow' UNION ALL
SELECT 3,'Parro
|
-
This challenge is about finding second highest salary for each department...
|