Smallmoney is 4 bytes and has a maximum of 214,748.3647 To hold the equivalent in decimal would be 9 bytes decimal(10,4)However if you are only storing to 2 decimal places then smallmoney would still be 4 bytes and a maximum of 214,748.3647 but numeric(9,2) is 5 bytes with a maximum of 9,999,999.99It depends if you […]
2004-04-15
Can you also implement a feature of Closing a discussion? Anyone of following can mark a discussion as closed. 1. member who started discussion 2. Moderator 3. Admin 4. Any other Superuser levels that you might have in Forum. While closing, the "closer" has to put up remarks about the question & the accepted answer […]
2004-01-02
SELECT yourcolumns FROM yourtable WHERE yourdatecolumn BETWEEN GETDATE()-365 AND GETDATE() If you must take care for leap years you should use DATEADD. Works also with negative numbers as interval. Frank http://www.insidesql.de http://www.familienzirkus.de
2003-12-15
1 reads
quote: Running .NET IDE is quite memory intensive. We are running it on our 'old' 256MB laptops and it runs fine, but not really fast. If you have the chance to upgrade your RAM, you certainly should do so so in addition to buying NET I should opt for another 512MB RAM? Btw, I'm not […]
2003-08-27
1 reads
Ok, I got past that problem, now I have a new one. I have used the wizard and 'successfully' created the DISTRIBUTOR (on machine B). Now I go to Machine A and try to setup Machine A as Publisher. I go thru the entire wizard, pick the table to replicate (transactional) and at the end […]
2003-08-25
2 reads
Long time ago I rebuilt indexes on largest table with filfactor 80%. Now I run optimizing every Sunday morning with 20% free space checked. But after optimizing the .mdf file grows too big, leave 100% free space. That's why I don't understand. Thanks! Robert
2003-07-30
Just a thought but you may find that the growth is because you asked for it. The optimize component of the job may be adding 10% free to the .dbf hence its size increase. If you created the job via a std maint plan using EM then this is the default setting, worth a look.
2003-07-29
I got an error trying this. I 3 column table with hr, Source, and Description as the column headings: hr 0x800401F3 Source ODSOLE Extended Procedure Description Invalid class string Thanks, ThomBeaux
2003-07-21
A fair comment Steve. Thinking about way to protect your apps, the new .net module and handler managed via the http api is a fantastic way of quickly implementing an application firewall to prefiler any incoming/outgoing request from your ap. Previously this was a pain, restricted to c++ programming with isapi. The app firewall is […]
2003-07-02
1 reads
all fixed. The test had expired 🙂 Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2003-07-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