Viewing 15 posts - 14,671 through 14,685 (of 49,552 total)
Can you post the table definition and all index definitions for dbo.order?
January 23, 2013 at 7:04 am
Personally I'd go for either consolidating databases onto fewer instances or consolidating physical machines into virtual machines on a single powerful server. Multiple instances on a single machine, not my...
January 23, 2013 at 6:54 am
sp_changedbowner:
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this...
January 23, 2013 at 6:23 am
bugg (1/23/2013)
Hi Anthony, I don't have any deadlock XML in my error log but i do have the information above just broken up into lines.
That's a deadlock graph. 2 actually,...
January 23, 2013 at 6:18 am
Mostly.
You can restore the full, then any log backups. However, what happens if that full is damaged and won't restore? If you've deleted the log backups prior to it, then...
January 23, 2013 at 12:50 am
You can check the default trace. It logs DDL along with the login. If enough time has passed that the event is not in the default trace, there's likely no...
January 23, 2013 at 12:48 am
1) Included with the database backup and the all log backups that occur while it's running
2) Included with the database backup and the all log backups that occur while it's...
January 23, 2013 at 12:04 am
Cache store flush is not going to cause any problems with a restore. Other way around, restoring a database will flush the caches. It's not an error, just SQL notifying...
January 22, 2013 at 11:45 pm
Sean Lange (1/22/2013)
ScottPletcher (1/22/2013)
DiverKas (1/22/2013)
2) Do NOT let your DBA's design the database.
3) Hire a Data Architect.
Just saying. The first...
January 22, 2013 at 1:25 pm
LAW1143 (1/22/2013)
might this have anything to do with the datatypes of the index columns?
No. Nothing strange about bigint columns.
Just checking... You are rebuilding the same index that you're checking (same...
January 22, 2013 at 1:03 pm
Robert Davis (1/22/2013)
There must simply not be enough contiguous free space for it to rebuild it unfragmented.
I've seen indexes rebuild fragmented before, but never this bad.
January 22, 2013 at 12:29 pm
LAW1143 (1/22/2013)
its a link to my dropbox, but understand your hesitation. dont have another place handy to stick that image at the moment, so sorry...
btw, you can attach images...
January 22, 2013 at 12:27 pm
You have autoshrink on by any chance?
btw, you can attach images to the posts. I'm not clicking on an obfuscated link that could go anywhere.
January 22, 2013 at 12:21 pm
sqlfriends (1/22/2013)
for the 3 rd one, I usually...
January 22, 2013 at 11:28 am
Viewing 15 posts - 14,671 through 14,685 (of 49,552 total)