Paul White

Forum Replies Created

Viewing 15 posts - 1,186 through 1,200 (of 8,416 total)

RE: Count fields that do not meet specified condition

That's great news. I'm short of time right now, but I'll be back later to have a closer look (unless anyone else wants to chip in). In the...

January 12, 2012 at 9:21 pm

#1432992
RE: Get Max Value from Linked Table

That's very kind of you. The main syntax element there is APPLY, for which a reasonable two-part article is available on this site:
http://www.sqlservercentral.com/articles/APPLY/69953/
http://www.sqlservercentral.com/articles/APPLY/69954/

January 12, 2012 at 9:16 pm

#1432991
RE: Get Max Value from Linked Table

SELECT TOP (1000)
IM.PN,
iTVF.DrawNum,
iTVF.RevisionNum,
IM.[Description],
IM.SolidWorksAttribute,
IM.InVantage,
...

January 12, 2012 at 12:29 pm

#1432837
RE: Alternatives to LIKE and FTS for mid name search

poostwoud (1/11/2012)
I have a question about what are the alternatives for LIKE '%%' and Full-Text Search when it comes to searching organisation names, firstnames, surnames, etc.
The LIKE '%%' causes table...

January 12, 2012 at 12:12 pm

#1432829
RE: Timestamp column

svakka (1/12/2012)
Thank you all .My source column has timestamp data type, should I create rowversion, date time data type to hold the same value as in source
This script demonstrates the...

January 12, 2012 at 11:35 am

#1432815
RE: Question for the "experts"

DeanORenO (1/12/2012)
I love this, "read his posts and tear him apart" mentality you employ GSquared.
I would suggest rejoining the site under a new name and starting from scratch with a...

January 12, 2012 at 10:57 am

#1432778
RE: How to move a large table with images to another SQL database and link it.

Dev (1/12/2012)
Yup, I missed that part but not entirely. OP didn’t mention it explicitly but it’s a fair assumption and I agree with you.
edit: Ah! I see:...

January 12, 2012 at 10:33 am

#1432762
RE: Returning a column per date in a range

drew.allen (1/12/2012)
That's exactly my point. Bob proposed the rCTE as a viable solution to the original poster's problem. That is the context. Whether Bob himself has the...

January 12, 2012 at 10:02 am

#1432731
RE: Returning a column per date in a range

Jeff Moden (1/12/2012)
My apollogies... I assumed the same thing becuase of the statement "150ms is not 'significant' in the current context,"
Ok, now you've got me curious again. Do you...

January 12, 2012 at 9:54 am

#1432718
RE: How to move a large table with images to another SQL database and link it.

Dev (1/12/2012)
It could be a hardware issue but my question is still valid. If I query (or backup) on database with images, I shouldn’t expect much performance. OP...

January 12, 2012 at 9:27 am

#1432669
RE: How to move a large table with images to another SQL database and link it.

Brandie Tarvin (1/12/2012)
I think Paul has it right that the OP should consider using a view rather than actually moving the data.
Hello other part of the discussion. I agree...

January 12, 2012 at 9:25 am

#1432662
RE: Slow Query

Cadavre (1/12/2012)
You pointing that out made me remember a SPROC I tuned yesterday at work where I had added a subquery with a TOP and no ORDER BY. Saved my...

January 12, 2012 at 8:52 am

#1432602
RE: Can a computed column be made to read data from a stored procedure

kevin.smith-1067125 (1/12/2012)
It is in relation to another post where we want to move image data to another linked table. We wanted to automatically get the linked data (currently in the...

January 12, 2012 at 8:42 am

#1432587
RE: Quick Opinion on @@ROWCOUNT vs EXISTS

Tom Brown (1/12/2012)
-- Must be very early over there - or are you not in NZ at the moment.
It is 4:26am on Friday 🙂
Live in NZ, work remotely in...

January 12, 2012 at 8:27 am

#1432568
RE: Slow Query

Grant Fritchey (1/12/2012)
Ouch. I didn't catch the date types. Good one Paul.
It's not at all evident from the plan - I only came across it after running the DDL and...

January 12, 2012 at 8:26 am

#1432566

Viewing 15 posts - 1,186 through 1,200 (of 8,416 total)