Viewing 15 posts - 6,076 through 6,090 (of 49,571 total)
Don't try any of the advertised repair sites/tools.
What are the EXACT errors you get when trying to attach? Please use the T-SQL CREATE DATABASE ... FOR ATTACH, not the GUI...
April 29, 2015 at 1:46 pm
Ed Wagner (4/29/2015)
I figured it would, being 160 miles away
ISS's orbit is only 400km (250 miles). The cargo ship got to orbit, it's just out of control. Think of...
April 29, 2015 at 1:40 pm
Anders Hansen (4/29/2015)
I don't think indexes will be sufficient, I think we are doing something wrong in our application - and need to rethink some of our concepts.
If you...
April 29, 2015 at 1:34 pm
Ed Wagner (4/29/2015)
April 29, 2015 at 1:27 pm
jasona.work (4/29/2015)
Heading out to the movies for a double feature at 4pm, first up, The Avengers (NOT the one based on the British TV series)...
April 29, 2015 at 1:22 pm
You need to investigate what application, on the server listed in the error message, is causing the error. It has nothing to do with the default database for the login,...
April 28, 2015 at 9:51 am
dominic cloud (4/27/2015)
The concerns I have about pursuing this cert, is that it may eliminate me from future potential SQL Developer positions in the future.
Why would it do that?
I have...
April 28, 2015 at 9:17 am
If you could post the DDL of the EditLog table and some sample data (as insert statements), I'm sure someone will be able to rewrite that without the cursor and...
April 28, 2015 at 9:12 am
The truncate only option is ignored on a log file, it's only valid for data file shrink operations. You've just told SQL to shrink your log as small as possible...
April 28, 2015 at 7:09 am
Have a read through of at least chapter 1 of http://www.red-gate.com/community/books/accidental-dba, as well as this series
April 27, 2015 at 8:24 am
Also watch out for the sun. You can get sun burn far easier at high altitudes than low. Take sun cream, use it liberally, even if the day is cold.
April 24, 2015 at 9:10 am
thbaig (4/24/2015)
Will it take more time to reconfigure?
No, it's instant
will database be available to connect during this activity ?
Yes
Do I have to restart sql service after that ?
No
sp_configure 'max...
April 24, 2015 at 9:09 am
Please take a read through Chapter 4: http://www.red-gate.com/community/books/accidental-dba
Yes, you probably should reduce Max Server memory. Leaving only 2GB for the OS on a 32 GB server is tight.
April 24, 2015 at 8:22 am
cunningham (4/24/2015)
April 24, 2015 at 8:16 am
Don't use the Profiler GUI against a production system. It's got horrible overhead and can hang itself as a result. Use a server-side trace instead. ALTER TRACE is all you...
April 24, 2015 at 8:02 am
Viewing 15 posts - 6,076 through 6,090 (of 49,571 total)