Viewing 15 posts - 42,841 through 42,855 (of 49,566 total)
barb.wendling (11/28/2008)
I have set up a remote server side trace and selected to write data to a table on a development server.
Since a server-side trace can't write to a...
November 28, 2008 at 12:21 pm
barb.wendling (11/28/2008)
Can you suggest what event selection items to use? Or which template? I have the trace file going to a mapped drive - not to the server.
I would strongly...
November 28, 2008 at 12:15 pm
bhuvnesh.dogra (11/28/2008)
Actually ,,,if i have a database with total size 100gb ,used : 87 gb and free 5 gbthen
i would shrink it upto 80 gb
You can't shrink that...
November 28, 2008 at 12:02 pm
Don't use sp_addlogin. It's deprecated and it doesn't have the new features (like password policies). Use CREATE LOGIN rather. In the create login statement you can specify the SID which...
November 28, 2008 at 6:22 am
jordonpilling (11/28/2008)
Had already tried that, made no major difference i'm afraid, i have just tried it again and it had no effect either.
Very odd. So it's not parameter sniffing then...
Can...
November 28, 2008 at 6:21 am
bhuvnesh.dogra (11/28/2008)
but is the main issue if i shrink the data file the related log file increase heavily ...and if i then create again indexes...
November 28, 2008 at 6:12 am
p.s. Unrelated to the performance problem, but important.
Are you aware that your asp page is highly vulnerable to SQL injection?
November 28, 2008 at 5:22 am
Hmmm......
If you run the following, does the performance improve?
sp_recompile 'usp_SummaryOfCashReceiptsByCalMonth'
November 28, 2008 at 5:18 am
Will that space be reused? If so, leave it. There's no harm in free space within a database.
If it will never be reused, do a shrink file (or a series...
November 28, 2008 at 5:05 am
And the subscriptions only display the latest 500 threads. For me, that's completely useless. It's only three weeks worth at the moment.
Frankly I find searching with google far faster than...
November 28, 2008 at 4:55 am
Please don't create new threads for existing problem. All you're doing is wasting people's time as they answer questions that have already been answered elsewhere.
No moer replies to this thread...
November 28, 2008 at 4:51 am
The string for the IN needs quotes around all the values
(user1,user2,user3,user4,user5)
Not going to work as those are strings. You're also duplicating the brackets.
Pass the user list as ''user1'',''user2'',''user3'',''user4'',''user5''
Two final words:...
November 28, 2008 at 4:50 am
LiteSpeed does have the ability to do object restores from a full backup. I don't recall exactly how, it's been a while since I used the product. I seem to...
November 28, 2008 at 4:41 am
Ninja's_RGR'us (11/28/2008)
Not really, but it doesn't matter since any one can use google to find this thread again, so any new info is still usefull to post!
My comments was more...
November 28, 2008 at 4:35 am
As a wild guess, parameter sniffing, but it's impossible to say anything for sure without seeing the code.
November 28, 2008 at 4:28 am
Viewing 15 posts - 42,841 through 42,855 (of 49,566 total)