Viewing 15 posts - 376 through 390 (of 956 total)
Email or SMS. I use email, which comes directly to my Palm Treo, or the other DBA's Blackberry's. I have so far been able to avoid the Blackberry...
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:23 am
For me, CompareIt has been the best tool for doing visual comparisons of files.
http://www.grigsoft.com/wincmp3.htm
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:01 am
I prefer Subversion to the built in stuff, but if you want to look at using the a compatible product, Team Foundation Server has worked really good in my past...
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 6:59 am
Did the actual machine name change as a part of moving it onto the domain?
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 6:54 am
Voicent has a XML gateway for doing this type of thing that I was playing with at one point in the past. Since it is XML based you 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 6:52 am
SSIS would be my preferred method of doing this. You can create a quick import task in SSMS by right clicking on the on the Database to be refreshed,...
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 6:46 am
GilaMonster (5/12/2009)
RAID array? If so, what level?
Pretty sure they mean one hard drive for Data file, and one Hard Drive for Log file. The worst possible scenario for performance...
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 12, 2009 at 12:16 pm
RPSql (5/12/2009)
The mdf file from that database sits on one drive(contains one disk) and ldf file sits on another drive(contains one disk). This is not SAN storage but local storage.
This...
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 12, 2009 at 12:14 pm
Dean Jones (5/12/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 12, 2009 at 11:31 am
If you can't sell the jump straight to 2008 to management, at least purchase the 2008 license which will allow you to run 2005 if they approve that. Then...
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 12, 2009 at 11:22 am
What trial are you downloading and from what URL?
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 12, 2009 at 11:21 am
Out of curiousity, how many disks are in the RAID Array that this database sits on and what RAID level is the array configured for?
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 12, 2009 at 10:59 am
Steve Jones - Editor (5/12/2009)
chkdsk isn't thorough enough. You need low level diagnostics, as well as double checking every software version in the I/O system (drivers, firmware,etc)
+1
Chkdsk is a tool...
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 12, 2009 at 10:55 am
RPSql (5/12/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 12, 2009 at 10:35 am
klnsuddu (5/12/2009)
for a product like Share point where the Service account has to be the database owner for the Share point databases
Here do we need to have sql server...
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 12, 2009 at 10:00 am
Viewing 15 posts - 376 through 390 (of 956 total)