Viewing 15 posts - 5,341 through 5,355 (of 18,926 total)
GSquared (6/20/2011)
There are ways around the storage limit, but they're...
June 20, 2011 at 7:27 am
When you open visual studio for business intelligence (bids) you will be asked to create a connection. This is where you point to the correct database and server. ...
June 20, 2011 at 7:16 am
Grant Fritchey (6/20/2011)
Brandie Tarvin (6/20/2011)
polasabhushan (6/20/2011)
June 20, 2011 at 7:05 am
If you don't need the log to allow point in time restore then move to simple.
That means that if you do weekly fulls and nothing else then you are prepared...
June 20, 2011 at 6:56 am
Check in this table for backups that shouldn't have been running.
This script is not tailored to do exactly that but I'm sure you'll figure out the rest in no time.
...
June 20, 2011 at 6:40 am
vivekvinodhraj (6/20/2011)
since it in development phase iam using the default username and password. later i will change it to new password.
i have not used indexing on my...
June 20, 2011 at 5:41 am
Here's another idea... but you need some patience with this.
Put the db in auto_close mode (only that db).
Then wait a couple weeks or months and during that time check the...
June 20, 2011 at 5:22 am
Dave Ballantyne (6/20/2011)
a) dont use 'sa' , 'sa' as user / passwordb) read up on sql injection attacks
c) have you an index on ProductDetail.ProductName ?
And don't post that login...
June 20, 2011 at 5:17 am
How many rows in that table?
What's the filter value when it's slow? I mean if you enter where productname <= 'z' it has to return all rows so...
June 19, 2011 at 6:16 pm
Why do you need to do that?
June 17, 2011 at 3:36 pm
Dan.Humphries (6/17/2011)
June 17, 2011 at 3:08 pm
Please post the actual execution plan of the bad and good run (better to have both, but the bad is required).
So what's the stats update frequency / sequence in the...
June 17, 2011 at 7:07 am
You must put a comma between each sum... this is what's missing.
But I can't give a tested solution without the ddl and data.
June 16, 2011 at 4:10 pm
By any chance, are the tables being hit really hard HEAPS?
June 16, 2011 at 3:48 pm
GilaMonster (6/16/2011)
Ninja's_RGR'us (6/16/2011)
June 16, 2011 at 3:46 pm
Viewing 15 posts - 5,341 through 5,355 (of 18,926 total)