Viewing 15 posts - 2,491 through 2,505 (of 49,571 total)
naga.rohitkumar (8/31/2016)
we feel that database performance issues happening and alternative for this to solve by adding more tempdb and reduce the load on the server
Unless you've checked the cause...
August 31, 2016 at 11:43 am
I don't think there's any way that SQL 2000 will install on Windows 10 (or Windows 8, or Windows 7). Get a hypervisor (Hyper-V, VMWare Player, VirtualBox), install an older...
August 31, 2016 at 12:38 am
No issues. What you wouldn't be able to do is restore WITH STANDBY
August 30, 2016 at 12:48 pm
Ok, so that doesn't look like balloon drivers or anything else external. They'd cause target server memory to drop sharply (as Windows came under memory pressure), with total server memory...
August 30, 2016 at 8:41 am
valmostricay (8/30/2016)
Is there an effective solution for sql recovery?
Restore from backup, and check your hardware, as corruption is mostly a IO subsystem problem.
That said, I'm curious as to what you're...
August 30, 2016 at 8:38 am
Sergiy (8/30/2016)
Grant Fritchey (8/30/2016)
That's if they add shrink file. That wasn't in your original answer. You just talked about the truncate, which won't result in freeing space on the drive.
Probably...
August 30, 2016 at 7:13 am
The max number of TempDB files is 32767.
Why are you considering increasing the number of TempDB files? What problems are you trying to address?
August 30, 2016 at 4:57 am
Number of filegroups and number of partitions are entirely separate things. If your partition scheme says all to primary, then all partitions are going into the primary filegroup.
August 30, 2016 at 4:52 am
Autogrow size too large and timing out? Too small and not adding the required space fast enough?
August 29, 2016 at 3:38 pm
JALLYKAMOZE (8/29/2016)
What is the best and permanent way to take care of parameter sniffing?
Option(Recompile). If that doesn't work, it's probably not simply a bad parameter sniffing problem. Can you post...
August 29, 2016 at 8:33 am
These are not the same
range left for value('20141231 23.59.59.987',(20151231 23.59.59.987')
check (businessdate is not null and businessdate < '2015-01-01')
Specifically, the value '2014-12-21 23:59:59.990' satisfies the constraint but does not belong...
August 29, 2016 at 6:41 am
SQL_Student (8/29/2016)
will try this thanks, the issue is developers require sysadmin role on this specific box
Then that's the first thing that you need to fix, with support from management.
There...
August 29, 2016 at 6:34 am
Brandie Tarvin (8/29/2016)
And giving people a list of subjects to study would help them to get to know the material, because it's more than just memorizing an answer. Right?
Hahahahahahahahah......
August 29, 2016 at 6:27 am
Ed Wagner (8/29/2016)
The only other thing I'd say to look at is the estimated number of rows versus the actual number of rows, which you don't show.
Physical Operation Index Seek
Logical...
August 29, 2016 at 6:22 am
Viewing 15 posts - 2,491 through 2,505 (of 49,571 total)