Viewing 15 posts - 11,656 through 11,670 (of 49,562 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...
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...
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....
September 18, 2013 at 1:15 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...
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...
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,...
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,...
September 18, 2013 at 5:28 am
That they're ad-hoc queries, not stored procedures.
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...
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 >=...
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.
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.
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...
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/
September 17, 2013 at 2:54 pm
Viewing 15 posts - 11,656 through 11,670 (of 49,562 total)