Viewing 15 posts - 18,796 through 18,810 (of 49,552 total)
Awesome.
I suspect my attempt at an article on bad management met an early grave. Think I'll stick to tech from now 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 25, 2012 at 11:23 am
How can you do an index defrag of a log shipping secondary? It's read-only at best. Or do you mean index rebuild on the primary and log shipping copied that...
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 25, 2012 at 9:37 am
michael vessey (4/25/2012)
FCB stands for File Control Block, the physical file structure usedby SQL to write in and read data from the storage.
Almost.
FCB means "File Control Bank"
It's an...
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 25, 2012 at 9:33 am
Jack Corbett (4/25/2012)
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 25, 2012 at 9:17 am
TheSQLGuru (4/25/2012)
SQLIOSIM is the tool to use to validate that an IO subsystem will properly handle SQL Server IO-style workloads.
But SQL needs to be stopped when running that. The aim...
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 25, 2012 at 9:16 am
L' Eomot Inversé (4/25/2012)
GilaMonster (4/24/2012)
Steve Jones - SSC Editor (4/24/2012)
I enjoyed that one. If you haven't read Space Prison or The Fringe Worlds, give them a try.
Space Prison: This title...
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 25, 2012 at 9:15 am
Jack Corbett (4/25/2012)
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 25, 2012 at 9:12 am
@@Error checks for the error status of the last statement run. In this case EXEC SP5. Any errors thrown by any other procedure is ignored.
http://sqlinthewild.co.za/index.php/2008/05/20/common-t-sql-mistakes/
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 25, 2012 at 8:40 am
I wouldn't. I'd check my data types before inserting, ensure parameters are of the correct type so that the call to the procedure would fail not the insert and write...
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 25, 2012 at 8:04 am
SQLKnowItAll (4/25/2012)
S_Kumar_S (4/25/2012)
The sample code is at bottom. I have introduced 2 erros in the proc. Both are level 16 errors. I was expecting that the insert statements after error...
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 25, 2012 at 7:41 am
S_Kumar_S (4/25/2012)
I was looking for some response here but looks like there are no specific reasons for this behaviour.
Bumping your thread after 3 hours is entirely unnecessary. We're volunteers, we...
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 25, 2012 at 7:41 am
Let me guess, you're running log backups outside of the log shipping?
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 25, 2012 at 7:23 am
anthony.green (4/25/2012)
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 25, 2012 at 2:59 am
If you haven't restricted SQL to not use 8 cores (affinity mask), it will use 8 cores as necessary
SQL will use memory up to the max server memory setting. 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
April 25, 2012 at 2:22 am
You have no indexes on DRTemp that support that query.
Add an index (CUSTNO, DRDATE) INCLUDE (ID)
This index is likely useless
CREATE NONCLUSTERED INDEX [IX_DRTemp] ON [dbo].[DRTemp]
(
[ID] ASC,
[DRNo] ASC,
[CustNo] ASC
)
It has 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 25, 2012 at 2:00 am
Viewing 15 posts - 18,796 through 18,810 (of 49,552 total)