Viewing 15 posts - 511 through 525 (of 1,155 total)
How many instances do you have on the server ?
Do you have any Named Instances installed ?
...
September 15, 2011 at 5:17 pm
LS won't work..
Thank You,
Best Regards,
SQLBuddy
September 15, 2011 at 5:13 pm
crazy4sql (9/14/2011)
I think this becomes bit difficult if we have 100 instances or more 🙂 ..
Thank...
September 14, 2011 at 10:52 pm
crazy4sql (9/14/2011)
Raghavender (9/13/2011)
Hi All,How to find out Installed SQL Server Instances and their names on a server using T-SQL or any other way ?
The easiest way for me is, go...
September 14, 2011 at 10:39 pm
Generally Speaking SSAS has 3 main memory settings
Memory\LowMemoryLimit : Defaults to 65%
Memory\TotalMemoryLimit: Defaults to 80%
Preallocate : Use Process: Private Bytes counter for the for the msmdsrv instance. It's peak...
September 14, 2011 at 10:36 pm
Check if this helps..
http://www.sqlservercentral.com/scripts/Administration/71614/
Thank You,
Best Regards,
SQLBuddy
September 14, 2011 at 7:06 pm
Follow Gails Advice and also check this article for optimizing Tempdb
http://technet.microsoft.com/en-us/library/cc966545.aspx
Thank You,
Best Regards,
SQLBuddy
September 14, 2011 at 7:01 pm
Did you setup a Linked Server between the 2 servers successfully ?
This error generally means SQL Server instance is not available and is stopped .
Please post more details and in...
September 14, 2011 at 6:57 pm
Please reply to Glen questions and also please post as many details as possible..
...
September 14, 2011 at 6:50 pm
Leo posted a very nice script. Sometimes if the Jobs have DTS packages , SSIS packages or Maintenance plans then it becomes difficult to associate the jobs with the database...
September 14, 2011 at 6:47 pm
Follow these experts advice. The Backup Drive must be owned by\available to the new active node for the backup to succeed. Please post the error message.
...
September 14, 2011 at 6:33 pm
What tool are you using to connect to the SQL Server by using that alias ?
If you are using SSMS 2008\R2, since its a 32-bit application, it works only with...
September 14, 2011 at 6:29 pm
Forgot to mention two of the important new features ..
1. POWERSHELL
2. Multi Server Dashboards
Thank You,
Best Regards,
SQLBuddy
September 14, 2011 at 6:27 pm
Server level objects are not log shipped. Only the Primary Db changes will be shipped.
Try to test it with a test db on a test server and by bringing back...
September 14, 2011 at 6:18 pm
It's not a good practice to leave the default value for Maximum memory.
I think the term Maximum Memory has to be understood clearly. There's a lot of ambiguity.
...
September 14, 2011 at 6:15 pm
Viewing 15 posts - 511 through 525 (of 1,155 total)