Viewing 15 posts - 7,516 through 7,530 (of 49,571 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...
October 14, 2014 at 2:37 am
Bharatvip (10/13/2014)
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...
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...
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...
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...
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....
October 13, 2014 at 6:50 am
Well, the error only occurs if @List is empty, so what do you think the solution is?
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...
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.
October 13, 2014 at 2:31 am
Nothing should have been necessary. What's the exact errors?
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.
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...
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.
October 10, 2014 at 9:05 am
Viewing 15 posts - 7,516 through 7,530 (of 49,571 total)