| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> there's no uninstall function for sql server in your add/remove programs list?
<1> no
<0> not for 2005 either?
<1> yes
<1> I'm removeing that now
<0> see how that works out then
<1> but it didnt "install" 2005
<0> the sql server 2005 installation program is the weakest of all the components of that product
<0> I would try to stay clear of the upgrade function
<0> and do a clean install
<1> now I've uninstalled 2005. but I can still connect to the sql server 2000
<0> then you got a problem
<1> and just leave 2000 alone?
<1> ot isnt that possible?
<0> I doubt that will work
<1> Kal-EL_.hey
<1> you wont belive how much I hate sql server allready... hehe
<2> hehe
<2> i wish i had your sql server problem and in return give you mine :-)
<1> u sure?
<2> i just discovered to have damanged the bios chip on my server machine when trying to flash the bios :-(
<2> yes, i am sure :p
<1> lol
<3> hi
<3> this is so weird, i can access http://myPcName/virtual but not 127.0.0.1/virtual or localhost/virtual or physicalIP/virtual. anyone knows why? this is sql server web services end point
<4> hey
<5> hey
<5> hey hey
<4> =)
<5> Loco_ losty
<4> (mssql05) was trying to do this: select UserId, (Details is null) AS IsDetailed from dbo.[User]
<4> however is null doesn't appear to wan to work that way
<4> any ideas for another approach?
<3> case when details is null 0 else 1 end [isDetailed]
<3> i think , but i dunno really know what u mean
<4> (case when Details is null then 0 else 1 end) AS IsDetailed
<4> seems to work fine, thanks
<5> cibe
<3> anyone has experience with sql2005 writing xml ?
<3> this is great, i can output xml in sp, expose as soap, then it will be read as system.xml.xmlnode in .net
<6> i haev a bligschum database and wanto add rows
<1> Using sql2k5 express: If I create the db locally during development, how to I publish the db to the remote server when finished?
<6> dont know
<1> first of all, is it possible? When I create a new website in vs 2005 by default it created a database file in my app_data folder.
<7> anyone know how to check if a query exists using vba?
<8> MSSQL Server - I am replacing a view with a stored procedure for imporved db performance
<8> I have my order table linked to the products table and then at the moment I have calculations in the query forming fields such as Gross Price, Gross Profit, net profit etc
<8> The problem with the old query is that to include gross profit in another calculation I have to include the whole calculation rather than just including grossprice etc
<8> I am considering UDF
<9> i have a category/listing structure that needs to have unlimited category depth. i often need to know stuff about the child and child's children of a category (primarily counts of listings). does anyone have any insight into differences between a category lookup table that is just cat_id and parent_id, and one that is cat_id, parent_id _and_ grandparent_id
<10> Quant: you there?
<11> mmunky connect by. you only need 1 category table. with a parent column. parents dont care about who their children are, children care about their parent. if you think that way you can reverse up the line
<10> mmunky: sounds like a leaf node tree
<10> there are several implementations
<12> The fun part is querying a parent/child system
<10> yep, that's when it gets exciting
<12> CTEs simplify it a great deal. You could just do most of the work at the client-side, tho
<13> Halo, ever had the joy of dealing with tables with recursive joins?
<12> Not in production.
<13> I worked at a company that had that kind of thing set up for production. The developers did it because it was easier for them to store the data that way. They couldn't understand why generating reports off that data totally killed the DB server.
<13> I was doing the reporting.
<12> Sounds like DB2 supports CTEs now
<13> what's CTE?
<12> Common Table Expressions, they're like miniviews but they have some extra functionality like recursive querying
<10> sql 2k5 only though
<12> Of course, they're ANSI SQL2003
<12> I think
<10> ansi 99
<12> Yeah, actually they are 99
<10> but hey, 2k5 is better than 2k7
<7> isnt 2k5 supposed to have temporal databases built into the schema. I attended a conference hosted by the sql concil in '02
<7> and one of the lectures was about temporal dbs'
<14> wtf is a temporal db?
<10> have you heard of startrek?
<7> where you can query the data, not only by a key value, but also by a date
<14> ...
<10> its a db that exists outside of the current space time continum
<7> for eg. if you had a cust db that was constantly being updated you "could":
<14> wow. I can't query by date already? Crap, I better go fix all of my code.
<7> select cust.* from tbl_cust where cust.id = x and date = now()
<7> Drk`Angel: unless you store a new record each time the data is changes
<7> -s+d
<14> I do, actually. That's what audit tables are all about.
<14> They're really freaking useful.
<7> ahh
<7> well anyway...
<7> I was just looking through my notes
<7> the guys name was Brian Ling or somethine
<7> crap... (cold fingers) -e +g
<14> It always amazes my users when I can actually answer the question "Who changed this value, and when?"
<7> thats impressive.
<12> Sounds like you're referring to something like Oracle's flashback.
<7> dunno. never used oracle
<7> the lecture was entire theory
<7> so that the temporal aspect of the db could be queried using simple code.
<7> +sql
<7> like in the example above
<7> back in '02 it was a real head exploder. after that conference I decided not to work as a dbadmin
<14> Was using audit tables in 99 while working at a major comoddity trading company.
<14> You had to know who changed what when, otherwise legal would rip your head off.
<7> as the guys who were attending, and were dbadmins, were soo mindblowingly intelegent about dbs, dbtheory and dm management I felt thick as ****.
<14> Experience does that. I ***uem they were, and you weren't. Silly to decide not to do something just because of that.
<7> Drk`Angel: it would make a lot of sense
<12> There's a product called Gnosis for SQL Server which sounds like it does temporal DB ****
<7> Drk`Angel: yeah, also getting "real" experience is hard.
<7> so - was at this job and they hired a new oracle admin (to replace the one that left)
<7> first thing he does is seek me out and say "I am replacing the servers. how do I install oracle". thats when I realised that experience also doesnt count for much in some places
<7> anyway - thought i would just drop that in. this guy was chatting that it was going to be part of the specifications of sql2k5
<14> Would be cool if it was automatic.
<14> Writing the triggers is annoying. :)
<7> I think that was the point
<14> But, its hardly mindblowingly new. :)
<7> was to me
<11> 'temporal'?
<14> Scroll back, and enjoy the read. :)
<11> thank God oracle has been including asll that crap in the db for the last 12 years
<7> rjarett: asll - is that like audit tables, or "temporal"?
<14> Its the same thing, really. Don't let the terminology confuse you.
<7> ahh
<7> the thing about the lecture (as I remember it) was that becuase it was mostly theory, (and about the specifics of how you would access the data) the actual schema of how the data would be stored wasnt covered
<11> temporal isnt a term i would use to describe auditing
<7> I remember thinking at the time, "how would you store that in tables?"
<11> since it ha sa much different definition to most of the free world
<7> really.
<7> temporal == time
<7> therefore a database which can access data given a specific time
<11> and how does that relate to auditing or transactions?
<11> yeah thats a stupid use of the word temporal
<11> doesnt matter if thats a word the professor used
<11> professors also use the word tuple
<15> dfworking, can I bother you for a sec? (in pm?)
<14> heh.
<16> yes
<7> yeah I suppose
<7> I was just making sure that it wasnt a word that my fragile little mind had replaced what he was actually chatting about
<11> who here has actually ever heard someone in the REAL db world (not a college db professor) use the word tuple?
<14> MattyT: Autoinc transaction #, operation code (i,u,d), and a copy of the row that results for the given transaction.
<7> HOLY ****! I actually found the lecture slides!!
<13> rjarett: yeah, but they were academians with their heads stuffed up their ***es :)
<13> rjarett: management types who were trying to sound impressive
<11> cubert phd in computer sci means they arent in the real world
<11> ahh management..
<13> rjarett: it wasn't a PhD, it was a PhB =)
<7> Drk`Angel: yeah - I suppose that would kinda make sense if I understood you right
<12> rjarett: I have, tuples are a pending feature of C# 3.0
<14> I can't decide which is more annoying - management or users.
<14> They both ****. ;)
<7> lusers
Return to
#sql
or
Go to some related
logs:
#nhl
#beginner
#gamedev
#linux-noob
#nhl
#ubuntu
openbsd+Envy24
#beginner
#debian
BACHTOLD BOTHER MOWER
|
|