Viewing 15 posts - 331 through 345 (of 2,268 total)
the way we did it was to use a NLB to handle the load balancing between our two client applications which were connected directly to their own database s
these...
July 8, 2011 at 6:23 am
is this for a SSRS report?
what I do in this situation is create a 'dummy' calculated measure in the data source and have it '= 1', as this...
July 8, 2011 at 2:07 am
you could always install IIS on the box as well and do the redirect there
July 7, 2011 at 2:43 pm
I would go for Option 3, depending on what type of database is used, as this cuts out all the middle work and will be easier to maintain
July 7, 2011 at 5:14 am
S_Kumar_S (7/7/2011)
I even tried it practically,...
July 7, 2011 at 4:06 am
S_Kumar_S (7/7/2011)
ok, but i am sure, clustered index always gets sorted data on key columns, without adding ORDER BY, Always.
no it doesn't not always.
July 7, 2011 at 3:36 am
no,
the only way to guarantee the order of the results of a query is to use the ORDER BY clause.
July 7, 2011 at 3:23 am
Steve Jones - SSC Editor (7/6/2011)
Maintenance plans have worked for me in the past, but I like Ola's script as a more flexible solution.
Ola's script is definitely a lot better...
July 7, 2011 at 1:05 am
halifaxdal (7/6/2011)
Ninja's_RGR'us (7/6/2011)
steveb. (7/6/2011)
the maintainence plan wizard will also setup these date stamped backups for you.
MP have always been buggy over the years... I've pretty much lost all confidence...
July 6, 2011 at 3:43 pm
there is no real magic fix for these sorts of problems, but i would start by updating the statistics and having a look at the execution plan for the...
July 6, 2011 at 8:44 am
the maintainence plan wizard will also setup these date stamped backups for you.
July 6, 2011 at 6:01 am
ashkan siroos (7/6/2011)
@steveb-2. :Thanks dude for reply ,but actually it was not about comparing nvarchar and varchar,
What I mean was to compare datetime VS string fields.
yeah i got that, ...
July 6, 2011 at 5:49 am
Ol'SureHand (7/5/2011)
but will create a .BAK file that only has data and no unnecessary transactions.
what do you mean by this ?
July 6, 2011 at 2:11 am
you should buy some new bigger disks, as surely the database growing is a good thing?
July 5, 2011 at 9:29 am
I would recommend testing this approach before anyone goes out and does it, there are mixed opionions on if dropping and re-creating indexes for an ETL load is the...
July 5, 2011 at 8:55 am
Viewing 15 posts - 331 through 345 (of 2,268 total)