Viewing 15 posts - 33,211 through 33,225 (of 49,552 total)
E.
Edited, because Alvin timewarped the answers after I answered.
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
April 1, 2010 at 9:36 am
GregoryF (4/1/2010)
Since when did the S get added?
SQL 2005 RTM iirc
It seems to be dumbing down the log, it should be a given that any SPID < 50...
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
April 1, 2010 at 9:10 am
A system process has 's' appended to the session id in the error log. Check when SQL starts up, lots of system processes then.
I suggest you contact MS's customer support...
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
April 1, 2010 at 8:05 am
Steve Jones - Editor (4/1/2010)
And here I was thinking 137 parameters from the limitations of the datetime data to 1, 3, or 7 as the precision.
😀 I didn't even notice...
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
April 1, 2010 at 8:03 am
Bradley B (4/1/2010)
well you learn something new every day. I could have sworn that broke the log chain.
Nope.
Backup log ... with truncate_only breaks the log chain. Switching...
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
April 1, 2010 at 8:02 am
Judy-363345 (4/1/2010)
GilaMonster (3/31/2010)
Please post complete table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/Have you considered normalising that table?
CREATE NONCLUSTERED INDEX [IX_UID] ON [dbo].[myTable]
(
[UID] ASC
)
CREATE UNIQUE NONCLUSTERED INDEX...
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
April 1, 2010 at 7:59 am
Paul Randal (4/1/2010)
Steve Jones - Editor (4/1/2010)
Paul Randal (4/1/2010)
Nice one Steve!Just so you know, this was inspired by Mrs. Tripp's index writing. We were trying to copy her style.
You mean...
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
April 1, 2010 at 7:58 am
Bradley B (4/1/2010)
When you shrink your log file you will break the transaction log chain and cannot use your previous logs to restore to a point in time
Shrink does not...
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
April 1, 2010 at 7:56 am
Table definitions and index definitions please.
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
April 1, 2010 at 6:28 am
Grant Fritchey (4/1/2010)
GilaMonster (4/1/2010)
Grant Fritchey (4/1/2010)
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).
Editorial on...
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
April 1, 2010 at 6:25 am
Please post query, table definitions and index definitions, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
April 1, 2010 at 6:02 am
Grant Fritchey (4/1/2010)
I just have to share this one. I just got my idea for my next editorial (which, yes, I know Steve, is WAY overdue).
Editorial on free vs paid...
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
April 1, 2010 at 5:59 am
I certainly hope so. That would be a major breakthrough, regardless of whether it confirms or refutes the current theories. I suspect they'll find things that they weren't expecting as...
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
April 1, 2010 at 4:42 am
Lynn Pettis (3/31/2010)
Duplicate post, I'm just not looking for the other one...
http://www.sqlservercentral.com/Forums/Topic893936-1291-1.aspx
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
April 1, 2010 at 4:17 am
aaa-322853 (4/1/2010)
How was SQL Server blocking it's own threads within the same query?
What happens is that SQL parallels a particular query operator, all the threads have to complete before the...
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
April 1, 2010 at 4:15 am
Viewing 15 posts - 33,211 through 33,225 (of 49,552 total)