What is the total size of these 9 million rows?

Just for the record, this issue can show up very quickly if a user database and tempdb have different collations, as all temp tables are created in tempdb and (as...

Firewall was my first thought, good to hear that the issue is fixed now.

And SQL Server Browser?

The quick DYI answer would be:

1. No identity on second table

2. Do all the data modifications in a single transaction

3. Insert in the first table

4. Retrieve SCOPE_IDENTITY to get the...

jwmott (6/11/2012)

---

trying to design a schema for a project where we will be exchanging data with another organization. The initial problem I was having is how to allow a numeric...

When SQL Server is running on node 1, ensure that the SQL Server Browser is started, and that SQL Server Browser traffic is allowed through windows firewall (UDP 1434). As...

Without the execution plans and a bit of understanding of your data, it is hard to tell. However, based on the statistics in your database, SQL Server thinks it can...

Something like this?

SELECT TOP 1000

[ModelId] ,

[GroupId] ,

...

Even separate spindles may not always be satisfactory, as the bus subsystem (eg the FC or iSCSI connection) may be the most limiting factor.

If so, you have to use union all, as...

select t1.total_savings+t2.total_savings as total_savings

from

t1 inner join

t2 on t1.year = t2.year and t1.week = t2.week

A brilliant example of the importance telling what you want. You (apparently) want the due date where the month is may, which can be retrieved with the following query:

SELECT DueDate...

I would definitely not enable xp_cmdshell on all my servers, due to the security risk of it.

Abrar Ahmad_ (6/4/2012)

---

If possible kindly share the output of the code segment and explain a bit, because we are still on the place of having no sequences in SQL SERVER...