Viewing 15 posts - 5,416 through 5,430 (of 18,926 total)
Then why do I HAVE TO delete them before the call? 😉
June 15, 2011 at 12:59 pm
mya (6/15/2011)
see attached.
I'm pretty sure that's not what she meant. There's a ton of stuff in the txt versions of loggings in sql server and I'd bet she needs...
June 15, 2011 at 12:58 pm
deena 79174 (6/15/2011)
Thanks Ninja and everyone
My pleasure :hehe:.
June 15, 2011 at 12:55 pm
SQLRNNR (6/15/2011)
You're welcome.
And the posts counter bumps continue!
No wonder you're catching up :hehe:.
June 15, 2011 at 12:55 pm
Why does it have to be in a query re-ran on the fly everytime?
There are ways around most constraints like multi users and parameters.
June 15, 2011 at 12:53 pm
Here's what I meant (got the atachement from message conversation).
June 15, 2011 at 12:38 pm
I think it's just as simple as the server has to do more work to find the valid records.
I personally would do the select only once into a perm. reporting...
June 15, 2011 at 11:47 am
Ah we forgot the simpleton explaination. When you added the local variable a new plan was generated (possibly better than the 2 minutes one).
And stopped the prameter...
June 15, 2011 at 11:35 am
aracy (6/15/2011)
This is sql server 2008 64 bit by the way. Is this in the correct group?
Nope but we should be fine anyways...
Never done that huge of a paging...
June 15, 2011 at 11:28 am
jcrawf02 (6/15/2011)
Ninja's_RGR'us (6/15/2011)
GilaMonster (6/15/2011)
Ninja's_RGR'us (6/15/2011)
Trey Staker (6/15/2011)
Especially if we keep replying to the "Thread". lolHas anyone ever broken up the points by post to the "Thread"?
Nope but with 27K posts...
June 15, 2011 at 11:26 am
You can add an extra column in excel and build the dynamic sql string over there. Then just copy / paste.
Obviously this is a fine solution only for 1...
June 15, 2011 at 11:24 am
TheSQLGuru (6/15/2011)
Ninja's_RGR'us (6/15/2011)
TheSQLGuru (6/15/2011)
2) sharepoint is HORRIBLE from a database perspective! there are quite a few indexes...
June 15, 2011 at 11:22 am
GilaMonster (6/15/2011)
Ninja's_RGR'us (6/15/2011)
Trey Staker (6/15/2011)
Especially if we keep replying to the "Thread". lolHas anyone ever broken up the points by post to the "Thread"?
Nope but with 27K posts some people...
June 15, 2011 at 11:04 am
bitbucket-25253 (6/15/2011)
syscomments is provided for backwards compatibility only.
That is true, but I have run it in SQL 2008 and yes it does work ...
It never has worked actually. If...
June 15, 2011 at 11:02 am
SQLRNNR (6/15/2011)
Trey Staker (6/15/2011)
SQLRNNR (6/15/2011)
Ninja's_RGR'us (6/15/2011)
Steve Jones - SSC Editor (6/15/2011)
Brandie Tarvin (6/15/2011)
SQLRNNR (6/15/2011)
Brandie Tarvin (6/15/2011)
I think y'all are just adding posts to get extra points!:w00t:
Whut? No way. ...
June 15, 2011 at 10:57 am
Viewing 15 posts - 5,416 through 5,430 (of 18,926 total)