Viewing 15 posts - 1,756 through 1,770 (of 2,462 total)
khushbu (5/4/2010)
(for simplicity here only few rows are taken, while my table has billions of rows)
give a close look on indexes used for your query
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 3:36 am
khushbu (5/4/2010)
col1 col2
1 1
1...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 3:35 am
Additionally you need to take care about indexes in the concerned tables
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 2:25 am
ColdCoffee (5/3/2010)
1. INSERT...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 2:24 am
Did you notice ? this post has 9 views and still NO reply , just becoz of incomplete information.
Atleast post desired result for sample data.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 2:15 am
sqlwars (5/4/2010)
On checking backup history: i have the following backups taken:
Missing LSN backup 2:30...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 1:50 am
Also the business hours matters mean are you building index in peak hours or off-peak hours, on production always go for off peak hours.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 1:25 am
Below link contains explanation as well as workaround for your problem
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 1:18 am
bodhilove (5/3/2010)
Bhuvnesh's suggestion seemed to of worked.Using a temp table rather than the table variable speeds the query by upwards of 9mins
it only take 9 seconds now.
thanks all!
thats great...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 12:09 am
Michael Meierruth (5/3/2010)
How about: LETSTRYAGAIN.Do you think this will get them on board?
we can hope so
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 12:06 am
Adam Haines (5/3/2010)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 4, 2010 at 12:03 am
I dont understand why we have very few girls in database field ? , i think ROLLBACK doesnt work for them 😀
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 11:50 pm
Paul White NZ (5/3/2010)
Bhuvnesh (5/3/2010)
yes this is partitioned tableI know - I was wondering why it is a partitioned *heap* rather than a clustered table. That's quite unusual.
i...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 7:23 am
pradeepmsbi (5/2/2010)
how to improve the query performance in sql server 2005
you can find good article here http://www.sqlservercentral.com/search/?q=improve+query&t=a
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 6:29 am
Paul White NZ (5/3/2010)
Bhuvnesh (4/30/2010)
HI i need better approach for the below one.i know this is very straight forward query but if somebody can help me here . greatly appreciated.
Is...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
May 3, 2010 at 6:21 am
Viewing 15 posts - 1,756 through 1,770 (of 2,462 total)