Grrr. Thanks for pointing out my ritual idiocy. I have a lot of fun here at work, occasionally letting out a "What a maroon!" or other self-deprecating slur. I love the looks I get!I don't know how long I've spent looking at the Dos Help screen, and my mind just kept blanking over the […]
2005-05-11
2005-05-11
Forgive my ignorance, but why do you store such redundant data like a running balance in your db at all? The usual approach is either use something like this:IF OBJECT_ID('lfdsum_t') IS NOT NULL DROP TABLE lfdsum_t GO CREATE TABLE lfdsum_t (col1 int) INSERT INTO lfdsum_t values (1); INSERT INTO lfdsum_t values (2); INSERT INTO lfdsum_t […]
2005-04-07
Nice one, Remi! Very sweet....can't bum that at all.As an aside on functions. I've tested this, and found little to no performance degradation in putting code like this into functions, specifically when they are "deterministic" and in the same database as the tables in the query. With the addition on "With SCHEMABINDING", your function is […]
2005-04-06
I am looking to set the default database locations on our sql servers to make it easier to roll out new databases through scripts.Do you need to stop and start the SQLSERVERSERVICE for this change to take effect?Thanks in advance Carl
2005-01-17
Just in case anyone still cares about this problem, it turned out to be a conflict with the SCSI cards and the scanners (believe it or not). Once a certain volume of data had passed through the SCSI card it just seemed to close itself down until the PC was reset...We had the latest SCSI […]
2005-01-04
Thank you for replying...The conversion of the dates into the appropriate format does work, as I am using VBScript to rearrange the dates and they are accepted into the second table as datetime.I would love to see some sample code, however, as most of the rest of this thing is all up in the air...if […]
2004-09-28
Newbie here!!I am currently evaluating SSRS for our company use as opposed to CR, and am very impressd by what I have seen thus far, and will be demonstrating it to the IT folks sometime in the next week or so.I have also had the same problems using SProcs as datasets, and was interested in […]
2004-09-12
2 reads
The packages I need to update with new connection information already exist in an SQL Server. Currently, I open the package in designer and modify the connections. I would like to script the changes instead of opening each package.
2004-09-07
Thanks Andy an Don,Andy could you please tell me some code samples or post a link for achieving this using ADO or ADO.NET. Thanks and Regards, Hatim Ali.
2004-08-01
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