Viewing 15 posts - 2,491 through 2,505 (of 49,552 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...
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
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...
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
August 31, 2016 at 12:38 am
Please note: 6-year old thread.
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
August 30, 2016 at 12:49 pm
No issues. What you wouldn't be able to do is restore WITH STANDBY
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
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...
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
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...
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
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...
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
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?
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
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.
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
August 30, 2016 at 4:52 am
Autogrow size too large and timing out? Too small and not adding the required space fast enough?
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
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...
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
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...
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
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...
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
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......
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
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...
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
August 29, 2016 at 6:22 am
Viewing 15 posts - 2,491 through 2,505 (of 49,552 total)