I can confirm that the CHECKSUM (and or CHECKSUM_BINARY) approach works a treat. It possible to create a generic sp that will work for any table with suitable pkeys defined, allowing you to check for updates and apply logic only where necessary.Obviously you don't need to use CHECKSUM when looking for inserts or deletes.Using triggers […]
2004-02-10
1 reads
I want to be able to count for each country, the number of sales reports during the last 13 weeks. Row headers = Country Code, column headers 13,12,11 to represent current week, prior week etc.
2004-01-26
731 reads
Does anyone knows how to execute a exe file from SqlServer ( Stored Procedure / Dts / Job ) ?ThanksHM
2004-01-20
3 reads
Thanks for your responses. There is a standard query that will return all rows to the customers view. We will be allowing the customer to create their own filters on the fly. So, they will select a field from a list of fields and then pick an operator such as in, between, less than etc. […]
2003-08-21
Just by curiosity, In what cases would I need to move tempdb files. Isn't the TEMDB recreated once sql server is restarted. Pay Respect to People on your way up. For you will meet the same People on your way down.
2003-08-21
2 reads
_WA.. are not indexes. They are internally kept and updated column statistics that SQL Server can use to assist a query if it finds no index on which to base the query plan for the SQL statement.
2003-08-18
1 reads
2003-07-15
3 reads
If sorting on name for instance, I do the following SELECT ID, Name FROM NameType ORDER BY (CASE WHEN Name IS NULL THEN 1 ELSE 0 END) ASC, Name ASC
2003-07-14
This is a poor question not because of the question itself, but because of the distractors. While it is correct that you JUST need a login to SQL server, you are added to master because of the default value of @defdb in sp_addlogin. At least that's the way I was thinking at the time... Am […]
2003-07-14
No, it's not SPIDA. Had it been, he wouldn't have been able to log on as SA from another system, which he was able to do. Spida changes the password and attacks the sa account when no password is set. K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-07-11
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