Viewing 15 posts - 37,771 through 37,785 (of 49,566 total)
A unique constraint is implemented as a unique index, so order of columns matters just as much, and for the same reasons, as with a composite index.
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
That's the order of...
July 9, 2009 at 11:51 am
The requirement to grant view definition remains the same. Both syscomments and sys.sql_modules are based off the same system tables. It's just that syscomments will go away in a future...
July 9, 2009 at 11:46 am
If you have an output parameter then you need to pass a variable in that spot so that the output can go into something.
This will work and allow you to...
July 9, 2009 at 10:51 am
Please post query, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 9, 2009 at 10:48 am
ruchika thapa (7/9/2009)
yes it is sys.syscomments.
sys.syscomments is not a table any longer. It's a deprecated, backward compatability view. Use sys.sql_modules instead
It says" grant or revoke VIEW DEFINATION is not compatitable...
July 9, 2009 at 10:46 am
That's saying that the transactional replication has never replicated a single transaction.
Is the replication on this server transactional?
If it is, are you seeing transactions replicating to the subscriber?
Is the log...
July 9, 2009 at 10:44 am
Ok, if the reason is replication then it means that the log reader either isn't running or isn't keeping up with the changes. The log records can't be discarded while...
July 9, 2009 at 10:19 am
syscomments isn't a table any longer. You should be using sys.sql_modules now.
I believe you need to grant VIEW DEFINITION rights to the objects in the database. If everything's in the...
July 9, 2009 at 10:17 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750357-146-1.aspx
July 9, 2009 at 9:46 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750357-146-1.aspx
July 9, 2009 at 9:32 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750357-146-1.aspx
July 9, 2009 at 9:31 am
The only things that reduce the size of the transaction log are DBCC ShrinkFile and DBCC ShrinkDatabase. A log backup will make the space within the log available for reuse,...
July 9, 2009 at 9:30 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750357-146-1.aspx
July 9, 2009 at 9:27 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic750357-146-1.aspx
July 9, 2009 at 9:27 am
Viewing 15 posts - 37,771 through 37,785 (of 49,566 total)