Viewing 15 posts - 4,996 through 5,010 (of 18,926 total)
ratna_ain (7/8/2011)
Thanks all.That's because I used virtual Machine and the database is very huge.
I agree with the huge db part but virtualized machine, when well configured shouldn't be a massive...
July 8, 2011 at 7:24 am
pwalter83 (7/8/2011)
Ninja's_RGR'us (7/7/2011)
The 7 nc index would only slow down the import of the data (assuming it's a...
July 8, 2011 at 7:23 am
TheSQLGuru (7/7/2011)
My only thing was that I have not seen many-table joins be efficient outside of tight PK/FK scenarios. The slightest variance...
July 8, 2011 at 7:13 am
If you know what I'm doing then why do you ask ? :w00t:
Few pointers from my current client. Even if this is an ERP, the system gets about...
July 7, 2011 at 4:34 pm
TheSQLGuru (7/7/2011)
Ninja's_RGR'us (6/28/2011)
July 7, 2011 at 3:00 pm
On a perf wise angle. If you have multiple variables to set it will be faster to set them all in the same go rather than separate statements.
You'd only...
July 7, 2011 at 10:20 am
The missing clustered index is the best path for improvement at this point.
The 7 nc index would only slow down the import of the data (assuming it's a massive import).
I...
July 7, 2011 at 10:08 am
pwalter83 (7/7/2011)
Ninja's_RGR'us (7/7/2011)
With 17 optional parameters, the only...
July 7, 2011 at 9:45 am
GilaMonster (7/7/2011)
Ninja's_RGR'us (7/7/2011)
GilaMonster (7/7/2011)
Ninja's_RGR'us (7/7/2011)
Awesome idea. But why do you need to rebuild just after reenable? Sounds like doing the work twice!
You re-enable a clustered index (or any...
July 7, 2011 at 8:51 am
Steve Jones - SSC Editor (7/7/2011)
July 7, 2011 at 8:45 am
ziako (7/7/2011)
This will still not get around the fact that the user needs to input the ID into the parameter field.
WHen you use reportviewer control you have to pass in...
July 7, 2011 at 8:43 am
GilaMonster (7/7/2011)
Ninja's_RGR'us (7/7/2011)
Awesome idea. But why do you need to rebuild just after reenable? Sounds like doing the work twice!
You re-enable a clustered index (or any index infact)...
July 7, 2011 at 8:13 am
I was refferring more to the dynamic sql section. I just wanted you to have an exemple on how to build it.
With 17 optional parameters, the only valid plan...
July 7, 2011 at 8:02 am
mohan.pariveda 18256 (7/7/2011)
As my Database is in Simle recovery mode, i am not allowed to take the Log backup to clear the Log file.
And only 1% is in...
July 7, 2011 at 8:00 am
Awesome idea. But why do you need to rebuild just after reenable? Sounds like doing the work twice!
July 7, 2011 at 7:55 am
Viewing 15 posts - 4,996 through 5,010 (of 18,926 total)