Viewing 15 posts - 451 through 465 (of 965 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...
February 20, 2009 at 6:29 am
Alvin Ramard (2/19/2009)
Well,...
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...
February 19, 2009 at 9:02 pm
Bruce W Cassidy (2/19/2009)
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...
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...
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...
February 17, 2009 at 8:52 pm
Jack Kennedy (2/13/2009)
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...
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...
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...
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...
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...
February 10, 2009 at 12:21 pm
No. You can validate this by looking at the information in sys.dm_db_index_physical_stats().
February 10, 2009 at 11:47 am
Viewing 15 posts - 451 through 465 (of 965 total)