Viewing 15 posts - 361 through 375 (of 956 total)
Make sure you have instant file initialization enable:
http://www.sqlskills.com/blogs/paul/2008/08/11/HowToTellIfYouHaveInstantInitializationEnabled.aspx
Then create a method of monitoring your database file available space so that you get an alert or email to let you know...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 18, 2009 at 8:16 am
2 Tim 3:16 (5/18/2009)
I believe (could be wrong) at least 2-3gig (based on boot.ini) is set aside for the os in the kernel.
The VAS split is specific to...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 18, 2009 at 7:40 am
Florian Reischl (5/15/2009)
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 18, 2009 at 7:24 am
This is telling you that the mail server is rejecting your request to send email. Check firewall settings between the two servers, and then check to see if your...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 18, 2009 at 7:18 am
I personally use the code on Ola Hallengren's blog for newer servers or when I am consulting. It is very well written and extremely flexible.
http://blog.ola.hallengren.com/
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 18, 2009 at 7:07 am
It looks like your XML from the web.config didn't make it, possibly because you didn't tag it inside of blocks correctly.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 18, 2009 at 7:04 am
over linked servers it should still work you just have to use ... for the DMV's so with a link named Development, and the AdventureWorks Database it would be Development.AdventureWorks.sys.objects....
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 10:59 pm
You could try doing it by hand using a query similar to the following:
select o.name as TableName,
i.name as IndexName,
(
SELECT c.name + ', '
FROM sys.index_columns ic
JOIN sys.columns c ON...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 7:25 pm
Your SQL Service Account would need to have the necessary rights in the OS to allow it to run this. It isn't based on the user calling xp_cmdshell, its...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 11:43 am
It is the same direction that Gail was sending you. I've had to get myself out of a jamb in the past where I removed BuiltIn\Admins before putting my...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 9:21 am
The benefit is that you don't have a passive node just sitting there waiting for a failure. The downside is you don't have a passive node just sitting there...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 7:54 am
Florian Reischl (5/13/2009)
Usually your application connects with windows credentials of the current connected user to connect to database.
If you want to use windows authentication but connect with another user you...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 7:52 am
Redgate to date has been really good at supporting their products, so I'd give that a shot if you are having a particular problem with something. It is in...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 7:48 am
If you are a local Administrator in Windows on the SQL Server server, you can start the service in single user mode with the -m parameter and any local administrator...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 7:39 am
That would probably depend on your phone brand and type. I am sure your local wireless dealer could probably tell you how to configure it properly if it could...
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
May 13, 2009 at 7:34 am
Viewing 15 posts - 361 through 375 (of 956 total)