> 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
Are you sending encrypted data or looking to encrypt the data stream? SSL will encrypt the stream, but the data will be text in the server. If you encrypt on the client, then you don't need to owrry about the stream.
2004-01-27
Wondering what the best practice or best approach would be to solving a problem. We are currently migrating from IIS to Sun Java Web Server. This is being done to address various security flaws in IIS. So the plan is to move all the applications and database to a development / test environment and run […]
2004-01-27
1 reads
i put the table name in place of TableName in your code; but I'm getting an empty set when I run the code. how else do i need to modify the code?
2004-01-27
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
weissa, Can you answer jxflagg Last question? I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now: Suppose you have TableChild (ChildID int, ParentID int , Property varchar (100)) You Could Do: Declare @strAllChilds varchar(4000) Declare @MasterRecordID int SET @MasterRecordID = X SELECT […]
2003-12-24
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
Try executing a DBCC CHECKDB on the database. This grabs some resources. From the looks of it you may be able to execute a DBCC CHECKFILEGROUP <syntax?>
2003-11-18
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