Telephone Number BigInt??????

Really?????

I would use varchar(30) and a proper CHECK constraint, instead.

Not trying to be rude, but Google returns quite interesting results on the very first page:

http://www.google.com/search?q=sql+server+xml+compression+best+practices

Does any of those fit your needs?

"aa" is the only table identifier on this query, so I guess this should do:

UPDATE aa

SET ps_vir = 1

WHERE cpd_id IN ( '1-1WJ-456', '1-14M-618' )

AND aa.pt_psp_pk = 1

If the two database have to actually "talk" to each other, you need to use one among:

1) Linked Servers

2) Ad-hoc datasources (OPENROWSET, OPENDATASOURCE)

3) CLR procedures

4) ETL (SSIS or other similar...

HowardW (2/28/2012)

---

Other than that, you may be hitting an edge case where SQL 2000 actually came up with a better plan - these aren't too uncommon, especially when dealing with...

Based on the number of interview questions we see on the forums lately, we could safely say that the IT job market is quite healthier than it used to be...

You can, using REPLACE or some other kind of syntax, given that you can identify what to replace with 'confidential'.

You would have to tokenize the input string and identify the...

As I asked in the other thread: why not using linked servers?

Out of curiosity: why no linked servers allowed?

Compare the execution plans and everything will be much clearer.

If SQL Server is not using all the available memory, probably it doesn't need to.

I suppose you increased the max memory because you clearly identified a memory bottleneck, right?

GRANT VIEW DEFINITION TO BOB

Did you check the "Exclude rows that do not contain values" box?

punna (2/28/2012)

---

hi,

1.how to know the log size of a table after removing some records from a table??

2.My table have 1,00,000 rows,if i removing some records using delete command the...

Here's a quick test that confirms my initial idea.

-- YOU HAVE A TEST DATABASE, DON'T YOU?

USE TEST

GO

-- SETUP

CREATE TABLE testDestination (

longString nvarchar(max)

)

GO

-- PROCEDURE THAT DOES SOMETHING WITH THE PARAMETER

CREATE PROCEDURE...