Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Data load for 2013 is taking too long

Author  Topic 

gaby_58
Starting Member

33 Posts

Posted - 2013-07-25 : 17:09:42
We have 2009 thru 2013 data in the database, all the data 2009 thru 2012 comes out quick except 2013 data, it doesn't come out and hangs forever, what could be the problem and how to resolve this

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-26 : 02:28:39
is table partitioned? do you've an index on date field?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

gaby_58
Starting Member

33 Posts

Posted - 2013-07-26 : 11:09:40
Not sure, how do I find it and what will this help? Thanks
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-07-26 : 11:18:01
have a look at sys.indexes for index info and
to get partitioned tables use logic like


select distinct t.name
from sys.partitions p
inner join sys.tables t
on p.object_id = t.object_id
where p.partition_number <> 1


------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

gaby_58
Starting Member

33 Posts

Posted - 2013-07-26 : 11:21:57
Could you give an example to use this
Go to Top of Page

Paul J. Brooks

7 Posts

Posted - 2013-11-26 : 05:40:13
I m a stranger with this topic.i wanna discus on this topic.if any one is interested then plz reply me.i m waiting.Thanks for sharing this information.
unspammed
Go to Top of Page
   

- Advertisement -