Viewing 15 posts - 451 through 465 (of 956 total)
I learned long ago, never do anything you can't recover from. If a dev says we need to drop a table, my answer is no way. How about...
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]
February 20, 2009 at 6:29 am
Alvin Ramard (2/19/2009)
Well,...
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]
February 19, 2009 at 9:03 pm
You know if we really think about it, people are really just applying Occams Razor:
Of two equivalent theories or explanations, all other things being equal, the simplest one is 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]
February 19, 2009 at 9:02 pm
Bruce W Cassidy (2/19/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]
February 19, 2009 at 8:57 pm
Hem,
You are going to have to be a lot more specific about your problem for us to help you with it. What is the code that you are using...
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]
February 19, 2009 at 8:06 am
If you are on SQL Server 2005, and you are using .NET 2.0 or newer, use a SqlDependency and Enable Service Broker in your database to watch for changes 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]
February 18, 2009 at 8:33 pm
There are a number of ways to go about this, but this is the wrong forum to be asking this specific question in. By looking at your code, I...
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]
February 17, 2009 at 8:52 pm
Jack Kennedy (2/13/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]
February 13, 2009 at 6:48 am
PaulB (2/12/2009)
All changes applied to production MUST be scripted not done on a GUI therefore and since 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]
February 13, 2009 at 6:44 am
Read the following document by Kimberly Tripp that covers monitoring CLR.
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/SQLCLRforDBAs.doc
Basically, you look at the normal .NET performance counter objects, and then pick the sqlservr instance for the ones of...
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]
February 13, 2009 at 6:41 am
MANU (2/11/2009)
You will get it from sys.dm_db_partition_statsselect * from sys.dm_db_partition_stats
where object_id='Enter the ID here'
and Index_id='Enter the ID here'
MJ
Look at the output of sp_helptext 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]
February 11, 2009 at 2:36 pm
This is a very common problem in mirrored environments. Keep in mind, that you have to do this for any new logins that you add to the principle 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]
February 11, 2009 at 9:34 am
PM me offline and I'll send you the code from an upcoming article I put in for publication here that does it in SQLCLR. Unless I can get permission...
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]
February 10, 2009 at 12:21 pm
What is the error that they get when they connect?
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]
February 10, 2009 at 12:06 pm
No. You can validate this by looking at the information in sys.dm_db_index_physical_stats().
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]
February 10, 2009 at 11:47 am
Viewing 15 posts - 451 through 465 (of 956 total)