Viewing 15 posts - 22,561 through 22,575 (of 49,552 total)
Create PROCEDURE [dbo].[proc_AdditionalInfotbl] (@jobtbl JobTableType READONLY) AS
Begin
Update additionalinfo
Set RunningUnwind = Case unwindfrnt when 5 then 1 when 6 then 2
when 7 then 3 when 8 then 4 else...
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 2, 2011 at 11:49 am
No. Left should be, but it isn't. Reverse couldn't possibly be SARGable because it completely modified the value
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 2, 2011 at 11:48 am
isuckatsql (11/2/2011)
I have four 8-core processors and from what i have read, you should have one TempDB file for each core.
As for size - as large as it needs to...
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 2, 2011 at 11:44 am
Gone as in what?
Not visible if someone selects from the table?
Not visible if someone uses DBCC PAGE to read the raw data page?
Not visible if someone uses a hex editor...
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 2, 2011 at 11:43 am
GSquared (11/2/2011)
It's pretty much anything other than an equality comparison between a column and another column or between a column and a variable
Inequalities are SARGable. It's not just equality comparisons.
WHERE...
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 2, 2011 at 11:25 am
rbalt (11/2/2011)
Does a full backup include ghost records? When I restore to another location are they still there?
If there are ghost records on the pages at time of backup,...
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 2, 2011 at 11:23 am
Sapen (11/2/2011)
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 2, 2011 at 9:26 am
http://msdn.microsoft.com/en-us/library/aa258803%28v=sql.80%29.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
November 2, 2011 at 9:24 am
Probably the usual suspects - inefficient code and poor indexing combined with increasing amounts of data. The lack of space is a concern, you don't want to run the DB...
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 2, 2011 at 9:20 am
DBCC ShowContig
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 2, 2011 at 2:46 am
Poor performance, especially IO throughput.
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 2, 2011 at 2:45 am
Please run the following and post the full and complete results:
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Got a clean backup?
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 2, 2011 at 2:44 am
If that's a single statement update, then it must succeed or fail as a single operation, not partially succeed and partially fail. That's required by the ACID rules of relational...
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 2, 2011 at 2:43 am
Apex SQLLog is the one I know. Not cheap.
It won't give you the exact update statement as was run, because that's not logged. All that's logged is before and after...
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 2, 2011 at 2:42 am
Tried this?:
UPDATE #TEMP2 SET AGGTracked=A.AGGTracked FROM
(SELECT COUNT(PRID) as AGGTracked,PRID,LOCID,Rev_CatID,MSTTYPE FROM #TEMP
WHERE MCMetric ='New' AND PEEvent = 'New'
group by PRID,LOCID,Rev_CatID,MSTTYPE) A
INNER JOIN #TEMP2 B ON A.PRID = B.PRID AND (A.LOCID=B.LOCID OR...
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 2, 2011 at 1:19 am
Viewing 15 posts - 22,561 through 22,575 (of 49,552 total)