Viewing 15 posts - 106 through 120 (of 219 total)
Yes you are right .A bit strange (to us that why the index that is created second is used)..but there might be some logic we dont know .
main thing is...
June 25, 2009 at 3:54 am
can you share the command you are using and other relevant information please.
June 25, 2009 at 2:22 am
If you are not abel to connect remotely you must be getting the errors .
an you share it please .
make sure you have SQL Browser enabled and TCP/IP , named...
June 25, 2009 at 1:54 am
You are correct Paul ..its indeed WAL (So silly of me).
In the haste we miss the reality 🙂
Regards
June 24, 2009 at 9:50 pm
1) for how long will you do that ..its going to be a pain .You can create a SP using cursors to do that .Remember you cant do kill @spid_name...
June 24, 2009 at 9:41 pm
I have never tried this on 2005 from 2008 .
Unfortunately i cannot try it now but let me see if that is possible ...
Yes she does say that its possible...
June 24, 2009 at 9:20 pm
As i said my friend : this is only supported in SQL Server 2008.
All your instances should be on SQL server 2008 .
Regards
June 24, 2009 at 9:16 pm
create a new database and import the tables form the old database .
June 24, 2009 at 5:52 am
Over here you know the HOBT id , object id and index name .but you do not know the rowid or page id etc .So you know that update is...
June 24, 2009 at 5:48 am
Yes it does(I tested it way back) .This is because everyhing is logged in the log file first (as per copy on write principle) and the database is in full...
June 24, 2009 at 5:34 am
For 2000
----------
1) create this SP attached in all the databases you want
2) execute this :sp_msforeachdb "exec ?.dbo.Rebuild_reorg_index"
so there is no need to find and then rebuild/reorg .this SP...
June 24, 2009 at 1:00 am
This is possible in SQL Server 2008 .
We call it Central Management Server.All you need to do is to choose a SQL Server 2008 server and register other servers to...
June 23, 2009 at 10:00 pm
Blocking is the way to synchronizing data access .
Just imagine what will happen if someone pulls the chair on which you are sitting .
As pradeep said ,killing is not going...
June 23, 2009 at 9:31 pm
Well if you restore the full backup and then the t-log with no recovery the database is suppose to show you the status of 'restoring' 🙂
if you are configuring Mirroring...
June 23, 2009 at 9:04 pm
add this : select rtrim(cast(GETDATE() as varchar(12)))
June 23, 2009 at 5:25 am
Viewing 15 posts - 106 through 120 (of 219 total)