One more note: Commentary: People, process secure the enterprise By Forrester Research Special to CNET News.com July 31, 2003, 4:30 AM PT Michael Rasmussen, Director, Forrester Research Last week, Microsoft and Cisco Systems announced two major vulnerabilities. Organizations need an action plan to respond to vulnerabilities and exposures, and should not rely on products alone […]
2003-07-31
1 reads
For those of you who saw my previous posting, which showed that the CAST method beat the DATEDIFF method, sorry, I deleted the post once I realized that the CAST to INT on smalldatetime data was producing incorrect results. Whe I ran this: select top 10 DATEADD(day , DATEDIFF(day, 0, dtmLastEdited), 0) as "DateDiff Date" […]
2003-07-31
Well I'll probably get flamed a little here, but here goes. And some of this I continue to blame MS for making SQL Server too easy to use. I am moving a number of servers from outlying offices to a consolidated server here. So far 3 out of 4 have had just plain rookie developer […]
2003-07-31
Are you including adovbs.inc? If not, you need to replace the ad-prefix Constants with the numbers they represent.
2003-07-30
2 reads
2003-07-28
2003-07-28
1 reads
Thnaks for the info, Is there is Any problem if I have choosen Append teh transaction Option In my backup?. One more thing before restoring on new machine Should I have to create the User databases or restore will create by itself?. Can you Pl. also describe How to use sp_change_users_login. Thanks for your help.
2003-07-25
2003-07-25
declare @tbla table(keyid int , field1 char(1) ,field2 char(1) ,field3 char(1),field4 char(1),field5 char(1) ) insert into @tbla values (1,'a','b','c','d','e') declare @tblnum table (number int) insert into @tblnum values (1) insert into @tblnum values (2) insert into @tblnum values (3) insert into @tblnum values (4) insert into @tblnum values (5) select keyid, case number when 1 […]
2003-07-25
Useful topic to cover but isn't the final solution over-complex? Couldn't you just use an inequality of PaymentID's on a self-join as follows..? DELETE Payment WHERE PaymentID IN (SELECT P1.PaymentID FROM Payment P1 INNER JOIN Payment P2 ON P1.CustomerNumber = p2.CustomerNumber AND p1.PostedDatetime = p2.PostedDatetime AND p1.PaymentAmt = p2.PaymentAmt AND p1.PaymentID > p2.PaymentID) Mark
2003-07-25
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers