Viewing 15 posts - 55,906 through 55,920 (of 59,067 total)
Understood. Me? I export the data to a file and zip it so it won't be a duplication of data in the database.
Works kinda the same way with images... if a...
July 3, 2007 at 6:13 am
There may be some normal "healthy" blocking going on... you sure these are "deadlocks" (found in the SQL Server log) and not just blocking?
July 3, 2007 at 5:51 am
Not in SQL Server 2000, you can't... this IS an SQL Server 2000 forum, ya know? ![]()
July 3, 2007 at 5:45 am
Sorry, Chris... lost track of this thread...
Specifically, what statement gave you that error?
July 3, 2007 at 5:42 am
Just a suggestion...
When someone gives you an example... don't just take it at 100% face value... it's just an example. When someone suggests something new to you, like QUOTENAME, take a...
July 3, 2007 at 5:31 am
Use the SELECT to find out... doesn't matter how much time it takes... it's far better to know ahead of time than fixing "risky data" or having a large rollback...
July 3, 2007 at 5:27 am
Heh
No... it is a tera-byte database with a lot going on, though. Web users, billing, invoicing, new customers, Dunning runs, 4 million + new CDR's...
July 3, 2007 at 5:21 am
heh... you also bring up another great point... (maybe not intentionally)... If you do like you say with WHERE field <> '', it will inherently NOT find nulls because nulls...
July 2, 2007 at 11:31 pm
Spot on, Vladan...
July 2, 2007 at 11:15 pm
So you can't limit the query by level and tree branch on a single click?
July 2, 2007 at 11:11 pm
Minh...
There's about a thousand posts on this subject on this forum... search for "concatenation".
July 2, 2007 at 11:09 pm
Nope... I break XML into the appropriate parts and store it as normalized data. ![]()
July 2, 2007 at 7:59 pm
Heh... not supposed to have "gremlins in file systems", Mark. ![]()
Do you also store XML in Text columns?
July 2, 2007 at 5:03 pm
Is the call to the view in an explicit transaction that updated one of the tables in the view?
July 2, 2007 at 4:47 pm
Doh! Came up as an "active" thread and didn't even think of checking the original date
... thanks for the heads up, Ken .
July 2, 2007 at 4:44 pm
Viewing 15 posts - 55,906 through 55,920 (of 59,067 total)