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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2013 at 1:22 am
jblovesthegym (4/18/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2013 at 12:58 am
tony28 (2/14/2013)
Msg...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 15, 2013 at 12:55 am
Yup, exactly.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 14, 2013 at 1:07 pm
Viewing 15 posts - 14,251 through 14,265 (of 49,552 total)