Viewing 15 posts - 11,656 through 11,670 (of 49,552 total)
Benki Chendu (9/18/2013)
1. If I truncate this table and run a dbcc, would the errors disappear?
If the errors are only in that table, yes.
2. Is there a way I can...
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
September 18, 2013 at 2:07 pm
Auto update only kicks in after 20% of the table has changed. On larger tables that's no where near sufficient. There have been traceflags added to SQL 2008 to adjust...
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
September 18, 2013 at 2:03 pm
mike.hockman (9/18/2013)
In our bi-weekly Index rebuild job, I am immediately running sp_updatestats following the Index rebuild. I figured it was more efficiant this way.
That could actually be harmful....
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
September 18, 2013 at 1:15 pm
You can't back up a mirror database.
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
September 18, 2013 at 12:44 pm
It's not the fragmentation.
Your statistics are getting out of date. I'd guess either auto_update stats is off or these are large tables. The stats aren't getting updated, the estimated row...
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
September 18, 2013 at 10:19 am
T.Ashish (9/18/2013)
But in your blog you are saying "the actual plan costs are still just estimates".
The costs are estimates, they are always estimates. The only thing actual about an actual...
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
September 18, 2013 at 9:40 am
No, makes less sense.
The query i posted doesn't return just rows from before 6:02. It would return all rows between 5:55 and 14:05 inclusive.
If the intervals are every 5 minutes,...
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
September 18, 2013 at 5:34 am
In what context?
There isn't something specifically called an 'archive server'. You can have a database server that stores the archived portions of databases, a file server that stores archived files,...
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
September 18, 2013 at 5:28 am
That they're ad-hoc queries, not stored procedures.
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
September 18, 2013 at 5:20 am
pelsebubb (9/18/2013)
i still get that the column is read only after execution of :set IDENTITY_Insert tablename ON on the table.
Are you trying to insert or update? If insert, then you...
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
September 18, 2013 at 5:18 am
Why so complex?
Write the query in the simplest possible way. If that query form proves, in testing, to have performance problems, consider alternates.
SELECT <column names> FROM ProductionTest WHERE DateTimeStamp >=...
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
September 18, 2013 at 5:14 am
himanshu.sinha (9/17/2013)
Can someone let me know what is that I am missing here ?
Unallocated space. Log file.
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
September 18, 2013 at 1:37 am
You can explicitly insert into that field if you turn IDENTITY_INSERT on. There's no way to update an existing value in a column that's marked as identity.
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
September 18, 2013 at 1:32 am
You set up a DNS alias named 'ReportServer' (for example), it points to Server A, so when people connect to ReportServer, they get directed to Server A. When you want...
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
September 17, 2013 at 3:17 pm
Please post table definition, index definitions and execution plan 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
September 17, 2013 at 2:54 pm
Viewing 15 posts - 11,656 through 11,670 (of 49,552 total)