Viewing 15 posts - 841 through 855 (of 1,219 total)
When you shrink, you should always specify a target size, and you should specify that size so that there is space to rebuild your largest tables after the shrink, because...
August 17, 2013 at 6:40 am
20 million rows? It will take SSMS quite some time to render all those rows, particularly if you have results set to grid!
August 17, 2013 at 6:33 am
First verify that you have the same bitness of both SQL Server. That is, SQL Server and the provider should either both be 64-bit or both be 32-bit.
Next verify that...
August 17, 2013 at 6:29 am
If you got the error that master.mdf was already present, that sounds like you have an abandoned instllation with the same instance name as you are trying to use now....
August 17, 2013 at 6:26 am
What is the service account for the instance you are trying to run BACKUP from? Make sure that it is a domain account. LocalSystem or somesuch is not likely to...
August 17, 2013 at 6:24 am
What you mean with "Is there any other possible way??" Isn't my solution satisfactory to you?
August 17, 2013 at 6:22 am
You said that there were no entries in the errorlog. Does this mean that it was empty?
Make sure that you are not looking in the errorlog for the default instance....
August 17, 2013 at 4:01 am
Boris Pazin (8/17/2013)
Biggest table has about 76 millions of rows. So, I guess deleting and re-creating 76M of rows could be harmful for all queries which use that table?
As Gail...
August 17, 2013 at 3:45 am
poratips (8/16/2013)
August 17, 2013 at 3:34 am
I was able to run OPENROWSET with a non-priv user, but I don't have access to the IBMDA400 provider, and this may be a restriction related to that provider. Is...
August 17, 2013 at 3:31 am
ncurran217 (8/16/2013)
I am still needing to research exactly what COALESCE does/means. Thanks for the responses and trying to figure this out though!
coalesce(a, b, c, ...) is a shortcut for
CASE...
August 17, 2013 at 3:20 am
Yes, you would be better off starting a new thread in the SQL 2012 General forum.
In the mean time, check the SQL Server errorlog for errors that may explain...
August 16, 2013 at 4:29 pm
I would guess the problem lies here:
LEFT OUTER JOIN sales_view ON Records.Listcode = sales_view.listcode AND Records.JulianDate = sales_view.JulianDate
...
August 16, 2013 at 4:27 pm
If you get this message, this indicates that you are running out of space on the disk where tempdb is located. How much free space do you have on that...
August 16, 2013 at 4:22 pm
Viewing 15 posts - 841 through 855 (of 1,219 total)