Data load for 2013 is taking too long

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

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

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

gaby_58
Starting Member

33 Posts

Posted - 2013-07-26 : 11:21:57

Could you give an example to use this

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources