Viewing 15 posts - 4,771 through 4,785 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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 😛
😀
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 11, 2015 at 1:50 pm
You probably need to rebuild the index (not reorganise, rebuild).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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'....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2015 at 3:24 pm
Please post the execution plan, not a picture of part of the plan.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 10, 2015 at 8:20 am
Viewing 15 posts - 4,771 through 4,785 (of 49,552 total)