Yelena I believe addressed clustering in general. There are a number of people who believe that almost all tables should be clustered for maintenance/performance purposes and there are likely lots...

Please post to http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=137875 instead (duplicate post).

SQL Server needs to pick one and only one access path for your SELECT statement. Since there are 5 columns being compared it will assume that every one is being...

Those are OS level shares and not in SQL Server. Under Windows NT you can detect them with the NET SHARE command, but basically talk to your network people about...

Thanks a lot. Although not what I was looking for, it appears that I wasn't looking for the right thing. This does the trick very nicely. I was a little...

Incidentally, EM will tell you what T-SQL it is about to use. Make the desired changes to a table from design mode but do not save them yet. Very near...

There may be a better way, but it occurred to me that the following should work at least for the most part.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=136926#bm137004

A more manual process would be to run...

declare @FirstName varchar(100)

declare @LastName varchar(100)

FETCH NEXT FROM Employee_Cursor INTO @LastName, @FirstName

Actually Option 1 was to simply leave the data where it is and create a cross server SELECT statement. You can do that if you open a connection to the SQL...

Well, although I don't know this for certain, my supposition (and proof by expiramentation) is that the ORDER BY clause creates a temporary column for internal sorting when a sort value...

Yet another. Its a single pass without a sort step.

declare @MaxNum int

declare @MaxNumMinOne int

set @MaxNum = 0

set @MaxNumMinOne = -1

SELECT @MaxNumMinOne = case when @MaxNum < ClientNumber then @MaxNum else...

Look up sp_table_privileges and sp_table_privileges_ex in BOL.

I expect someone else to have a better idea, but I believe Profiler could be used to monitor transactions. You could then record the results to a table for a...

Depends. The where clause you provided would be much faster, but that would require dynamic sql. If one of the two constants is a variable (which I expect is what...

If you need to originate from Oracle then that would be a problem. You could try an Oracle forum for something analagous to sp_addlinkedserver unless you already know there isn't...