sometimes less code is more readable, use the else-structure.

declare @bd datetime

declare @fd datetime

select @bd = '1976-2-2'

select @fd = '2004-2-1'

select case

when month(@bd) > month(@fd)

then datediff(year, @bd, @fd)-1

when month(@bd) =...

If you have restored on the clone machine, remember to update the jobs so they wil not be launched on the "dna"-server ;). (update msdb.dbo.sysjobs set originating_server = *** where...

I've had sqlmail running on my clustern, knowing it is not supported and knowing it needs a server-reboot evert +- 6 weeks. According to the users-responsable, this was no problem.......

probably someone can 🙂

this option is to be managed using cluster administrator - sqlserveragent resource - properties - advanced. Check its settings.

If your source-db is in simple-recovery-mode (yes, some vendors still recommend this for their apps), you can forget log-shipping and the only option left is backup/restore if you want the...

Check your sqlagent-settings in the cluster-administrator. On the "advanced"-tab you'll find the options.

"It actually is like this: Begin Tran, Insert into Table1 (on connection1), Select max() from table1 (on connection1) then insert into table2 (on connection2)." Because your Insert is still uncommitted,...

try saving a trace to table and then

look for eventclass = 17 or (eventclass = 12 and textdata like '%isolation%')

If your select max() is in a separate connection it cannot see the uncommitted stuff from your connection1-transaction.

Run profiler to see what connection-isolation-level is being used ! (my guess would...

hope you performed the sp_statistics after the restore/load in sql2000. Do you perform the "SELECT max ()" using an index ?

the ultimate wet dream would be getting this one sub-second 😉 I'd recomment on matching the indexes (clustered ? ) and trying to get them in ram (more than 2gb)....

the ultimate wet dream would be getting this one sub-second 😉 I'd recomment on matching the indexes (clustered ? ) and trying to get them in ram (more than 2gb)....

Pass conference (november) is very good. Almost no sales-blabla. Very good technical presentations and THE place to meet your peers and exchange ideas and experiances. Hope to go back this...

use this way to find out what exactly the problem is. Outerjoins in where clauses have troubled me more then once. Using the JOIN-sintax it solved my problems most of...