> select * from test where chkdate between '20040106' and dateadd(s, -1, '20040107')This might work with smalldatetime values, but it will possibly exclude some datetime values for that date. See my predicates using >= and < rather than BETWEEN.> select * from test where dbo.Dateonly(chkdate) = '2004-01-06'Three problems with this:By using a conversion style that uses only two digits […]
2004-01-28
1 reads
You can restore to an earlier point in time. Let's say you want to restore to 1 January. Restore a full backup from that day or a previous day (use WITH NORECOVERY). Then restore any transaction log backups that may have data up to 1 January (use WITH NORECOVERY on all but the last one). […]
2004-01-23
1 reads
Shoot the database designer! These questions just get worse over time. They mention, "Districts" and then have "DepartmentID". Nice. Furthermore, it is clunky and silly to implement database row level security, even in views for just such a thing. We do this continually through the application level, where it makes more sense and is ten […]
2003-12-09
It could actually be a huge difference in effort if you have dynamic subscriptions set up. BTW: see sp_dropmergearticle in BOL Gary Johnson Microsoft Natural Language Group DBA, Sr. DB Engineer
2003-09-03
Right but you will still have to syncronize all the subscribers, so I don't see much difference in effort.
2003-08-25
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
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...
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