Viewing 15 posts - 1 through 15 (of 58 total)
For a diagrammatical explanation of the execution plan, type ctl + K
Good luck.
October 14, 2003 at 7:54 am
Instead of trying to compare single column values to multivalue columns, look at using the like operator to search through the multi-value columns looking for instances of the name you...
July 22, 2003 at 10:40 am
Probably not, since the multi-server jobs have to be configured to run on the target servers (TSX), and not the master (MSX). Have the feeling you will have to create...
July 22, 2003 at 10:33 am
Think that a5xo3z1 and the nulls do float to the top. What about using a 'case when' statement and replace nulls with 'zzzz' to push them to the bottom. Pretty...
July 11, 2003 at 4:46 pm
BOL - identifiers,delimited will give you a listing plus advice.
July 10, 2003 at 12:20 pm
Not sure that SQL Server logs this information. Have the feeling you will have to record manually the time indexes where rebuilt/reindexed. Maybe Yukon will provide this support.
July 10, 2003 at 4:32 am
Integrated security means that ActiveX will use your windows logon credentials when connecting to sql server. Persist security info=false means that the connection properties will not be maintained after...
July 5, 2003 at 4:51 pm
Shas3 is correct in that if you do add another file to the default fg, then sqlserver will automatically using it. Bad idea to completely fill the primary fg since...
July 1, 2003 at 3:46 pm
Not sure that i have fully understood the question, becuase it will be difficult to count that which does not exist. If you want a list of records that does...
June 28, 2003 at 9:41 am
Every login (SQL or Windows) has a default database property. When the connection is made to SQL Server, the login is verified via sysxlogins, and then taken to the default...
June 28, 2003 at 7:57 am
Viewing 15 posts - 1 through 15 (of 58 total)