Basically, as said above, you don't. You use VS 2k8 for SQL 2k8 and 2k5 for 2k5. 2010 is for SQL 2012.

dgowrij (2/5/2013)

---

Hi Lynn,

Just to understand, Could you please explain how the query works? Especially the part

(SELECT 1) dt1(n)

CROSS APPLY (SELECT COUNT(*) FROM dbo.Customers) dt2(q1)

...

I have seen heavy maxdop interfere with writes and I/O, but it would have to be an extreme case for me to look towards that as a culprit. If...

The .sqlplan you posted is the estimated plan, not...

Lowell (2/1/2013)

---

Craig I think that was true with SQL2000, and the old SQL Mail, but the 2005 and above database mail via msdb.dbo.sp_send_dbmail is already an asynchronous service broker...

I want to throw in a warning here. Sending emails via triggers means that if the exchange server goes down... so does your database. Also any transaction has...

Danah (1/30/2013)

---

Titles seem to mean a lot in Australia, because employers use the average salary for a title to figure out what the market rate for a position should be....

Can you script your schema and some sample data for product_prices?

This seems like a typical logging table selection, but I want to make sure I understand your data layout precisely.

Edit:...

Would need, at the least, to see the .sqlplan and the tables/indexes. Check out the second link on the left side of my signature for all the pieces that...

Danah (1/29/2013)

---

- DBA: focusing on administration and maintenance of all SQL instances, performance, permissions, disaster recovery, capacity planning and all the usual stuff (this was my original job title here)

-...

It's one of the easiest ways to get...

ReamerXXVI (1/29/2013)

---

How can I pass a pre-set parameter to a stored proc, for example;

DECLARE @param1 VARCHAR(MAX)

SET @param1 = 'value1, value2, value3'

EXEC usp_doStuff @command1 = 'Some stuff goes here', @command2 =...

There is a small area where CHAR performs better storage-wise than VARCHAR because of field size settings,...

Um, lot of factors. I wouldn't say the I/O subsystem is bad. All the wait means is that it's waiting for the drive to send it data. ...

jbalbo (1/29/2013)

---

yes keywords etcc..

I did write a small view then created a job then creates a table from the view

Since its a report server I can run the job...