Viewing 15 posts - 121 through 135 (of 374 total)
mohammed moinudheen (6/1/2012)
Nakul Vachhrajani (5/31/2012)
Nice & easy for a Friday. Thank-you, and have a great week-end, everyone!+1 🙂
+1 🙂
June 1, 2012 at 5:39 am
Poor wording.. TempDB selected and got it wrong :angry:
51% selected tempDB as answer... I was also sure that we can't take 'tempDB' backup.
Still learn something new today...
May 29, 2012 at 3:36 am
Lynn Pettis - you are right.
I have just given one option to change the query.
It will calculate and store filtered records in temp table so during delete, it will directly...
May 29, 2012 at 12:46 am
Try below option:
create table #TempData
(GlobalRecodID INT)
insert into #TempData (GlobalRecodID)
select GR.GlobalRecodID FROM GlobalRecords AS GR
LEFT JOIN localRecord AS LR
ON GR.GlobalRecodID = LR.GlobalRecordID
WHERE DATEDIFF(day, GR.ModificationDate, getdate()) > 365 and LR.GlobalRecordID IS NULL...
May 28, 2012 at 10:37 pm
Nice article. Thanks for sharing
We have created SSIS package to transfer logins from one server to other when we move the database. We have to do coding as well to...
May 24, 2012 at 10:52 am
Viewing 15 posts - 121 through 135 (of 374 total)