Viewing 15 posts - 4,771 through 4,785 (of 49,571 total)
Brandie Tarvin (9/14/2015)
NICE. Wish our office offered nearly that much of a percentage increase on a yearly basis.
Inflation here's round about 9.5%, so....
And besides, the 10% was a round figure...
September 14, 2015 at 4:39 am
WhiteLotus (9/13/2015)
Thanks for the response . The error from output file is : The package execution returned DTSER_FAILURE (1)
What logging did you enable to get that?
September 14, 2015 at 2:49 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
I can find the logfile: C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\LogFiles\ReportSercerService_09-13-2015_01_40.log 64 KB
but do not get any usefull information by reading in it.
Indeed. The reporting services error log is unlikely to...
September 13, 2015 at 3:07 pm
BL0B_EATER (9/12/2015)
GilaMonster (9/11/2015)
jasona.work (9/11/2015)
Where do I work that gives yearly pay increases?I get raises every 6 months and don't need to sell my soul in the process, so 😛
😀
Nice! Is...
September 12, 2015 at 3:27 pm
SQL has very good memory management. Set each instance's Max Server Memory so that they don't interfere with each other and that there's enough memory left for the OS. Let...
September 11, 2015 at 1:59 pm
jasona.work (9/11/2015)
Where do I work that gives yearly pay increases?
I get raises every 6 months and don't need to sell my soul in the process, so 😛
😀
September 11, 2015 at 1:50 pm
You probably need to rebuild the index (not reorganise, rebuild).
September 11, 2015 at 1:48 pm
Why do you want it to clear the memory out? What is the memory going to be used by if you do? There is no benefit to several GB of...
September 11, 2015 at 1:46 pm
Sure. Take a backup of something smaller on the platform you'll be taking the backup on. Time it. Restore it on the environment you'll be restoring to. Time it. Extrapolate...
September 11, 2015 at 6:09 am
Please post the execution plan, not a picture of the plan. A picture is missing most of the useful information.
September 11, 2015 at 4:04 am
Can you at least post the execution plan? It's very, very hard to offer meaningful performance suggestions with just a query.
September 11, 2015 at 3:00 am
haridatpurohit (9/11/2015)
you can use following command to reduce log size of database .use <database_name>
dbcc shrinkfile(2,10)
You can, but that's a really bad thing to do to a busy database. SQL's going...
September 11, 2015 at 2:57 am
mubashir.hashmi (9/11/2015)
If your ans (Yes) about shrink log on HA1. What sql command to used when HA is online on multiple cluster node
Exactly the same one you use to...
September 11, 2015 at 2:55 am
Lynn Pettis (9/10/2015)
Here is a new one: SSIS is a cash cow add on to SQL Server.
I'd love to see how they justify that, since it and SSAS/SSRS are 'free'....
September 10, 2015 at 3:24 pm
Please post the execution plan, not a picture of part of the plan.
September 10, 2015 at 8:20 am
Viewing 15 posts - 4,771 through 4,785 (of 49,571 total)