| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> anyone know how to allow a sql query run for an undefined amount of time without timing out
<1> That's dependant on the client.
<0> all im trying to do is enable the service broker and it seems the query is timing out, so i want to set the timeout to a large value,
<0> using sql mngmt tool
<0> 2005
<1> Probably in options somewhere
<0> ....
<0> ive checked all of em and can find it
<0> also shouldnt i be able to put something in the SQL query that allows it to run without timeout?
<1> no
<1> It's not enforced at the server
<1> The server will happily run a SQL statement indefinitely
<0> hmm
<0> so its the client thats being picky
<0> cant find if theres an option there, do you use that tool?
<1> Options > Query Execution > SQL Server, or Options > Designers > Table or Database Designers
<2> Anyone know why a stored proc using FOR XML returns XML_{GUID} as opposed to the XML?
<2> n/m.
<3> to p*** arguments to a dll u use cmd line arguments?
<1> DLLs don't execute on their own
<3> yah thats right
<3> how do i p*** the message title who to send it to to my dll?
<3> i open visual studio 2005 and pick new project cl*** library
<3> i dont get how dlls receive parameters
<4> use TBT
<5> you call them
<3> how do u p*** parameters in
<4> use TBT
<4> its the best
<3> wot does tbt stand for
<4> The Best Thing(TM), its the best!!!!
<3> omg
<4> its the best
<6> FFFFFFFFFFFFFFFUUUUUUUUUUUUUUUUUUUUUUUUUUUUCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCKKKKKKKKKKKKKKKKKKKKKK CRM
<5> cute
<4> crm ****s, tbt is good
<3> halo four
<3> how do u p*** messagebody and title into my send mail dll?
<4> hi five
<4> i would try it with tbt maybe
<3> **** u
<3> wot the **** is tbt
<4> the best thing
<3> omg
<5> you fall for it every time
<4> haha
<4> let me help you: The Best Thing
<4> got it?
<7> wtf is wrong with u guys?
<8> ShrikeX, what crm package are you dealing with?
<9> are UDF's particularly innefficient when streamed as part of a SELECT? More so than subselects, for example.
<9> or is it pretty much the same depending on code quality.
<10> depends on quality and what the UDF is doing
<3> can mssql call an exe?
<9> Cojones: so no general statements against their use?
<5> catzai yes
<3> can mssql call a webservice?
<10> catzai have you tried to read the documentation?
<11> im sure there are worms that could make it do it
<3> so to call an exe i just use xp_cmdshell
<3> ?
<5> do it however you want
<4> catzai: i'd have a look at tbt
<4> haha Jarett_
<12> is there a way to get like the first ten records of a table and then get the next ten, but if anyone added something to the table, it will still grab the right next ten?
<11> are you adding timestamps to your rows?
<12> yea
<4> http://thedailywtf.com/forums/65091/ShowPost.aspx
<13> the new one is much better :)
<14> hey guys how do you concat while updating, in PGSQL?
<15> PGSQL?
<5> || Vova7
<5> is the concat operator
<14> thanks Darken| i love u
<15> update this=(select cast(col1 as varchar)+cast(col2 as varchar)+... from another where {filetring or mainjoin}) from maintable where {filtering}
<5> not in public please
<5> guest1 that's a horrible pile of ****
<15> darken you're a horrible pile of ****, but I don't say anything about it
<15> whats your excuse?
<5> want banned?
<5> next time you are kicked you know a ban is going to follow
<5> this is your 3rd strike
<3> ok i have 10000 databases should i make a job for each one or should i make an exe that logs into each one?
<3> which is gonna be more overhead?
<12> anyone here doing paging with mssql?
<5> not enough information
<5> jipped email paging?
<15> depends if you plan to run them in parallel or not, and if you do you might run into connection pool issues
<5> "pool issues"
<3> guest1 is that to me?
<5> quiet
<15> yes
<3> they run in parallel
<3> like all the databases are online
<15> whats the max connections
<12> naw, paging like displaying a certain number of results on a web page
<5> it is your choice catzai, you have to maintain it
<3> 40 i think
<12> and then being able to go forward and back, pages
<5> which way is best for you to maintain it
<3> prolly the exe that logs into each one is best
<5> jipped just impliment ranges
<3> i just need to send emails incase something happens
<12> ranges?
<5> X-Y
<5> or an offset and maximum amount of results to return
<5> X - (X+Y)
<12> well currently I think im doing the latter
<15> well if you have 40 max connections and you run 50 threads at once 10 will wait and may time out
<12> and the problem is when people add stuff to the table
<3> so if i do 10000 jobs its gonna run into connection pollin probs?
<12> i get back different results
<15> see the problem?
<3> yes
<5> jipped how often does the table change
<3> ok makes sense
<12> very often
<5> what is in the table and what client software are you using
<12> so if they are on my page and see the first ten results and someone adds something when that user goes to get page 2 the results will have dupes
<3> so make an exe that runs them sequentially
<11> catzai, why do you need 10000 database? on top of that if you are so stupid, how on earth do you manage to even have a job?
<12> they are comments and im using asp.net technology for client
<3> becuz i have a application that manages all my databases
<3> and its more stable
<3> cuz sometimes we **** up a clients database and we dont want to lose all our buisness if one client ****s up
<15> well, what I had to do once was see which threads took longer than other and praralled the one that flew and sequenced the ones that didn't so the fast ones wouldn't wait for the slow ones
<11> catzai, you really need to quit your job and give it to someone who knows what they are doing
<3> wotever jareet
<5> Jarett_ try helping a little
<3> u dont kno the business im in
<5> you can't tell everybody to quit
<15> but sequenced is gonna take you awhile, just opening/closing connection sometimes takes longer than the actual process
<11> sure i can, you nazi fascist
<11> how abotu you help more people instead of just being the polite police
<11> ;)
<5> i help more people than you talk to in a day
<5> on top of the ones you insult at your job
<11> help get them off for $20 in the parking lot maybe
<5> whatever your sister wants..
<5> $20 makes her happy
<3> i dont understand wot is wrong with having 10 thousand databases
<11> do you have 10000 customers?
<3> yes
<5> he's just jealous catzai
<5> :/
<15> I'm not going to ask
<11> and you are the best your company could come up with?
<3> yup
<5> Jarett_ stop being jealous
<11> ohh im very jealous
<13> its prolly some 'webhosting' stuff ;P
Return to
#sql
or
Go to some related
logs:
#linuxhelp
error 0x080070241
#worldcup
#politics
#beginner
#gentoo
#worldcup
#unixhelp
#sql
#politics
|
|