Viewing 15 posts - 5,566 through 5,580 (of 49,552 total)
It's not an error. It's a message informing you that the database you're using has been changed.
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
June 18, 2015 at 7:02 am
I strongly recommend against moving the master database from one instance to another. I suspect it won't even be possible to move them up-version.
For your certificates, back them 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
June 18, 2015 at 3:34 am
Please note: 4 year old thread.
And you can run CheckDB on TempDB. It doesn't do the same amount of checks as for other databases, but it can be run.
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
June 18, 2015 at 3:14 am
If the index is not in the execution plan, then it's not useful for that query and is not been used.
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
June 18, 2015 at 2:31 am
Alvin Ramard (6/17/2015)
GilaMonster (6/17/2015)
Please note: 10 year old post.Hopefully the OP isn't still looking for that procedure.
Hopefully the SQL 7 server has long since been relegated to the trash...
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
June 17, 2015 at 2:54 pm
Please note: 10 year old post.
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
June 17, 2015 at 2:41 pm
JimmyJones (6/17/2015)
Do you have any 'foolproof' method to check the stored proc usage?
Yup. Extended events run for a full business cycle (usually a year). Use the bucketiser and group on...
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
June 17, 2015 at 2:28 pm
PearlJammer1 (6/16/2015)
The trace returns the object_id's of many stored procedures. I then query the sys.procedures and plug in the object_id to return the stored proc name.
Why don't you join 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
June 17, 2015 at 5:08 am
JimmyJones (6/17/2015)
This will tell you if a stored procedure in your DB had been run since the last server restart (or freeproccache)
Or other event which removes plans from cache, or...
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
June 17, 2015 at 5:07 am
Edit: ignore, misread question.
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
June 17, 2015 at 4:16 am
Please don't cross-post
No replies here please, replies to http://www.sqlservercentral.com/Forums/Topic1695235-391-1.aspx
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
June 17, 2015 at 3:48 am
If you change the service account using SQL Server config manager, Config manager will add all the permissions that SQL Server needs. You'll only need to add in optional ones,...
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
June 17, 2015 at 3:30 am
j.grimanis (6/16/2015)
I am afraid that it is executed during the commit, thats why it cannot read the updated table
That is not possible.
Statements run sequentially. If you have a call...
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
June 17, 2015 at 3:19 am
j.grimanis (6/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
June 16, 2015 at 1:15 pm
As I said, Traceflag 1222 is to get the deadlock graph written to the error log.
The error's thrown no matter what, which means that any alert on the error 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
June 16, 2015 at 1:12 pm
Viewing 15 posts - 5,566 through 5,580 (of 49,552 total)