Viewing 15 posts - 4,741 through 4,755 (of 7,164 total)
Is there something that I need to do to ensure that the Disable and Rebuild are complete and taken into account?
The commands are synchronous so they will not return until...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 11:48 am
I had some of this scenario too with inheriting DBs created in 2000 but now on 2005, and I enabled CHECKSUM. It's a DB engine feature that has no logical...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 11:44 am
SKYBVI (3/28/2012)
opc.three (3/28/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 11:30 am
Eugene Elutin (3/28/2012)
So, unless you forced to do so or have no good idea about other options, I would not advise using GUID's for PK for your tables.
Now that, you...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 10:46 am
Sourav-657741 (3/27/2012)
Have you looked at upgrading? Compressed backups may help you.[Unfortunately, the sql server is SQL 2005...so no compressed bkp possible..]
I understand, that is why I asked if you were...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 10:02 am
Eugene Elutin (3/28/2012)
You still never answered the question. You said earlier you would do a round trip for purposes of caching a bunch of GUIDs:
Where I've said that?
Even, with...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 9:57 am
jokesbox_mail (3/28/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 9:47 am
Oh no, it does not work that way. The executable will always run in the context of the operating from which you call it, not on which you call it....
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 9:26 am
The public Role, by default, does not have permission to insert or update tables or views. Did someone change the default permissions, granting things specifically to public?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 9:18 am
Try this:
DBCC SHRINKDATABASE(database_name, NOTRUNCATE);
Then try shrinking it again.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 9:15 am
What command exactly are you using to shrink it. Any error message?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 28, 2012 at 9:11 am
You're welcome.
Have you looked at upgrading? Compressed backups may help you.
More work, but you could also try spreading you index rebuilds out over time so your log backups do...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 27, 2012 at 10:32 pm
Eugene Elutin (3/27/2012)
...
Why would you want to cache ranges of keys when using Guids? Makes no sense at all. The main reason for using guids if allocating keys in the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 27, 2012 at 9:16 pm
Look for open transactions in your database.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 27, 2012 at 8:08 pm
When you say you're "in the instance for SQLproduction" do you mean you have an open window in SSMS? Or are you using some other means of backing up the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 27, 2012 at 6:26 pm
Viewing 15 posts - 4,741 through 4,755 (of 7,164 total)