|
INTERVIEW QUESTIONS
DATABASE
MS SQL SERVER
DETAILS
Question: How To Create a Large Table with Random Data for Index Testing in MS SQL Server?
Answer: If you want to see how index can be used to improve data search performance, you have to build some large tables, which requires large amount of random data. This tutorial exercise helps you to build a large table with pure random data:
USE GlobalGuideLineDatabase; GO
-- Drop the old table, if needed DROP TABLE ggl_random; GO
-- Create a table with primary key CREATE TABLE ggl_random ( id INT, rand_integer INT, rand_number numeric(18,9), rand_datetime DATETIME, rand_string VARCHAR(80) ); GO
|
|
|
Category |
MS SQL Server Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.3) By 7240 users |
Added on |
9/23/2014 |
Views |
70335 |
Rate it! |
|
|
Question:
How To Create a Large Table with Random Data for Index Testing in MS SQL Server?
Answer:
If you want to see how index can be used to improve data search performance, you have to build some large tables, which requires large amount of random data. This tutorial exercise helps you to build a large table with pure random data:
USE GlobalGuideLineDatabase; GO
-- Drop the old table, if needed DROP TABLE ggl_random; GO
-- Create a table with primary key CREATE TABLE ggl_random ( id INT, rand_integer INT, rand_number numeric(18,9), rand_datetime DATETIME, rand_string VARCHAR(80) ); GO Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What Is the Difference Between Clustered and Non-Clustered Indexes in MS SQL Server?
|
View Answer
|
|
Does the UNIQUE Constraint Create an Index?
|
View Answer
|
|
Is the PRIMARY KEY Column of a Table an Index in MS SQL Server?
|
View Answer
|
|
How To Drop Existing Indexes in MS SQL Server?
|
View Answer
|
|
How To View Existing Indexes on an Given Table using sys.indexes?
|
View Answer
|
|
How To View Existing Indexes on an Given Table using SP_HELP?
|
View Answer
|
|
How To Create an Index on an Existing Table in MS SQL Server?
|
View Answer
|
|
What Are Indexes in MS SQL Server?
|
View Answer
|
|
How to add an address record into AdventureWorksLT?
|
View Answer
|
|
How AdventureWorksLT tables are related?
|
View Answer
|
|
How to attach AdventureWorksLT physical files to the server?
|
View Answer
|
|
How to download and install the scaled-down database AdventureWorksLT?
|
View Answer
|
|
What Samples and Sample Databases Are Provided by Microsoft?
|
View Answer
|
|
How To Skip Remaining Statements in a Loop Block Using CONTINUE Statements?
|
View Answer
|
|
How To Stop a Loop Early with BREAK Statements in MS SQL Server?
|
View Answer
|
|
How To Use "BEGIN ... END" Statement Structures in MS SQL Server?
|
View Answer
|
|
How To Use "IF ... ELSE IF ... ELSE ..." Statement Structures in MS SQL Server?
|
View Answer
|
|
What Are Logical/Boolean Operations in MS SQL Server?
|
View Answer
|
|
How To Test Values Returned by a Subquery with the IN Operator?
|
View Answer
|
|
How To Test Subquery Results with the EXISTS Operator?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All MS SQL Server Interview Questions & Answers - Exam Mode /
Learning Mode
|