|
More site info...
dBforums - Database Support Community - www.dbforums.com | Site profile
|
|
Site profile page for http://www.dbforums.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.dbforums.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.dbforums.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
Title:
|
 dBforums - Database Support Community
|
|
Url:
|
http://www.dbforums.com
|
|
Users activity:
|
0 posts per thread |
|
site activity:
|
0 active threads during last week |
|
Domain info for:
|
dbforums.com
|
|
|
|
Posting activity table on dBforums - Database Support Community:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
0
|
0
|
0
|
|
Post:
|
0
|
0
|
0
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for dBforums - Database Support Community (http://www.dbforums.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
dBforums - Database Support Community posting activity graph:
|
|
http://www.dbforums.com Alexa graph:
|
Top authors on dBforums - Database Support Community during last week:
user's latest post:
Minimising the Ribbon
Published (2009-11-06 12:40:00)
I have just started looking at playing around with the ribbon in VBA, and have learned enough that it is a blooming nightmare. I am scaling down my plans. I think that I would be satisfied with minimising the ribbon. To do this I think I either need to: 1) Read the registry to see the current ribbon state and conditionally use Send Keys to minimise the ribbon if it is currently maximised (yuck) 2) Download some tool from MS, read a heck of a...
user's latest post:
Opinion Needed
Published (2009-11-07 20:25:00)
No, you are thinking correctly, but missing the bigger point That Value of doing this, is, as you mentioned, adding valid alues along the way, but the bigger point is to ensure Referential Integrity Just understand, you will not be able to remove any code values if they still exists in Issues...which is not really a big deal
user's latest post:
The Yak Corral, part IX - Page 9...
Published (2009-11-06 16:26:00)
MCrowley: Did you reboot server X? Helpdesk: (quietly) I did the job you sent me to do. MCrowley: Did you reboot server X? Helpdesk: You're goddamn right I did!!
user's latest post:
Absolute SUDOKU Solver - Page 4...
Published (2009-11-06 17:07:00)
11/06/09 "Metro" NY, page 29 HARD --> 1 sec <-- Code: Source (line, sudoku_str) as ( select 1, '020090800' from sysibm.sysdummy1 union all select 2, '600270003' from sysibm.sysdummy1 union all select 3, '000006210' from sysibm.sysdummy1 union all select 4, '000700008' from sysibm.sysdummy1 union all select 5, '702804109' from sysibm.sysdummy1 union all select 6,...
user's latest post:
Where I can get the DUMPS of...
Published (2009-11-07 21:04:00)
Quote: Originally Posted by prashantopel Thanks How to create dummy database for practice in DB2 9.7? From DB2 Command Window, enter: db2 create db db2dummy I'd have suggested to create a db called db2dummy1 if db2 allowed the db name to be more than 8 char.
user's latest post:
The Yak Corral, part IX - Page...
Published (2009-11-07 11:10:00)
Quote: Originally Posted by r937 oh, give over From that Wiki page: Quote: # (British, idiomatic) Usually as an imperative. To tell someone to stop molesting , fooling around, or saying silly things. Or sometimes to stop saying flattering things. Give over with your nonsense, will you! WTF?!
user's latest post:
Problems with this design?
Published (2009-11-07 17:31:00)
Quote: Originally Posted by magicmoose Can anyone help me work out the problems with my approach and a better way to go about attacking the problem? You haven't really told us what your system does or what it is you're trying to model so it's impossible giving you solid examples of why your design won't work. Nevertheless I agree with your friend who said the design is poor. Let's say we're displaying a page on a...
user's latest post:
Can anyone help?
Published (2009-11-05 11:11:00)
resolved thanks for your help
user's latest post:
Tricky Data Format Validation
Published (2009-11-07 23:01:00)
Otherwise one way (although someone can probably shorten this syntax or come up with something better) is something like this in the AfterUpdate event of the field: If not instr([MyFieldName],"v") and not instr([MyFieldName],"0") and not instr([MyFieldName],"1") and not instr([MyFieldName],"2") and not instr([MyFieldName],"3") and not...
|
|
|
Top 10 active forums on dBforums - Database Support Community during last week:
|
|
Top 10 forums on dBforums - Database Support Community:
Microsoft Access
- 26,736 posts
|
Microsoft SQL Server
- 22,660 posts
|
DB2
- 20,434 posts
|
Chit Chat
- 13,762 posts
|
Oracle
- 11,926 posts
|
Database Concepts & Design
- 8,902 posts
|
MySQL
- 8,579 posts
|
Sybase
- 3,956 posts
|
Informix
- 1,978 posts
|
Microsoft Excel
- 1,901 posts
|
|
|
|
|
Latest active threads on dBforums - Database Support Community:
Started 12 hours, 6 minutes ago (2009-11-08 21:45:00)
by diazed129
Thanks, good news, i'll check that.
Started 1 day, 6 hours ago (2009-11-08 02:57:00)
by Derek Asirvadem
Nothing actually.
It depends on how well or how badly your security model is set up. In a good security model, where all users have permissions (roles, or groups in the old paradigm) explicitly granted; and users are explicitly added to the db (to grant access to the db), there is no problem. In fact many security conscious orgs delete guest (user) and public (group).
In a medium ...
Started 14 hours, 4 minutes ago (2009-11-08 19:47:00)
by r937
oh noes!!
i guess it was all my fault, i started IX and it was immediately a spam magnet
Started 14 hours, 59 minutes ago (2009-11-08 18:52:00)
by StarTrekker
(a) Use a rectangle.
( b) Format - Align - Top/Bottom and Format - Align - Left/Right
Started 4 days, 18 hours ago (2009-11-04 15:14:00)
by Teddy
Check help for "GROUP BY" as well as "Aggregate" functions.
The jist of it is you want to "GROUP" your results by resident, and then use the SUM() aggregate function to produce the required result.
Started 17 hours, 50 minutes ago (2009-11-08 16:01:00)
by pkstormy
Quote:
Originally Posted by Karen Day
Hi all,
I want to:
'Check to see if the child record (subform) is a new record,
'if yes then copy some details from parent record to child record (subform).
'Parent Form is [eEmployer1HODetails]
'Child Form (subform) is [usysbeEmployer2SiteDetailsSubform]
Is there a way to check ...
Started 1 day ago (2009-11-08 09:05:00)
by LKBrwn_DBA
You need to add the NOT NULL constraint if that is the requirement, otherwise you can leave as NULL if nulls are permitted.
Started 4 days, 23 hours ago (2009-11-04 10:51:00)
by scooby_at_work
Normally it's pretty reasonable to put a clustered index on your primary key. Assuming that by identity you mean the column is based on a sequence or something, that shouldn't matter one way or the other.
A clustered index just means that the leaves of the index point straight into the data, and that the data is arranged, roughly, around the index. This means that you eliminate one seek when...
|
|
Hot threads for last week on dBforums - Database Support Community:
Started 1 week ago (2009-11-01 21:34:00)
by r937
well, there we go, it's gotta be a bot making those spam posts
Started 6 days, 15 hours ago (2009-11-02 18:45:00)
by stolze
You need the aggregation of strings. XMLAGG or recursive queries are the standard answer for that.
Started 6 days, 12 hours ago (2009-11-02 21:26:00)
by pbaldy
I'm not clear on the rest of it, but this can easily be simplified to:
Code:
If Me.dayname1 = "Sunday" OR Me.dayname1 = "Monday" Then
Me.cmdday1am.Enabled = False
Else
Me.cmdday1am.Enabled = True
End If
If you're saying Me.dayname1 repeats like Me.dayname2, then I'd use a For/Next loop along with that.
Started 6 days, 5 hours ago (2009-11-03 04:10:00)
by pootle flump
Farax x - probably neither.
It sounds like you don't know too much about indexes but have heard that having some "speeds things up". it is also true that having some indexes can "slow things down".
I would either read up on indexing in SQL Server, or run all you queries against your database and then run the Database Tuning Advisor to find out what queries are recommended. The former is the ...
Started 5 days, 19 hours ago (2009-11-03 14:05:00)
by ARWinner
My guess is that your configuration is based on 16GB of memory, but 32 bit can only access 4GB. Anything over that is wasted.
Andy
Started 6 days, 5 hours ago (2009-11-03 04:33:00)
by pootle flump
You could use CROSS APPLY instead of JOIN.
If the relationship between these two tables is 1:1 then you could use a subselect in your SELECT clause too.
Started 6 days, 15 hours ago (2009-11-02 18:06:00)
by koganti
Started 2 days, 3 hours ago (2009-11-07 06:34:00)
by Steve Green
first question.. 4.5 DOS or 4.5 WIN?
Started 3 days, 23 hours ago (2009-11-05 10:21:00)
by sathyaram_s
Not clear! Please give an example or if possible, the same code and query that is not 'working'
What version of DB2 are you using ?
Started 6 days ago (2009-11-03 09:50:00)
by blindman
Try adding PRINT @SQLString before you exec, to aid in debugging.
|
|
Size: 35 bytes
