RE: Differential backup question
quote: In summary, do differential backups take the changes since the last FULL backup or FULL OR DIFFERENTIAL?? Last Full Backup.
2003-07-24
RAID
RE: publishing execution of sp
I know that is why I used sp_addscriptexec. This is almost the same as re applying the snapshot, but much easier. I just add the new version of the sp, and it applies to all the subscribers. I also realized, that I can skip the error, re creating the directory and the fyle name. But […]
2003-07-01
RE: Best practice when to use an index
Something like that. I like to have the joined element clustered, it definitely helps join performance. Also, when you are using a where clause it is helpful to include that column in the index that is being used, which in this case would be the primary clustered index/key. Michael R. Schmidt Developer
2003-07-01
RE: Best practice when to use an index
My identity column is ALWAYS my primary key, otherwise there would be no point in having it. It tends to be my clustered index but won't necessarily be so. If I am understanding you correctly then you are suggesting that I place both my primary key and the unique VARCHAR(20) field into a clustered index. […]
2003-07-01
RE: Best practice when to use an index
quote: So, why use an index anyway, that's what I was originally asking. In my book, indexes are for data integrity or performance. Since performance is unlikely to be an issue here, the question is whether you need to use an index for data integrity I guess. Am I right in thinking that a UNIQUE […]
2003-06-25
2003-06-17
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers