Viewing 15 posts - 901 through 915 (of 1,079 total)
No, changing the autogrowth will result in your db growing by 1 gb everytime it goes over its size, althought the space needed might be 1mb? You'll reserver space for...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2010 at 7:34 am
two virtual machines provided by ESX
We had a similar issue on ESX, with a shared virtual disk, Server picked it up, but SQL refused.
Hope someone can clear this issue up?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 16, 2010 at 1:01 am
try using
initial catalog
, instead of
database
:
Data Source=servername;Initial Catalog=dbname;
or try: http://www.connectionstrings.com
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 15, 2010 at 7:03 am
Anything below 300 is a cause for concern for PLE.
What is the BCHR on the node when failover occurs? less than 99% ?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 15, 2010 at 6:59 am
Best practice suggests you install your engine, agent etc on a different drive, your MDF's on its own drive and your LDF's on its own drive.
never install your SQL Engine...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 15, 2010 at 6:23 am
To make it all nice and pretty, yet functional, build a website, with different connection strings to each server, which tie in with DMV queries, and have them post the...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 15, 2010 at 6:20 am
Similar issues:
http://www.sqlservercentral.com/Forums/Topic672649-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic715463-146-1.aspx
I believe you will get the answers from those posts.
Good luck!
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 10, 2010 at 1:55 am
it is not online
I think it's quite self explaining - get the database Online before trying a Backup through SSMS.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 7, 2010 at 11:57 pm
Sounds like you are trying to administer a pre- SQL 7.0 database and its objects.
Did you upgrade from 6.5 to 7, or 7 to 2000?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:54 pm
Personally, I want to say yes, but it depends on where you want to go with SQL development, maybe into BI? then, YES.
Also depends on the needs of te current...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:42 pm
Thrust me the scheme user is correct and not the problem so don’t suggest any changes to that
I'll "trust" you rather and not suggest any changes.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:38 pm
Any extra knowledge is always a bonus, and learning .NET will increase your chances of understanding how applications use SQL as a back-end.
I have seen many job requirements for SQL...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:33 pm
This is a free dashboard tool from Idera that I could recommend:
http://www.idera.com/Products/Free-Tools/SQL-check/
no licensing involved, but it is limited, try it.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:10 pm
Noted, my apologies, didnt read the question thoroughly.
🙂
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 11:02 pm
Please explain why you would recommend a nested select on the same table, looking for NOT IN on the same column, instead of selecting it and excluding the undesired data?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2010 at 10:48 pm
Viewing 15 posts - 901 through 915 (of 1,079 total)