Nice and simple. Thanks.

Well to help out a bit with trying to see what might be going on at the different times I would suggest the following or something similar.

First have variables starttime...

You will need to rebuild log shipping from scratch. This is because of the .tuf file needs to be recreated and can only be done by sql server itself. Believe...

Yes, I have experience with creating a nonclustered index with the same column as a clustered index. For example:

table1 (col1, col2, col3, col4, text1, text2, text3, date1, date2)

clustered index idx_clustered...

One other advantage I have seen with having a clustered index on a specific column and then also have an non clustered index on the same column is that the...

I am a little surprised at the number of people that got this wrong. Maybe they read it wrong or looked at it too quickly. This is a straight back...

Had to think about it for a second, but nice simple question to start a long week.

dawryn (3/20/2012)

---

Koen Verbeeck (3/20/2012)

---

That is the space for the CREATE VIEW statement. That is stored in the sys.sql_modules catalog view. What I'm going after is that extra information is also...

Gail I liked your explaination as I have read about this several times. I am having to go through one of our databases to clean up performance left in the...

Thanks for the back to basics counter question. Especially on New iPad/New Apple TV release day!

Dang it. Should have thought about this one a little more. Good question.

Nice question that I think most of have run into at some point by accident. Thanks.

Needed a simple one today. Thanks for the question.

bitbucket-25253 (2/17/2012)

---

SQL Kiwi (2/17/2012)

---

This is completely the wrong approach, in my opinion. I prefer...

I like it. I ran into this exact same issue when tuning some users queries.

It is a little interesting how poorly this implicit conversion performs since most all data...