Viewing 15 posts - 4,216 through 4,230 (of 7,496 total)
even better, BOL now contains more info on DBCC statements then ever !
No yet for all, but for the most of them you'll ever use.
December 28, 2008 at 8:40 am
no doubt about it, you should fix the db in sql2000 !
btw: what service pack are you on (sql2K) ?
Keep a copy of the backup of the corrupted database !...
December 28, 2008 at 8:35 am
it may not only be the left join, but I guess most of the waste time will be the correlated join predicate !
apparently this can be an indexed item, but...
December 24, 2008 at 6:09 am
Well, the instance didn't failover, but it dumped like hell.
SQLErrorlog file stating ".... a lock it does not own .... " which IMO is a symptom for the lock manager...
December 24, 2008 at 4:32 am
bodhilove (12/23/2008)
December 24, 2008 at 4:15 am
What service pack are you on ?
(should be at least SP1, better SP2, best SP3 😉 )
Select @@version
SQL Server 2005 Books Online (November 2008) topic "Monitoring Database Mirroring "...
December 23, 2008 at 2:42 am
Hey.... I've been referenced to :w00t: Thanks Barry 😉
The code is pointed to in the "How to use this article" section !
the word solutions has the hyperlink !....
December 23, 2008 at 2:23 am
Best practice is to keep the scope of a trigger as small as possible.
All executed by a trigger is in the same transaction as the original query (insert/update/delete) !
Meaning,...
December 23, 2008 at 2:15 am
Can you run this and post the results ?
/*
* DB Mirroring : followup
*
*/
/* show mirrored databases and their mirror-state */
Select db_name(database_id) as dbName
, *
from sys.database_mirroring
Where mirroring_guid is...
December 22, 2008 at 1:35 am
Since partitioning is an advanced topic, it is highly recommendable to read BOL and to read the white paper on partitioning.
(make sure you have the latest version of BOL !)
-SQL2005...
December 22, 2008 at 12:21 am
can you also insert/update/delete on the pricipal instance ?
December 22, 2008 at 12:16 am
SQL2005 : http://www.microsoft.com/Sqlserver/2005/en/us/Compare-Features.aspx
SQL2008: http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx
December 22, 2008 at 12:08 am
Maybe.
However, when using windows groups to grant security, we don't have control about the actual account being used.
So finding the "exceptions" would be a trial and error thing :crazy:
and would...
December 20, 2008 at 3:05 am
Well, this is sql2005
xp_cmdshell is off by default.
You would be better off just exporting the result using SQLCMD or DBMail if you want to email it.
Check out BOL
e.g
sqlcmd -s yourserver\instance...
December 20, 2008 at 3:02 am
Grant Fritchey (12/19/2008)
DO NOT, I repeat, DO NOT, GO PUTTIN' FRUIT INTO MY GOL DURNED BEER.
Belgians... They get a couple of things right (double, triple, & saison (very right))...
December 19, 2008 at 7:59 am
Viewing 15 posts - 4,216 through 4,230 (of 7,496 total)