had it 'SQL SErver orphaned transactios' and not connections my bad...[:$]
well i read through that link and it unfortunatly didn't tell me anything new... i was hoping there's some easy way i can kill it from the client. i...
thanx mohammed. will read it and report back. how come these kb articles have such low page rank? if i search on google for orphaned connections this...
hey all! i'd appreciate if any of the experts here take a look at this thread on sqlTeam. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=98747...
take a look here and you might find something you'll like...
subquery doesn't mean forced order evaluation. USE AdventureWorks SELECT * FROM ( SELECT * FROM Person.Address WHERE AddressID / 0 = 1 ) AS t1...
hopefully in no way [:)] hmm... maybe it should be [:)]
hi all! if anyone has time and will i'd like you to try a little SSMS Add-in i wrote:...
in sql 2k5 these 3 will almost always produce the same query plan. Not exists is probably favored because it stops processing after the condition is...
well one option is to go MCDBA and then upgrade it to MCITP (don't know how many esamx that is) or go dirrectly to MCITP (3 exams total)...
that's what you want us to think [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br...
hey satya, is there a question to which you don't reply to? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />admit it you're...
what is wrong with simply maybe select .... from .... where yourDateCol between @from and @to _______________________________________________...
have you tried the hard to find reverse() ? _______________________________________________ Causing trouble since 1980...
are you joining on the columns of different datatypes? there were some problems with implicit conversions in joins by sql server that was slowing...
read this before you start changing things: http://weblogs.sqlteam.com/mladenp/archive/2007/05/18/60210.aspx...
you can create a view in one of them of course. i just thought that full separation would ease maintainance....
have each db it's own connection string. for the all databases report have a separate db that holds views that union data from all other databases....
no you don't have to, but this is up to whatyou need to do and how you're planning to do it. _______________________________________________ Causing...
and no there is no elegant solutions for your problem. either dynamic sql or every db has it's own set of sprocs....
Separate names with a comma.
