Viewing 15 posts - 7,516 through 7,530 (of 49,552 total)
Can you please post the actual execution plan, along with table and index definitions? You can do a search/replace through the XML to replace the table names if you're paranoid...
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 14, 2014 at 2:37 am
Bharatvip (10/13/2014)
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 14, 2014 at 2:31 am
LCK_M_S is not a schema lock, that's just a shared lock on a row/page/table. Sch-M or Sch-S would be your schema locks.
Can you post more details please? The exact resource...
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 14, 2014 at 2:28 am
Bharatvip (10/13/2014)
is it ok to look for missing indexes, indexes not used, worst performing queries, bad exec plans etc on a restored copy of the production database
Um...
Let me quote 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
October 13, 2014 at 2:28 pm
MSDB you can, but you're probably better off making sure the job and backup history tables are correctly cleaned up. Master has no user tables (or shouldn't have any), hence...
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 13, 2014 at 9:40 am
Meow Now (10/13/2014)
I'm guessing the answer will be correct as long as there are always a minimum of 10 rows in the sysobjects table.
Which, since there are more than 10...
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 13, 2014 at 7:47 am
SQL Galaxy (10/13/2014)
I want to know this values (47%), is it Acceptable value? or can we decrease that value?
It's a value. There's not much of acceptable or unacceptable about it....
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 13, 2014 at 6:50 am
Why is that a 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
October 13, 2014 at 5:51 am
Well, the error only occurs if @List is empty, so what do you think the solution 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 13, 2014 at 3:32 am
That happens when the length parameter is <0.
Probably coming from this line
SET @List = SUBSTRING(@List, 1, Len(@List) - 1)
If the list is empty, that'll throw the error you mention.
p.s. 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 13, 2014 at 3:25 am
The definition of them is in the system resource database, the data for most is memory-only, no persistence.
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 13, 2014 at 2:31 am
Nothing should have been necessary. What's the exact errors?
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 11, 2014 at 1:05 pm
Eirikur's correct.
the latter returns a set with a empty (null) column whitch is assigned to the variable.
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 11, 2014 at 1:02 pm
TomThomson (10/10/2014)
This isnt true of Windows Firewall with Advanced Security, which does allow specific addresses
Which the OP said he's using (albeit with a incorrect word, he said advanced settings rather...
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 10, 2014 at 11:04 am
If you're moving instance 2 to run on the second node, you need to license the second node as well.
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 10, 2014 at 9:05 am
Viewing 15 posts - 7,516 through 7,530 (of 49,552 total)