RIDDLE
Jun 22, 2007
I bet this is simple, but I need help!
OK CHECK IT
Table A
UserID Date DateID
===== ==== =====
1 2/2/07 100
2 3/12/07 101
3 4/1/07 102
2 5/10/07 103
Table B
DateID UserID
===== =====
2 100
I am user 2.
I need a query that will bring back everything from table A that has my ID (2) and everything from table A that is associated with my ID from table B.
(so I should get back 3 records)
Make sense?
Anyone have an idea?
View 10 Replies
Mar 15, 1999
I have ran sp_spaceused (SQL 6.5 SP4) on my database (4000MB Data, 500 Log) and received the following output for "Reserved" : 4412390 KB. Note that this is more than 4000MB. I checked and made sure my data and log were truly separated...
Just to make sure, I added 2000MB more data space. Sp_spaceused now returned the following for reserved: 3493220 KB.
I am wondering why the allocation dropped, while no user activity was taking place during the process of growing the database....sp_spaceused reported data size first at 2725532, then at 1806314. Any ideas? A bug? Did the database fill up and begin using log pages...?
Any help is GREATLY appreciated...
Thanks!
Dean
View 2 Replies
View Related
