WayneS (4/4/2011)

---

When you start up SQL Server, if you were to run:

SELECT * from tempdb.sys.tables

there are a handful of table variables in the results. Does anyone have an idea of...

At this point the only updates to SQL Server 2008 R2 that I am aware of are CUs, Cumulative Updates, which can be downloaded and put on any kind of...

Nice question, thanks!

Steve,

I hate to be a pest but what do you consider soon? 😉

Here is an option that works better, though I still won't guarantee 100% accuracy. (I haven't tested every possible combination, like the use of LOB data types.)

CREATE TABLE #T1 (ID...

deepakagarwalathome (4/1/2011)

---

Where is the table definition for your table 'b'? And how do you know that the rows in table 'b' will be ordered in the same way as those...

Nice question, thanks! It is good to provide exposure to some of the newer stuff coming up.

Craig,

That is a portion of what I suggested, but it really falls short.

For example if the first table contains 7 rows with a value of 1 and the second table...

I personally think that this change confuses a lot of people, and that they should name the button add. Also, it would be nice to have a remove button, rather...

Parthi,

I think he was showing each table having three rows, not three columns.

As far as a way to compare the complete contents of two identically structured tables you could try...

Wouldn't it be nice if there was a SQL Server alternative that was that much cheaper, think of the extra hardware we could buy!:-D

In 2008 you would use the "Search..." button to the right of "Users or roles:" to find an add a user, and then you can check the permissions in the...

I don't understand exactly what you are trying to accomplish, but you can't have a CASE expression evaluate to two different types. (SQL Server will attempt to convert them to...

Have you reviewed the setup logs to see what else they might say? (Microsoft has an article on the location and contents of the logs here: http://support.microsoft.com/kb/955396.)

My first guess would...

Ketan,

Using the "INSERT INTO tablename SELECT ..." method will put locks on the table you are inserting into, but it shouldn't lock the entire database like the "SELECT ... INTO"...