In the Windows search facility, type "*.BKP; *.BAK; *.TRN" (without the inverted commas) in the field All or part of the file name, then fill in the dates under When...

JWA

Buffer cache hit ratio is a percentage, whereas cache hit ratio is a simple ratio.  So a cache hit ratio of 63 means, as you say, 63 cache hits per...

John

Multiple filegroups are good for a VLDB, since you can back up individual filegroups rather than the whole database, making your backup strategy more flexible.  You will only see a...

Product oriented?  Sounds like management speak to me, and I don't think it translates into anything that you, as a DBA, would want to touch with the proverbial barge pole. ...

Jeff

Yes, so long as he only wants to do this on the identity column.  His original post was a little more general than that.  We await the explanation...

John

David

Make sure that the columns in the tables in your subscription database have exactly the same data types as those in your publication database.  It sounds as if you're trying...

Greg

I think that if you have migrated the databases of existing applications, then you are bound by the design of each application.  For example, some applications have an application server...

Bhushan

The point of clustering is if a resource (for example SQL Server) fails on one node, it stops and continues running on another node.  Therefore you shouldn't find yourself in...

Simon

According to Books Online, sp_changedbowner "Changes the owner of the current database".  So the answer to your question is no if you want to use that stored procedure.  However, have...

You could probably get an ugly solution using dynamic SQL and the information_schema.columns view, but I wouldn't recommend it.  One of the many reasons I wouldn't is that if you...

Walter

Not tested, but can't be far off... You just need to dispense with the SELECT. Also, I've changed your old-style join syntax to the ANSI standard.

update tbl1

 set col1 =...

Given that you only want to do this in one database, this should be simpler:

use YourDB

select name as Object, object_name(uid) as Owner from sysobjects

John

Presumably, since you have tempdb (data and log) on its own drive, your application makes heavy use of tempdb.  Now you need to find out how much of that activity...

Curtis

Yes - just to clarify, the MS docs are right.  You don't need AWE for 4GB and under.  But you do need the /3GB switch for your 2.5GB.  I suppose...

Dinakar

Surely it will work if you restore your database at the subscriber, set up the publication and then start synchronising?  If identity insert is on, then the values in the...