Don't think that "DATEFIRST" should matter in this case. As the @@DATEFIRST value is changed, only the weekday numbers are changed as well. It doesn’t affect the number to name mapping. SET DATEFIRST 7 -- default, SundaySELECT DATEPART(WEEKDAY, getdate()),DATENAME(WEEKDAY, getdate())The result will be 4, Wednesday SET DATEFIRST 1 -- MondaySELECT DATEPART(WEEKDAY, getdate()),DATENAME(WEEKDAY, getdate())The result will be […]
2004-06-02
I have a small issue, but I cannot find a way out of it - any assistance with this would be great.We are implenting indexed views for a 'data warehouse' type arrangement. The problem is that many of our existing views incorporate self-joins which prevent me from creating indexes on them. These views have been […]
2004-03-10
212 reads
How can bulk data insert be done from xml files into SQL server 2000 tables through DTS ?
2004-01-27
3 reads
I usually do all my data modeling in Erwin. It then creates a script that I modify to create the tables and triggers. Once I have run the script I then create my basic stored procedures for inserting, updating, deleting using a vb app I created many years ago. All the SPs that have specific […]
2004-01-22
Maybe this would work: sp_grantlogin [@loginame =] 'login' sp_grantlogin sp_revokelogin Note that the SQL security account procedures and the NT security account procedures differ. If you got a snapshot of all of the logins/role membership/permissions for the NT accounts, and their NT account name has not changed, then you could scan through them and use […]
2003-12-01
Ok I am a proponent (big word for the day) ok stored procedure grouping. There biggest advantage are to break out code so that individual execution plans can be stored for situation many folks do if begin code here end else begin alternate code here end but to call that limited revisioning is not correct. […]
2003-11-17
Have a look at the following KB article, Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface
2003-08-27
I thought as much and am in the process of building this functionality into my sprocs that loop execute. Thanks
2003-07-29
1 reads
If you don't want to apply a new snapshot, you will have to manually insert all the missing recors in your subscribers, and update all the different records, too. Since the subscription, expired, the distribution db didn't save all the transactions to apply, so you have your db not on sync. The easiest way it […]
2003-07-28
I hat eto say it, but the causes of poor performance are probably due to your use of cursors. If you post an example of common usage, perhaps we can suggest ways to replace the cursors with set-based solutions. Also, if you are running cursors within a transaction, your transaction log will balloon most likely. […]
2003-07-23
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