You can studying here, not sure about the USA. (That 7.5-to-1 exchange rate really messes things up)

See why...

What do you mean by 'cannot work'? Is it giving an error? Is it not giving the values you want? Something else?

Calculated columns are not stored, they're calculated when the...

Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic851782-391-1.aspx

Silaphet Mounkhaty (1/21/2010)

---

Also, I cloned this production database to our Test server two months ago and I had a user ran a few searches on our test box and the...

Can you try shrinking in smaller chunks?

Then look at tuning your queries and indexes. That's usually the largest return on time spent

Is there any way...

Sounds more like stale statistics.

Does UPDATE STATISTICS <Table Name> WITH FULLSCAN help?

Do you have blocking or deadlocks? Are you seeing error 1205 for either process?

If deadlocks, switch traceflag 1222 on. That will result in a deadlock graph been written to the...

I've done it on my x64 desktop. Ran a simple update. Everything stopped responding, including OS. Not pretty.

Run this, post any results.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Also, don't shrink the DB to the minimum size. Leave it some space free. SQL needs some free space in...

Standard edition ignores locked pages if you're below a certain patch level. SP3 + some cumulative update. Can't recall exactly which one (google is your friend here)

Setting max memory is...

JMSM (1/21/2010)

---

We've got a client that detect that in one database three tables are without statistics.

Q1: My SQL Instance its configured to automatically update statistics so why are not update...

What are the NTFS permissions on the folder? For sharing there must be the share permission and the underlying NTFS file system permissions

The SQL service account must have read and...

Most likely because it's figured that it will read fewer pages if it scans the nonclustered index. The NC index has the clustering key in it, so it can just...

To reproduce that in your test example, change your insert into the first temp table as follows:

INSERT INTO #pool_def VALUES('pool', 'subcmp1')

INSERT INTO #pool_def VALUES('pool', 'subcmp2')

INSERT INTO #pool_def VALUES('pool', 'LEADCMP')

Because there...