Hi.

A primary key uniquely identifies a row within a table and as such you are only allowed one primary key. In relational theory there can only be one key...

If you're not on the latest service pack then the reports are viewable from the summary tab in ssms. Select the summary tab, select a database and then the...

Gerald,

You seem to be along the right track.

Looking at the innner query (the one with the case statement) that looks spot on except for the syntax at the beginning, where...

No...

I should point out that my method will not return correct results for tables with XML indexes or full text indexes, whereas Adam's method will return correct results. But...

Try this - results are in kb:

select...

Hi Todd,

I do it pretty much through SQL can't say that that's the best method though but it works for me. I create a couple of temp tables in...

Edward,

Unfortunately you cannot specify a new fill factor for an index during a defrag operation. You'd need to to a rebuild for that.

Hi Dan,

It doesn't make a difference which order the where clause is written in. So as long as it's logically the same you're ok.

Balakrishnan K (3/18/2008)

---

Hi all,

Gladly welcome your advices / suggestion to have in mind before truncating log file of a Replicated database running under Merge replication. I need to truncate the...

Did you update statistics when you upgraded to SQL 2005?

Check out the execution plans on both servers and see if they're different (assuming you have access to the SQL 2000...

nitin.b.gupta (3/5/2008)

---

Hi,

One of our application uses huge amount of memory for retrieval of data from database for application use only and perform lot of manipulation on it at that time...

When you run it in query mode, what are you typing in for the date? Also, make sure you don't put quotes (single or double) around the date you...

I think this might work better (at first glance anyway):

SELECT AD_NAME,AD_Image AS AD_HH_IMAGE

FROM TBL_AD_MASTER AS ADM

INNER JOIN TBL_WORK_ORDER_DETAIL AS WODTL ON WODTL.Ad_Key=ADM.Ad_Key

INNER JOIN TBL_WORK_ORDER_HEADER AS WOHDR ON WOHDR.WO_Hdr_Key=WODTL.WO_Hdr_Key

WHERE WODTL.TASK_SURR_KEY...

you could do this:

declare @subject nvarchar(510)

set @subject = @NewUserFN + ' ' + @NewUserSN + ' has registered on the website'

Then, when you call xp_sendmail you do this:

EXEC master..xp_sendmail

...