Viewing 15 posts - 13,876 through 13,890 (of 49,552 total)
Any relevant messages in the error log?
March 15, 2013 at 1:01 pm
GilaMonster (3/15/2013)
If you want to balance the CPU load of the instances, the windows resource manager's a better choice
Firstly you can do more granular limits, second, because if the other...
March 15, 2013 at 12:54 pm
Are those two instances (the ones failing) SQL Express by any chance?
btw, generally configuring the cores as you tried is not usually a good idea. Those are fairly advanced settings...
March 15, 2013 at 12:43 pm
Set up a profiler trace or extended events session. If it's running at predicatable times, should be easy to catch
March 15, 2013 at 10:37 am
balasach82 (3/15/2013)
March 15, 2013 at 10:31 am
syscacheobjects is deprecated, will be removed in a future version, is included only for backward compatibility with SQL 2000 and should not be used. The replacement is the combination of...
March 15, 2013 at 4:42 am
clintonG (3/14/2013)
March 15, 2013 at 3:59 am
Restore somewhere that has 30 GB free, shrink the DB, then move it or backup/restore again.
March 15, 2013 at 3:54 am
There are a number of things that cause the plan not to be cached at all. If you want the estimated plan, easiest way is just to use the 'Display...
March 14, 2013 at 10:42 am
sql-lover (3/14/2013)
It was a test machine and have a fresh backup, so I restored from it, but it surprised me that the restart damaged the database.
The restart didn't damage the...
March 14, 2013 at 9:31 am
winmansoft (3/14/2013)
What if i use ENCRYPTBYPASSPHRASE to encrypt selected colums? How anyone with admin permission can decrypt it without knowing passphrase?
If the passphrase is passed to a stored procedure, trivially....
March 14, 2013 at 9:10 am
bugg (3/14/2013)
That is why I was looking into creating a new table with the addtional column then moving the data etc and finally doing a table rename
You can do that,...
March 14, 2013 at 9:08 am
General rule - format is a display problem, should be done in the presentation layer of the application, not the database server.
March 14, 2013 at 9:07 am
winmansoft (3/14/2013)
If a user who has access to the database with admin permission then he can take backup and restore database anywhere.
Correct
So can i protect the database from being stolen?
By...
March 14, 2013 at 8:21 am
Viewing 15 posts - 13,876 through 13,890 (of 49,552 total)