Viewing 15 posts - 42,841 through 42,855 (of 49,571 total)
rbarryyoung (11/28/2008)
(see Phil Factor's excellent description of these dangerous mimics here).
Where? Link goes to Phil's list of articles. Not sure which one you're referring to.
November 28, 2008 at 12:57 pm
herbiechin (11/28/2008)
You don't and as far as I am aware, the backup will happen disregard if any error/corruption were found in the database. Not sure if there is an easy...
November 28, 2008 at 12:56 pm
barb.wendling (11/28/2008)
I am writing the data to a remote server, not the server having the sluggish performance.
Don't! The trace should write to a fast local drive on the server that...
November 28, 2008 at 12:44 pm
Oksana March (11/28/2008)
I am surprise to so negative reaction to the question of Venkat.
It wasn't so much what he asked, as how he asked it and how he responded...
November 28, 2008 at 12:30 pm
It could be anything. That's almost the database equivalent of asking "Why's my car making a strange noise?"
Probably you have some badly performing queries. Run profiler for a while and...
November 28, 2008 at 12:24 pm
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
Viewing 15 posts - 42,841 through 42,855 (of 49,571 total)