Five-way crosspost. Please do NOT cross-post.

Conversation should continue over here:

http://www.sqlservercentral.com/Forums/Topic516072-361-1.aspx

Not fully understanding the background on how that...

Guillermo -

Like Grant mentioned - SQL Server Management Suite is not to be used as a front-end for end-users doing data entry.

A few options for you:

1. use Access....

Have you tried the sys.dm_exec_query_plan function? mine doesn't seem to put that annoying notation at the top as to it being unicode.

The other options return the showplan in one...

K. Brian Kelley (6/12/2008)

---

Matt Miller (6/12/2008)

---

- Forget the dev server right now, I'd start by focusing on the transport mechanism. FTP is not secure as a transport,...

Pino -

I didn't describe the saving of the exec plan very well. In SSMS, when you're viewing the actual exec plan, right-click on the exc plan pane (not...

Indianrock (6/12/2008)

---

Our clients are lenders ( Banks and Credit Unions ). A few are using SSNs as the account numbers for loans they make and we store the data....

All right - here's my entry, with some data to test it with:

--test data

declare @date datetime

set @date='01/01/2008';

select top 500 @date+n as date

into #tblDate

from tally

where n<501

--last sunday of the month calc....

Also - DDL = data definition language. Lynn was asking you to include the index definitions in the "create table scripts" (that's one of those options you can set...

pino -

below the main reply area - there's a "post options" section. In there is a button called "edit attachments". Click that to add files.

Most folks tend...

Have you checked out parameter sniffing? I'm kind of inline with what Grant was getting at, where it made some bad choices based on the new stats. There was...

John Rowan (6/11/2008)

---

Also, your WHERE clause of PO.PODescription LIKE '%00000%' will normally produce a table scan. It's a bit hard to say for sure though as you have not...

hehe...I see Barry has better recollection than I as to why the @whereand parameter doesn't work. And - he types faster too!:D

hmm - something...

You're right - that is a good definition. That's kind of what I was getting out of it. Of course - the second thought was - "gee -...