Viewing 15 posts - 6,076 through 6,090 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2015 at 1:34 pm
Ed Wagner (4/29/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2015 at 8:22 am
cunningham (4/24/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 24, 2015 at 8:02 am
Viewing 15 posts - 6,076 through 6,090 (of 49,552 total)