Viewing 15 posts - 5,176 through 5,190 (of 18,926 total)
No you can't avoid creating 1 dataset per input param.
There's really nothing tricky about the function. It's basically a view moved to a function so that there's no conflit...
June 29, 2011 at 7:12 am
Satnam Singh (6/29/2011)
I will do post it. I was wondering it might be due to some constraints been missing on the tables.
That would potentially affect data quality, and very rarely...
June 29, 2011 at 6:56 am
Satnam Singh (6/29/2011)
June 29, 2011 at 6:47 am
Usually doing way more work than necessary is the problem with perf. Sounds like you could have a case like that on your hands.
June 29, 2011 at 6:46 am
This assumes that you are keeping on log on the SSRS server. This query can give you great pointers about where you are wasting most of your time.
... in...
June 29, 2011 at 6:37 am
Here's what I have setup here which is about as safe as can be. Our DB is critical, but we can afford lose some data because it's an ERP...
June 29, 2011 at 6:26 am
... or upgrade sql express to sql express R2. Restore should work assuming the total datafile(s) size is under 10 GB (doesn't matter if the space is used or...
June 29, 2011 at 5:50 am
I don't know about sql 2000. I've been testing this out for a while and it's good some great features...
June 29, 2011 at 5:48 am
That would imply that you don't care about the data changes between the full backups. So in the event of a disaster you lose ALL the data since the...
June 29, 2011 at 5:31 am
I'm really not sure what you mean about questions 1 & 2. What context are you reffering to?
Also on #1 I never had that error so I can't really...
June 29, 2011 at 5:09 am
#1 You need to take another full backup NOW. Doing what you did cost you the possibility to restore to a point in time.
#2 Stop shrinking the DB from...
June 29, 2011 at 4:57 am
pavargasq (6/28/2011)
its a company procedure weve got to run daily at night for freeing up system resources
fire the manager who signed on this and come back to us for a...
June 28, 2011 at 7:15 pm
Why the **** do you stop and restart the server daily?
Whatever problem you think you are fixing, I'm 1 000 000% certain there's a better way!
June 28, 2011 at 6:46 pm
Why the heck are you going recursive with this???
June 28, 2011 at 6:43 pm
lk-681111 (6/28/2011)
Apparently the UID filter is by design; the vendor's notes in the code "explain" why:
--Only do tables owned by dbo. ...
June 28, 2011 at 2:01 pm
Viewing 15 posts - 5,176 through 5,190 (of 18,926 total)