Viewing 6 posts - 106 through 112 (of 112 total)
Paul White (11/8/2009)
dant12 (11/8/2009)
if you're using SQL 2008 you can disable lock escalation on the problematic tables and enforce rowlocking on the table, that should solve the concurrency problem
Not necessarily....
--
Thiago Dantas
@DantHimself
November 8, 2009 at 1:57 pm
if your using SQL 2008 you can disable lock escalation on the problematic tables and enforce rowlocking on the table, that should solve the concurrency problem
if your using 2005 you...
--
Thiago Dantas
@DantHimself
November 8, 2009 at 8:35 am
im not responsible for the app that does the importing, all i know is that it calls bcp but im not sure on the parameters passed and how it imports...
--
Thiago Dantas
@DantHimself
November 8, 2009 at 3:52 am
according to your script one of my tables has 440 MBs but SSMS says it has around 46 MBs
u sure u did the math right?
--
Thiago Dantas
@DantHimself
July 2, 2009 at 1:24 pm
ah, yes.
pasted it in notepad and got to see it
quick replace fixed it
--
Thiago Dantas
@DantHimself
July 2, 2009 at 1:18 pm
For some reason I'm getting loads of "Incorrect syntax" errors while trying to compile this
edit:
what version of SQL were you using to write this?
--
Thiago Dantas
@DantHimself
July 2, 2009 at 12:37 pm
Viewing 6 posts - 106 through 112 (of 112 total)