| |
| |
| |
|
Page: 1 2 3 4 5 6
Comments:
<0> there are already tools to do that
<1> no direction
<0> bored with this whole convo now
<0> g'night
<1> ya we use enterprise manager right now
<1> but there has to be ways to speed this up
<0> catzai : there are - hire real dbas is the best one
<0> 'agile' is great right up until someone toasts a mission critical database - then people get fired for not having proper controls and processes
<1> well we havent toasted anything yet
<1> and we are keepin costs low
<0> *yet*
<1> and development flying
<1> honestly im a one man army
<0> woo for you
<1> i do the database and development apps webservices
<1> so i need to make this tool for me
<0> seems like you keep chaning your mind
<1> cause we dont have a dba really
<0> you said it was for your dbas
<1> ya which is me
<0> anyway, bored
<0> [23:30:05] <1> they have thousands of databases to maintain
<1> like all i would do is write a script
<0> that'd also be you then?
<1> then loop through all my databases executing on each one
<1> yes thats me
<1> i would write the loopin program in my database management app layer i suppose?
<2> I've deleted all rows from a table but the file size doesn't change in my access db
<0> oixx : corrent
<0> oops
<0> oixx : correct
<0> oixx : deler
<0> damn
<2> so I can't do anything about it?
<0> oixx : deleting data from an ms-access database does not reduce the size
<2> so I have to drop the tables?
<0> oixx : about what? did you actually mean to ask a question about reducing the size of an ms-access database?
<2> heh yes that was exactly what I should've asked
<0> oixx : hit 'f1' and type 'compact' into the search
<2> thanks GuntherX!
<0> oixx : i presume i don't need to tell you to hit 'return' too?
<2> nah thats ok
<0> good
<0> it's avaiable both in vba and from the menu somewhere - different versions have it in different places
<3> or type compact, highlight and press f1
<4> hi using msde. I have a 1 to many realtionship between
<4> http://sql-servers.com/nopaste/?show=514
<4> sc_table_orders.dbo.table_orders TblOrder
<4> INNER JOIN
<4> products_ordered PO
<4> when i run that sproc i shouldnt get any rows back, but i do :(
<4> Items Sold Sold Amount
<4> -----------------------
<4> 8 5.2
<5> no pasting whore
<4> i am honoured
<4> :)
<4> u can use me but dont abuse me :)
<4> my MRS quotes :(
<4> so come on any answers
<4> cos i dont have any products ordered with that @supplier_id
<6> there's a lot of ORs in that WHERE, you sure you know your data?
<6> or are those supposed to be ANDs
<6> oh I see
<6> you need prins around your ORs
<6> http://sql-servers.com/nopaste/?show=515
<4> thanks did u modify it
<4> no ok
<6> yes I did
<4> oh thanks mate
<4> <6> thank you so much mate it works perfect.
<6> no sweat
<4> really appreciate your help
<6> see what I did, right?
<6> you wanted (this or that) and (that or these) and (those or them)
<6> what you wrote was this or (tant and than) or (these and those) or them
<4> yes exactly , i was just modifying the rest
<4> I could neber have figured it out.
<4> and even though i was putting a brave face on , i was so depressed cos of this.
<4> I just cant thank you enough, i have been having this probelm for last 1 year
<4> and i was doing all sorts with everything to make it work
<4> SO THANKS THANKS THANKS . <6> is the man. I wish it was a women though :)
<6> you can't nest cursors in SQL2000 right?
<6> has anyone ever nested a cursors in SQL server?
<7> what does it mean to nest a cursor
<6> you know how to loop, right?
<6> you know what a nested loop is right? a loop within a loop?
<7> yes
<6> can you have a cursor within a cursor?
<6> I thought I tried that once and it didn't work do I put the nested cursor in it's own sproc and called it from the shell cursor
<6> ...and that did work
<6> how does one suspend SQLserver to outside users but allow admin to run scripts, etc.
<6> ?
<6> I used to do this in oracle all the time, never had to in SQLserver till now
<8> yar
<9> Is there a way to create a database from the schema within a .NET 2.0 DataSet, or do I need to convert it into SQL?
<10> can someone please tell me if i did this 3nf normalization properly http://potatorocket.com/3nf.htm thanks
<11> Anyone here familiar with MS SQL 2005?
<11> I need help connecting to a remote SQL 2005 server with the VS.net IDE
<11> Anyone there/
<9> I'm here but doubt I can help
<9> are you asking about a data adapter, or a connection string?
<7> he's asking about the IDE
<7> Siraris which version of the IDE are you using?
<11> VS.net 2003
<7> i don't think you can connect with the 2003 IDE at all
<11> You can
<11> I might have found the problem
<12> hi, which method is more efficient in term of speed when store images(gip, mpg) on db or file system?
<7> generally file system
<12> why people store image on db thought?
<12> any real reson for that?
<13> not any good one
<7> 1) maybe they are real tiny images
<7> 2) mabye they are inexperienced
<7> 3) maybe there is some oddball policy that the data must be contained in the db
<12> is faster for search?
<13> like I said, not any good one
<5> maybe filesystem permissions
<14> Storing the data in the DB puts extra load on the DB server.
<12> ok.. thank so much:)
<15> tenfour you around?
<7> yea
<15> hey got a conceptual Q for you
<15> Consider 3 tables:
<15> Products (ProductId, Title)
<15> Orders (OrderID, ProductId, DateTimeStamp)
<15> PriceSpan (PriceSpanID, ProductID, Price, StartDate, EndDate)
<15> basically, products can have diff prices at diff times
<15> let's say I want to get the total amount of order revenue for today
<15> can I do that all with inner joins?
<7> probably
<15> like select sum(ps.Price) FROM Orders o INNER JOIN PriceSpan ps ON o.ProductId = ps.ProductID WHERE o.DateTimeStamp between ps.StartDate and ps.EndDate
<7> no... 1 sec
<15> does that make sense ? Like, if i have to orders in a give time period, at different prices, will the above query hold?
<15> oki
<15> oh and consider one limitation of this hypothetical that price spans for a given product cannot overlap
<7> select * from Orders o inner join Products p on (o.productID = p.ID) left join PriceSpan ps on ((o.Date between ps.StartDate and ps.EndDate) and ps.ProductID = p.ID) ...
<7> yours might do the same actually i'm tired :P
<7> the only thing here is that you need to make certain that you have 1 and only 1 PriceSpan row for any given date
<7> hehe exactly =)
<15> lemme open yours up in notepad one sec
<7> don't know why you're asking me - seems like you've got it all figured out already :D
<7> @sql formatter
<15> I want to run it by someone I know knows their **** ;)
<7> bah
<15> ahh ok the left join is different
<15> why left join there?
<15> mine does inner join
<7> in the rare case that there's no span, you'll get a null
<7> doesnt matter if the data is good though
Return to
#sql
or
Go to some related
logs:
asus a8v-vm fedora
honey badger +jpg
#windows
#politics
#mirc
#computers
Joe Lilybell
#hardware
#politics
#politics
|
|