Viewing 15 posts - 15,706 through 15,720 (of 49,552 total)
apat (11/12/2012)
Does the recovery just get aborted and start again after server is up?
Yup.
The last thing done in a recovery is a checkpoint. If the checkpoint does not complete (for...
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
November 12, 2012 at 1:09 pm
Were the rebuilds blocked by something?
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
November 12, 2012 at 12:52 pm
apat (11/12/2012)
That is what I am planning to do, but was just curious to know if not then this can real cause any corruption etc...
Not unless the reboots or updates...
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
November 12, 2012 at 12:50 pm
sql-lover (11/12/2012)
GilaMonster (11/12/2012)
Chapter 3: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/Thanks for reply.
Do you mind be more specific?
Sorry, chapter 4.
Jonathan details his algorithm for calculating the max server memory for any value of total installed 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
November 12, 2012 at 12:44 pm
SQLSACT (11/12/2012)
When using in adding a correlation predicate is redundant?
Written correctly, just about all the time. Please read that blog post and maybe BoL on how the IN function works
Am...
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
November 12, 2012 at 12:41 pm
Distinct is not a function, it does not take parameters, it does not get brackets.
COUNT(DISTINCT a.id)
Putting brackets after tends to lead to a misunderstanding of how it works if...
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
November 12, 2012 at 11:55 am
The batch EXEC ProcA has no execution plan, there's nothing in there, there's nothing to reuse. The plan for the actual execution of the procedure will be reused as per...
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
November 12, 2012 at 11:03 am
shohelr2003 (11/10/2012)
ESAT ERKEC (11/10/2012)
Why you don t use database mirroring
In database mirroring, if the primary database is corrupted for any reason other than hardware failure, then the mirror database will...
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
November 12, 2012 at 11:02 am
Well, those aren't written correctly. The correct form would be
--1
select T1.Col1 from T1
where exists
(select * from T2 where T2.Col1 = T1.Col1)
--2
select T1.Col1 from T1
where T1.Col1 ...
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
November 12, 2012 at 10:56 am
George M Parker (11/11/2012)
Make sure you have a tempdb allocation problem first by confirming that you are seeing file I/O latch waits in tempdb (database = 2).
No.....
IO latch contention 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
November 12, 2012 at 10:55 am
How big's TempDB now? unless you have a good reason, you probably want the total size of all the files to be about the same as the total size it...
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
November 12, 2012 at 10:46 am
edvard 19773 (11/12/2012)
That's expected behavior - OK, but i wonder why it is so...DISTINCT() did the trick
Hold on a sec...
Distinct is not a function, it takes no parameters and gets...
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
November 12, 2012 at 10:43 am
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
November 12, 2012 at 10:41 am
What time did the full backup complete? What's the message you get when you try to restore?
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
November 12, 2012 at 6:04 am
SQLSACT (11/10/2012)
A non-unique Clustered index has a 4byte uniquifier column added to into to make it unique, does SQL Server do the same for every non-unique Nonclustered index you create?
No....
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
November 12, 2012 at 5:35 am
Viewing 15 posts - 15,706 through 15,720 (of 49,552 total)