Forum Replies Created
Viewing 15 posts - 6,046 through 6,060 (of 7,501 total)
-
RE: sp_detach_db works, re-attaching it doesn''''t!
in that case also copy the path to the ldf file from explorer.
maybe the best way is to rightclick and hold and drag to the run window
(start\run) clear the...
-
RE: Single/Double quote in [A-MSG] token
with SET @Msg = 'Error: [A-ERR]' + CHAR(10) + 'Severity: [A-SEV]' + CHAR(10) + 'Date: [STRTDT]' + CHAR(10) + 'Time: [STRTTM]' + CHAR(10) + 'Database: [A-DBN]' + CHAR(10) + 'Message:
-
RE: sp_detach_db works, re-attaching it doesn''''t!
Check your cluster service settings for sqlserver !
I suspect you didn't create a dependency for your sqlserver instance with the R-drive ! Therefor sqlserver cannot reach the drive !
-
RE: Performance changed with OS update... now more blocking...
I forgot to mention you only defrag the indexes.
Defrag only does index-level-optimisation.
Check BOL.
After every upgrade, sp, restore, attatch_db it is advisable
to perform full dbmaintenance.
dbcc dbreindex (or configure a maintenanceplan)
sp_updatestats
dbcc updateusage(0)...
-
RE: Performance changed with OS update... now more blocking...
just a shot in the dark ...
- did you format the volumes with blocksize to max in stead of default (4k) ?
- maybe your clustering index isn't the right one...
-
RE: Replication Fails after removing BUILTIN\Administrators
... Also if there is a way for me to see how the login is linked through a group I would be interested to know how. ...
EXEC master..xp_logininfo @acctname =...
-
RE: Copy database - data only?
if your volume is not that high, you may even use the tablediff.exe
you can find it at
"C:\Program Files\Microsoft SQL Server\90\COM\tablediff.exe"
October 25, 2006 at 1:49 am
-
RE: Job Step Duration
I've just copy/pasted the script and added the last inner-join-part.
It returned rows. (with sql2000 and with sql2005)
This is the full script, copy/paste it and run. It should give results if...
-
RE: constraint: enforce unique key on subset of rows
just to add to the other replies :
you could use triggers to enforce this check constraint.
Although its better to avoid ....
CREATE TRIGGER mytrigger _IU ON mytable
FOR insert, update
AS
BEGIN
if exists...
-
RE: Job Step Duration
or maybe even replace the complete where clause with
inner join
( select job_id, max(run_date) as Max_run_date
from msdb.dbo.sysjobhistory
group by job_id ) jhMAX
on jh.job_id = jhMAX.job_id
and jh.run_date = jhMAX.Max_run_date
-
RE: Job Step Duration
there is also a litle pitfall with ...
and jh.run_date = convert(int,
-
RE: New SQL Server 2005 instance, really slow compared to 2000
- how long is it taking the system to allocate 200GB ?
- did you try to copy a 200Gb file to that logical disk ? And how long did that...
-
RE: New SQL Server 2005 instance, really slow compared to 2000
so this may be I/O related.
keep in mind that files are being initialized (=nulled out) at allocation time (unless you specify not to).
What filesize are you trying to allocate ?
-
RE: Job Step Duration
how about :
declare
@daysago int
set
@daysago = 7
Select
j.name as
Viewing 15 posts - 6,046 through 6,060 (of 7,501 total)