Jo,

As I researched, SQL locks pages in memory so with SQL max memory set at 480 GB, it does not make sense to create a 480 x 1.5 = 720...

Hi Rinu, thanks for your feedback.  I already looked at the option to initialize from a backup but there was not enough disk space to restore the whole database.  I...

Thanks Doug for your suggestion. I managed to use the wizard to create the report below. I did try the hard way and wasted time! However I...

Thanks Luis and Eirikir. I really appreciated your help. 🙂

Hi Eirikur,

How do I get the result like below without using pivot? Thx.

------------------------------------

Dept | A | B | ...

Thanks Gail and George.

Just took the 462 today. 50 questions in 155 minutes. The test center provided dry erase paper. I did not ask about the bathroom break but they did...

I am using that book too. Can't believe its full of mistakes like this.

eriks4j (1/4/2013)

---

Good job. I would have loved to follow it through to end.

Unfortunately, my Mining Model Viewer returned error "Unable to connect to local server"

I have restarted and all services...

No. There is no deadlock in SQL logs at all. ...

Thanks. More to learn for me.

I thought deadlocks would be recorded in SQL logs because I remember seeing deadlock errors in SQL logs before. I did not expect...

Yes that was a critical issue but thanks god we had it resolved. The problem was a search query. We finally had the query tuned and the whole...

that look like finding needle in a haystack because we have new dev guys unfamiliar with the system :angry:

I found a stored procedure suspended in sysprocesses. When we tested...

I see in profiler there are few connections with Transaction Isolation Level set as Serializable. The default for the server is READ COMMITTED. Could that be the reason...

Hi Anthony, it is rebuild index. Thx.