Thank you,

I needed someone to confirm with me.

IgorMi

Hi,

You can re-create your index with IGNORE_DUP_KEY = ON and then it will allow inserting duplicate keys, otherwise you'll have to select distinct key values for the insertion.

GilaMonster (3/6/2013)

---

IgorMi (3/6/2013)

---

That said, I'm curious as to why you want a heap plus a nonclustered index for the base table rather than just a clustered index with no need...

You're right.

That said, I'm curious as to why you want a heap plus a...

Hi,

sp_updatestats makes the statistics update on sampling max 20% of the data. For big tables AUTO_UPDATE_STATISTICS *does not* function well. In that case you'll need to enable trace flag 2371,...

Yes, the uniqueidentifier key is the most likely your problem. If you could make changes to your tables so that it gets newsequentialid() values, then you'll obtain a very low...

Lynn Pettis (2/25/2013)

---

Really not enough information.

Partitioning really isn't used for performancing tuning queries. You need to look at the code and the indexes. Using the actual execution plans...

I want to improve Reads only

Thank you guys! These two queries are really useful for me.

Best

IgorMi

Check if your MAC address is allowed. Check the firewall and remote settings.

Hi, there is a "Parse" button in ssms which tells you some incorrect syntax of the t-sql.

For tracking what you've changed you can use a SVN, e.g.: http://www.simple-talk.com/dotnet/.net-framework/tortoisesvn-and-subversion-cookbook-part-9-server,-repository,-and-statistics/

Download link http://tortoisesvn.net/

Thorsten Wittekopf (2/6/2013)

---

Many thanks,

but the problem is that the result for NumberOfSales is Count(SalesOld.SalesManID)*Count(SalesNew.SalesManID)*2.

For example one salesman has 35 entries in SalesNew and 334 in SalesOld.

The result of the Count(SalesOld.SalesManID)+Count(SalesNew.SalesManID)...

Have you checked the User mappings of the Login for the user you gave db_datareader?

See this http://www.simple-talk.com/sql/database-administration/optimizing-tempdb-configuration-with-sql-server-2012-extended-events/

GilaMonster (2/14/2013)

---

A scan of a portion (range) of an index. Anything more than a single row is considered a range

Low scans, high range scans, I'd say that index is well...