Viewing 15 posts - 10,276 through 10,290 (of 49,566 total)
djackson 22568 (1/23/2014)
Jim P. (1/23/2014)
Steve Jones - SSC Editor (1/22/2014)
January 23, 2014 at 2:44 pm
Dennis Post (1/23/2014)
It's been a week now.NOLOCK hint did the trick.
No more deadlocks with this process.
No dirty read issues.
If you have nolock, then you have the potential for dirty...
January 23, 2014 at 6:25 am
Whoops... http://www.sqlservercentral.com/Forums/Topic1533954-391-1.aspx
Anyone with TDE experience that can assist?
January 23, 2014 at 4:16 am
arrjay (1/23/2014)
Thanks for this. If I have dropped the certificate, would it be possible to then unencrypt the databases which are still attached to the server?
No idea....
January 23, 2014 at 4:15 am
THE-FHA (1/23/2014)
Hi,Could index fragmentation have also have an impact on this problem?
No. The size of the log backups is a function of the changes to the database over the period...
January 23, 2014 at 3:33 am
Was the database encrypted with transparent database encryption? If so, then without the certificate you won't be able to reattach the DB. Deleting the certificate would not have unencrypted the...
January 23, 2014 at 3:30 am
lianvh 89542 (1/23/2014)
January 23, 2014 at 3:26 am
Again, your client application is running out of memory, probably due to the large result set. This is not a SQL Server error message, it's coming from whatever .net client...
January 23, 2014 at 3:24 am
You can prevent all failed logins from writing to the log, but not one specifically
January 23, 2014 at 2:50 am
If the log backups are too large, either reduce the amount of changes happening in the DB (usually not practical) or take log backups more often.
January 23, 2014 at 2:49 am
You're running the client application out of memory. That's not a SQL Server error message.
January 23, 2014 at 2:48 am
sql-lover (1/22/2014)
WHERE session_Id > 50 -- Ignore system spids.
Careful, spid < 50 indicating a system process hasn't been true since SQL 2000.
January 23, 2014 at 2:47 am
JustMarie (1/22/2014)
GilaMonster - I'm talking about the 2012 SEQUENCE object type.
In that case, Kraig's comments on contention don't apply, he was talking about the practice of creating a table usually...
January 23, 2014 at 2:46 am
lianvh 89542 (1/23/2014)
Thank you for the feedback. There was a business requirement for the concatenated clustered index.
Why? Business requirements shouldn't specify the indexing locations and types, that's a technical detail,...
January 23, 2014 at 2:44 am
steve.neumann (1/22/2014)
..."and possibly impress someone else...
January 23, 2014 at 2:42 am
Viewing 15 posts - 10,276 through 10,290 (of 49,566 total)