Viewing 15 posts - 6,346 through 6,360 (of 49,552 total)
stijn.wynants (3/25/2015)
After this try to check all your system databases. (since the lock is on one of you system tables).
System table != system database.
The table the error is on exists...
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
March 25, 2015 at 7:49 am
QuickToLearn (3/25/2015)
We run the job every week and it's been 5 weeks now we are getting this error. We did rerun of the job other than job schedule but...
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
March 25, 2015 at 7:46 am
Zagyg (3/25/2015)
Cheers Gila. Curiously, I did some really rough and ready tests prior to posting and got the opposite (SQL 2008R2 - maybe this makes a difference?):
Or indexes....
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
March 25, 2015 at 7:14 am
Try again later, should just be a transitory thing.
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
March 25, 2015 at 7:11 am
Run DBCC UPDATEUSAGE, make sure that the metadata around space usage is correct. The bugs in the usage algorithms should all have been fixed on SQL 2008, but...
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
March 25, 2015 at 6:32 am
valeryk2000 (3/25/2015)
Silly question:my stored procedure returns one row. I need to insert the result to a table. Can I right something like that:
=============
Insert into table1
exec myProc '1/1/15', 3/1/15'
Yes
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
March 25, 2015 at 6:25 am
3 and 4 should be identical, both in cost and results. While the optimiser doesn't optimise the distincts out, it appears to use them to make the final union more...
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
March 25, 2015 at 6:24 am
View definitions please, index definitions from the base tables and the execution plan of that query?
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
March 25, 2015 at 6:08 am
The index wasn't corrupt. Corruption does not cause query optimiser errors. It causes:
Error 824, Severity 24, State 0
SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0xfdff74c9; 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
March 25, 2015 at 6:02 am
spaghettidba (3/24/2015)
What I find disturbing is the assumption that men are sexist and if they say they don't do that it's just "not-meing".
That's certainly not what I said anywhere...
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
March 25, 2015 at 5:58 am
sp_spaceused is unrelated to statistics.
sp_spaceused uses the metadata that the storage engine knows about tables to calculate results, it doesn't use the distribution statistics which sp_updatestats (or UPDATE STATISTICS) affect
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
March 25, 2015 at 5:57 am
Order of columns within a query is irrelevant. What in my comment suggested otherwise?
Covering index will help. Looking at what you have, the easiest would be to widen one of...
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
March 24, 2015 at 7:50 am
Could we get a scrubbed query that matches the columns in the table?
It looks like there's no covering index, in which case SQL will do a table scan if 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
March 24, 2015 at 7:20 am
SARGable means 'can be used as a search argument', meaning it can be used for an index seek. For a predicate to be SARGable, it has to be:
<Column> <Operator> <Expression>...
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
March 24, 2015 at 6:46 am
https://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
What are the relevant errors you're seeing?
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
March 24, 2015 at 5:45 am
Viewing 15 posts - 6,346 through 6,360 (of 49,552 total)