Good Lord.... Do you have a blocking problem? What's your symptoms? DON'T USE (NOLOCK) It's probably the fastest way to hose your database...
I don't know...I kinda agree with #2..though it depends on the size...I might substitute "copy" with bcp.... It's bee shown in at l;east 2k, that...
I'm not even gonna go there...... Brett 8-) Hint: Want your questions Answered Fast? Read Below...
You need to post the DDL...read the link in my sig Brett 8-) Hint: Want your questions Answered Fast? Read Below...
BOL say they are the same. Ever look at INFORMATION_SCHEMA.Columns? Brett 8-)
SELECT REPLACE(CONVERT(Varchar(10),GetDate(),101),'/','.') Brett 8-)
Is that 1500 just on this board? Or can I combine my miles? Brett 8-)
Make a copy? Brett 8-)
What are you doing? You store the same value in different columns? Are you overloading the columns? In the old query the last 2 unions look...
Anyone want to say "don't use select *" Sure for testing and concepts, but never for prod Brett 8-)
I still want to know the business reasons behind this, since I can't even see a reason... Just sounds like a problem waiting to happen.......
Or you could populate a replacement value table, and do a replace join where the value exists SELECT REPLACE(Col1,OldValue,NewValue) FROM myTable99...
For the life of me..... Anyone want to hazard a guess as to what's going on. Derrick, when would you EVER do this? Brett 8-)
Wish him luck in his new job? Brett 8-)
I would have 2 tables. One for current activity...one to roll messages n days older too... Don't "move" any data. Keep status columns...maybe an...
DBA Deliver Bull**** app That delvelopers wrote...because it won't run now.... Brett 8-)
quote:Originally posted by v1rtu0s1ty Hey guys, I'm 3 months old now with doing some select, insert, update adhoc queries. What does your mommy...
SELECT 'Brett'+CHAR(13)+CHAR(10)+'KAISER' Brett 8-)
Was it mentioned anywhere what the size of the dumps are? Brett 8-)
Hey derrick....you get around... In a WHERE Clause it would most likely cause a scan.... What about in an ORDER BY though? Brett 8-)
Separate names with a comma.
