Viewing 15 posts - 16,351 through 16,365 (of 49,552 total)
I'm not talking about the checkDB completion messages. Is there nothing else before that in the error log, maybe hinting as to why it's trying to lock tables?
Actually... What is...
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
October 1, 2012 at 2:09 am
If people PM me questions or followups to questions my only answer is 'please post this in the forums'.
As for private data, they shouldn't be sharing it at all. 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
October 1, 2012 at 2:08 am
With blanks?
SQL ignores trailing spaces when comparing strings. Just make sure that the char length is longer than the string you're converting.
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
October 1, 2012 at 2:04 am
You're within the size limits then. The size limit is on the data files, the log file does not count. so 6 GB used out of 10 GB allowed.
p.s. Got...
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
October 1, 2012 at 1:51 am
I think you've got that query the wrong way around. You're comparing the encrypted column with the results of the decryption function. You should be comparing the decrypted value with...
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
October 1, 2012 at 1:50 am
Call CSS. Sounds like you hit a rather strange bug.
Is it reproducible?
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
October 1, 2012 at 1:45 am
Not enough information. Could be missing indexes, could be incorrect stats, could be a few other things
Please post table definitions, index definitions and execution plan, see http://www.sqlservercentral.com/articles/SQLServerCentral/66909/ for details
Cleaned up...
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
October 1, 2012 at 1:20 am
Those are all system processes and they are all waiting for something to wake them up. This is correct and expected behaviour, the system processes don't run all the time.
Don't...
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
October 1, 2012 at 1:14 am
And the error message the backup gives is....?
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
October 1, 2012 at 1:13 am
How big's the data file, how big's the 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
October 1, 2012 at 1:13 am
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 30, 2012 at 4:13 pm
All that gave you was the last command that the session in question ran, not all of them. If there were multiple commands run in the transaction, that query would...
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 30, 2012 at 4:10 pm
ashkan siroos (9/30/2012)
How did you identify that?
I ran the "dbcc opentran" command.
it returned an open transaction that didn't killed after 5 minutes, and it has the select statement on it
and...
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 30, 2012 at 9:54 am
There should be more errors in the error log than just that. Please find them and post them here.
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 30, 2012 at 8:46 am
ashkan siroos (9/30/2012)
We have some tables that we call them LKs.( look up tables)It is obvious that we have no insert, update or delete on these tables.
Why is it obvious?...
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 30, 2012 at 8:45 am
Viewing 15 posts - 16,351 through 16,365 (of 49,552 total)