Viewing 15 posts - 12,136 through 12,150 (of 49,552 total)
e4d4 (8/13/2013)
http://support.microsoft.com/kb/290622Uncheck "Attempt to repair minor problems"
This. It's the stupidest option I've ever seen in a maintenance plan (back up tail of log being close)
If this is happening, it means...
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 13, 2013 at 8:20 am
You can't set master to single user mode and you don't need single user mode to run a normal checkDB.
Why are you running repair? What's damaged? Do you know what...
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 13, 2013 at 1:48 am
Honestly, the question is a little too vague to answer. Depends on any filtering done, the joins and a whole lot more.
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 13, 2013 at 1:35 am
paul.knibbs (8/12/2013)
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 12, 2013 at 7:08 am
A little vague, but in general
INSERT INTO @TableVariable
SELECT <column list> FROM dbo.Function(<parameters>)
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 12, 2013 at 2:11 am
SQL Server's configuration setting Max 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 12, 2013 at 2:02 am
With the max server memory configuration setting.
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 11, 2013 at 4:14 pm
Easy method - drop them all and see which ones SQL recreates. Those are the ones it thinks it needs
Accurate method - google for which traceflag turns on the optimiser...
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 11, 2013 at 4:10 pm
The select will take a shared lock, probably at the table level. The update will take an exclusive lock, can't tell what granularity without knowing more about indexes and data...
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 11, 2013 at 10:56 am
Look up the DMVs in Books Online, or google them. There are plenty of sample scripts available that use them.
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 11, 2013 at 6:43 am
That's a bit convoluted, you don't need two nested subqueries
select SubjectCode,SubjectName,Description
from Subject
Where SubjectCode In
(select SubjectCode
Where SubjectCode like 'BS%' and LessonDate = '20130305');
That'll do the same thing.
Does that subquery return...
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 11, 2013 at 3:39 am
On 32-bit windows, VAS is 2GB kernel, 2GB user, that's universal no matter whether the server has 10MB memory or 64GB.
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 11, 2013 at 3:32 am
anoop.mig29 (8/10/2013)
But suppose before T3 i take full backup F2 then i cannot restore T3 untill F2 is restored.
Sure you can. Full backups do not in any way interfere in...
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 11, 2013 at 3:28 am
Identify what's using so much TempDB (the task_space_usage and session_space_usage DMVs), tune the culprits to use less TempDB.
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 10, 2013 at 1:01 pm
SQL uses memory outside of the buffer pool (which is what max server memory sets). Nothing wrong, this is normal behaviour, however you cannot set how much extra. It's usually...
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 10, 2013 at 1:00 pm
Viewing 15 posts - 12,136 through 12,150 (of 49,552 total)