TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Santhosh Subramaniam
NA
226
108.3k
Parallel SQL Query Execution..?
Mar 1 2014 5:56 AM
Hi frnds,
Create Table #City(CityName varchar(40))
insert into #City
select top 5 City from State where Name='TamilNadu' order by City
insert into #City
select top 5 City from State where Name='Kerala' order by City
Select Top 5 * from #City order by City
Frnds this is sample Query ,
in my SQL Server database around 5laks records is there , when i get all data from table and fetch top 5 records means it will take long time to execute
how can i execute these 2 queries in same time .
Reply
Answers (
1
)
my store procedure is not working correctly
Confusion in SQL Server Stored Procedure Inner Join