Viewing 15 posts - 9,586 through 9,600 (of 49,552 total)
No restart is required. Nor do you need to use WITH OVERRIDE on the reconfigure statement. WITH OVERRIDE is for when you want to force invalid values for config settings,...
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 21, 2014 at 4:08 am
Tables don't have a collation. Columns have a collation, so to change the collation on one or more columns in a table, you need to run ALTER TABLE.. ALTER COLUMN...
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 20, 2014 at 8:16 am
You can't execute a procedure as part of a select.
You're getting the GRANT commands listed out, why do you want one set of commands printed (I assume for later execution)...
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 20, 2014 at 7:44 am
If you change that to either get the GRANT or get the EXEC, then it's easy. Something like this (didn't test, so quotes may be off)
select case
when class_desc='OBJECT_OR_COLUMN' then 'GRANT...
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 20, 2014 at 7:20 am
Because the index is 4 levels deep.
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 20, 2014 at 7:05 am
Can you post the complete code please?
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 20, 2014 at 3:19 am
A proc can't be called as part of a select. What are you trying to do 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
March 20, 2014 at 3:19 am
yuvipoy (3/20/2014)
Actually DBCC Shrinkdatabase is back ground operation , it should not affect usual works right.
Um, I've told you twice it will have an impact. Is this just a case...
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 20, 2014 at 3:16 am
Confirmed then, the problem is the row goal (of 1) which the EXISTS is forcing into the plan. Bloody hard to work around to be honest.
It's usually not the efficient...
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 20, 2014 at 2:42 am
Please note: 8 year old thread.
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 20, 2014 at 2:38 am
GilaMonster (3/19/2014)
Is it SQL which is consuming the memory? How did you check?
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 20, 2014 at 2:35 am
Good, so you know the cause of the problem then. Fixing the corrupt DB will stop the stack dumps. Good luck.
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 20, 2014 at 2:34 am
A varchar(max) can store up to 2 billion characters.
Can you post your complete code? I suspect the part you've obfuscated contains the problem
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 20, 2014 at 2:33 am
Something's throwing high severity errors and SQL is writing out stack dumps to log information which may help identify and fix the problem (severity 22 are severe errors which need...
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 19, 2014 at 2:11 pm
You appear to have a corrupt database. Got any clean backups?
When did you last successfully run DBCC CheckDB?
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 19, 2014 at 9:06 am
Viewing 15 posts - 9,586 through 9,600 (of 49,552 total)