Viewing 15 posts - 5,281 through 5,295 (of 49,552 total)
Ack, I just read your first post again. Change the locks value back to 0. That's not the number of locks on an object which triggers an escalation (which 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
July 16, 2015 at 10:51 am
Not asking about SQL's version. Asking about Management Studio.
Tried restarting SSMS?
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
July 16, 2015 at 10:35 am
What version of Management Studio are you using? (Help->About)
What does this return?
select name, is_query_store_on from sys.databases
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
July 16, 2015 at 10:27 am
Does the SQL Server service account have access to the path you specified?
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
July 16, 2015 at 10:23 am
It's not logging related to replication.
When you have transactional replication, the space in the database's transaction log cannot be marked reusable until the log records have been replicated. Hence if...
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
July 16, 2015 at 10:21 am
What's the complete error?
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
July 16, 2015 at 10:14 am
Try using openquery instead of the 4-part naming. That way you can be sure that the query is executed on the remote server and the results sent across, not 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
July 16, 2015 at 10:00 am
They're global temp tables, they aren't dropped until the connection using them closes and no one else is using them.
Even if they were normal temp tables, they wouldn't get dropped...
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
July 16, 2015 at 9:49 am
SELECT @COLUMNS = @COLUMNS + c.name + ','
from tempdb..syscolumns c
join tempdb..sysobjects t
on c.id = t.id
where t.name like '##OutputTable
order by colid
Unclosed quotation mark after the character string '##OutputTable
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
July 16, 2015 at 9:42 am
Possibly because there are other locks on the table. Escalation isn't guaranteed, if there are any incompatible locks on the table, the escalation will fail and the original locks will...
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
July 16, 2015 at 9:21 am
Yes.
Index rebuild creates a new index and then drops the old one.
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
July 16, 2015 at 9:17 am
No. I didn't say destroy your database by deleting the log file. I said add a new 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
July 16, 2015 at 9:14 am
You'll need to remove the replication before you can do anything with the log. While the database is published, the log can't be made reusable until the log records are...
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
July 16, 2015 at 8:04 am
Blackdog (7/16/2015)
I've heard exam writing is outsourced to somewhere in India and then proof read before they go live. I'm not sure about army's of exam beta testers.
Nope. 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
July 16, 2015 at 7:54 am
Blackdog (7/16/2015)
Personally I like them they give you a real insight into what's coming up in the exam.
Blackdog (7/16/2015)
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
July 16, 2015 at 3:47 am
Viewing 15 posts - 5,281 through 5,295 (of 49,552 total)