Viewing 15 posts - 14,251 through 14,265 (of 49,552 total)
tony28 (2/15/2013)
hmm, but after this I can do query and etc...
Maybe, but what you did is NOT the way you fix that 'error' (which had nothing to do with...
February 15, 2013 at 10:16 am
Error 802 is "Insufficient memory in the buffer pool", which suggests there's insufficient memory.
Probably too much done in that job and not enough memory allocated (or incorrect VM settings)
February 15, 2013 at 10:02 am
tony28 (2/15/2013)
I solved it yesterday yet, i deattached DB and then attached and recovery..
That is NOT how you solve a full transaction log.
February 15, 2013 at 9:45 am
Even if you put a unique constraint on the identity column, it won't (afaik) be enough. If the clustered index is unique, the clustered index should be created with the...
February 15, 2013 at 9:42 am
It's there because the clustered index wasn't defined as UNIQUE. SQL can't intuit or guess that the columns are unique or not, so unless the clustered index is created with...
February 15, 2013 at 7:37 am
dsachu (2/15/2013)
still waiting for response....
I read the post this morning, didn't have time to reply. Was going to reply now, but have paying work to do instead.
We're volunteers. We post...
February 15, 2013 at 7:23 am
Kwisatz78 (2/15/2013)
I had thought that any uncommitted transactions would only have been held in memory
Nope. There's no requirements that uncommitted transactions not be written to disk, they can be, they...
February 15, 2013 at 7:19 am
My general rule is if it is filtered on and can be part of a seek, then it goes in the key. No sense in making SQL do more work...
February 15, 2013 at 2:08 am
Jason-299789 (2/15/2013)
in 99% of cases is probably going to be part of the INCLUDE part of the index, as BIT fields tend to be used for filtering.
If the bit column...
February 15, 2013 at 1:23 am
Yes, you can. Impact depends on whether it's useful for queries, where it is in the index and a whole lot more.
February 15, 2013 at 1:22 am
jblovesthegym (4/18/2012)
February 15, 2013 at 1:01 am
kapfundestanley (2/14/2013)
Yes I did put it from suspect mode.In order to run dbcc checkdb.
General rule, if you want help with a corrupt DB, tell the entire story, not a portion...
February 15, 2013 at 12:58 am
tony28 (2/14/2013)
Msg...
February 15, 2013 at 12:55 am
Yup, exactly.
February 14, 2013 at 2:22 pm
How are you inserting from SSIS? If using one of the bulk load options, have you set 'fire triggers' property on?
p.s. Is hardcoding an OrderID in the trigger going to...
February 14, 2013 at 1:07 pm
Viewing 15 posts - 14,251 through 14,265 (of 49,552 total)