I just finished reading todays article "Unique Identifier: Usage and Limitations". I have never used GUID's, I have always used identity integers. These have been causing a problem for me lately. Mostly to do with web security, there are many times that I need to maintain state in my web apps using either hidden form […]
2004-06-23
Thanks for the update. I'm not using the e-mail code yet. I'm trying to build up a stats database that get DB sizes, disk size, last backup (log and transaction), recovery models and so on that will allow me to pull out the critical info and send it in one e-mail. A lot of the […]
2004-06-23
1 reads
And for my second question have you got an idee?'cos i can't do this :SET @strReq = 'SELECT DLZ_EMAIL.EMAIL_LIB, @Nb = COUNT(*) FROM DLZ_EMAIL WHERE DLZ_EMAIL.DATE_DEB <= GETDATE()'@Nb is an OUTPUT parameter and i need to have the column EMAIL_LIB in my request.Thx again
2004-06-22
I know that SQL Server 2000 Standard is limited to 2GB RAM on Windows 2000 Server Standard, but I have two questions:1) If two instances of SQL Server 2000 Standard are running on Windows 2000 Server Standard Edition with 4GB RAM, can each instance use up to 2GB?2) Does the answer to the first question change […]
2004-06-17
1 reads
I have that question in to the SQL SA group. They may have changed something and not told us...I'll keep everyone posted.
2004-06-17
2004-06-09
I was able to serve at his second inaugaration while in the military. I was proud to serve in the military under him. It hasn't been until I grew up a little more to finally realize what an incredible man he was who had clear ideas of right and wrong and was able to work […]
2004-06-08
Hi there,Googled the internet, found the question posed several times, no answer however! I have this integer value always as format 20040522, yyyymmdd. I wish to convert this to datetime. When looking in BOL under CAST and CONVERT I see that this is an implicit conversion. I translate this as: put a recognizable integer into […]
2004-06-08
3 reads
I'm a bit braindead today and this has been burning my already overtaxed brain cells. Environment is SQL 2000 sp3a and W2k. I've got two tables listing items. Table1 ItemID ItemName 1 AAA 2 BBB 3 CCC 4 DDD Table2 WidgetID WidgetName WidgetType 10 ZZZ A 20 YYY A 30 XXX B 40 WWW A […]
2004-06-08
In a way I think of this as a constraint, like any other in a db. You have a basevalue, but for it to be correct in regard to the viewer, it must be adjusted according to a parameter that only the viewer knows... To ensure (from the db level) that you always display the […]
2004-06-08
2 reads
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