Hello all,A little question regarding SQL Server DB's.I have a two tables containing customers invoices, one for the invoices header (ie: customer #, invoice date,... KEY: invoice # + invoice date) and another for the details of the invoices (ie: each invoice line details KEY: invoice # + line #). I need to periodically remove […]
2004-05-10
1 reads
Initially, I've got to say that I agree with alzdba and the others. For a long time, I have seen people claim that you must qualify object names with explicit owners to get plan reuse to work, but I've never seen anybody who was able to demonstrate the truth of this claim. I almost answered […]
2004-05-10
We are now required to change standard sql account passwords every 45 days.Does anyone know if a script or dts package exists that will change all of the standard sql account passwords to a randomly generated password and collect the new passwords for the DBAs so they can be disseminated to the clients?
2004-05-10
1 reads
Tnx for responding, Victor. You say: You may be getting this error message...There are non-clustered indices. However, it does not happen always, and it happens not always with the same tas/db. Do you know why it happens occasionally seemingly without pattern?
2004-05-10
We have seen the 1899 date often -- when transferring dates to or from MS Access. Access and SQL Server have different "base" or "zero" dates, and this is the result. I suspect many other applications, especially those that use the Jet database engine (things written in Visual Basic, etc.) will show the same phenomenon. […]
2004-05-07
I have to agree with Grasshopper! As a developer, I would not even consider changing the registry or the server properties. At least not without asking first.
2004-05-07
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-05-06
You can try this. There is a more efficient way by doing the same to find the first monday and then, instead of adding 1 day, add 7 days/1 week, until your month changes, but I don't have time now to work this out.Hope it helps,Robert -- Declare and set the required month and year […]
2004-05-06
Ended up figuring it out myself. Changes are in red. WHILE @counter <= @Max_srch_id BEGIN Select @cscd_srch_string = @cscd_srch_string+srch_val+Char(9) from ##srch_val JOIN srch_elmt_assoc on srch_val_id = srea_sche_id Where srch_val_id in (Select srch_val_id from ##Srch_val where srch_val IS NOT Null) AND srea_srch_id = @srch_id IF @cscd_srch_string = '' BREAK Set @cscd_srch_string = LEFT(@cscd_srch_string,LEN(@cscd_srch_string)-1)--Get rid of the […]
2004-05-04
You can also do the following if you don't want to setup Reporting Serivces:1. create the "formatted" report in networkdrive/templates/reportname.xls2. setup a DTS job that will take transfer the file to networkdrive/final/reportname.xls3. Have SQL put all raw data in the "SQL" tab in the final/reportname.xls4. Create a "Final" tab in the final/reportname.xls that does a […]
2004-05-04
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