Viewing 15 posts - 31 through 45 (of 367 total)
I am also cleaning out the zero quantity items which make up 90% of the inventory table. I have about 12 - 14 million rows a day and end up with 140K...
April 19, 2017 at 7:22 am
April 19, 2017 at 7:16 am
April 19, 2017 at 6:30 am
ok, I will let you know when it finishes.
April 18, 2017 at 8:13 pm
Gail,
It ran for 10 minutes with no result. Let me restore the database again, I ran the split for a few minutes today and then canceled it....
April 18, 2017 at 2:01 pm
Can anyone help me? Are my steps correct? Every time I run the split it never finishes. The next used didn't give the file a partition number so I am...
April 18, 2017 at 1:19 pm
I am pretty sure this is what I need to do below, I am deleting zero items in the table to get it down from 2.982 billion to a doable...
April 11, 2017 at 10:07 am
http://stackoverflow.com/questions/37239582/switch-partition-in-sql-server/37241198#37241198
I really just want to scream...
April 10, 2017 at 11:22 am
I have been reading more and found this article;
http://stackoverflow.com/questions/37239582/switch-partition-in-sql-server/37241198#37241198
I really just want to scream and throw my laptop...lol
April 9, 2017 at 6:30 pm
http://www.sqlservergeeks.com/repair-the-database-using-dbcc-checkdb/
you will need to run a repair rebuild command. see article
April 9, 2017 at 5:46 pm
You are right, my bad, it was bnd_id, not no
I thought it was a...
April 9, 2017 at 5:05 pm
April 8, 2017 at 7:08 pm
I have an SQL 2012 Data drive of 220...
April 8, 2017 at 5:57 pm
With the help of SQLRNNR I was able to create steps to remove partitions. Below are the steps I took and it worked. I hope this helps someone like me...
April 2, 2017 at 5:05 pm
I've already started the restore but the two files that I moved had 0 in the num_row column and the other files that I hadn't moved had large numbers that...
April 1, 2017 at 6:02 pm
Viewing 15 posts - 31 through 45 (of 367 total)