310 reputation
210
bio website schoolofficepro.com
location United States
age 40
visits member for 2 years, 9 months
seen Apr 1 at 14:13

School Office Pro.

We provide web based applications for schools to enable online registration, ecommerce, hr, surveys, mass email broadcasting and more.


Mar
19
comment At what point does one database per client become unfeasible?
You might read this, specifically note the dates and the ops comments: stackoverflow.com/questions/5596755/…
Nov
28
awarded  Popular Question
Oct
11
awarded  Popular Question
Aug
23
comment DBCC checkdb showing failure after a restore
I ran the repair_allow_data_loss option, then I simply deleted all the remaining records out of that table. After running dbcc checkdb again it came back and said all was good.
Aug
23
accepted DBCC checkdb showing failure after a restore
Aug
23
asked DBCC checkdb showing failure after a restore
Dec
10
comment Pivot rows into multiple columns
This worked. THanks
Dec
10
accepted Pivot rows into multiple columns
Dec
10
comment Pivot rows into multiple columns
BTW, I have to use the OPENQUERY syntax. The tables have oracle timestamps which prevent me from hitting them directly. The error code is ORA-00933
Dec
10
comment Pivot rows into multiple columns
When I tried to exec this across the linked server I get an error about sql command not properly terminated
Dec
10
asked Pivot rows into multiple columns
Sep
24
awarded  Commentator
Sep
24
comment Select statement is locking a record
I guess I'm confused as to why the row would be locked to begin with. The select goes first, then the update. Also, even if it was locking against writes, why the delay? The first transaction is purely a select. So I would expect any locks obtained to be released when the transaction is done.
Sep
24
asked Select statement is locking a record
Aug
28
comment “lock request time out period exceeded” Error When Trying to See DB Hierarchies
Based on your comment to my answer below, I think you need to provide a lot more information. How is the server sized, have you watched it's performance counters, is it swapping to disk or otherwise resource starved in some way. Be sure to actually check the above and not just assume anything. Further, does this happen when you connect while remoted into the desktop? Is the problem only occuring when accessing from a single location? What is the network weather like for that server (and your connection to it)?
Aug
28
comment “lock request time out period exceeded” Error When Trying to See DB Hierarchies
@LloydBanks: That doesn't mean this isn't a hardware problem. If I have 2 databases, one that's 20GB in size with a high transaction rate and another that's 1GB with a lower transaction rate then I'd expect the 1GB db to be swapped to virtual memory; which would increase query times. If the 20GB db was being hit hard enough, this could lead to connectivity issues with the smaller one.
Aug
28
answered “lock request time out period exceeded” Error When Trying to See DB Hierarchies
Jun
30
awarded  Yearling
Jun
8
awarded  Constituent
Jun
8
awarded  Caucus