Viewing 15 posts - 14,791 through 14,805 (of 49,552 total)
The SQL Server binaries are on a disk that you intend to replace?
Uninstall. Reinstall.
Backup/restore all databases (don't forget the system ones), or detach/attach (and backup/restore the system ones that can't...
January 15, 2013 at 10:25 am
Print the command (rather than executing it) and see what it returns.
January 15, 2013 at 8:19 am
Abu Dina (1/15/2013)
4) A week later...
January 15, 2013 at 6:55 am
drew.georgopulos (1/15/2013)
January 15, 2013 at 6:27 am
winmansoft (1/15/2013)
But shrinking the log file will increase fragmentation ryt?
No.
So is it good habit to shrink the log file?
Not regularly, no.
January 15, 2013 at 6:10 am
Jayanth_Kurup (1/15/2013)
@Gail , would it make sense now to add a clustered index or rebuild the clustered index ?
No, it will fail.
Are you able to access the table , can...
January 15, 2013 at 5:47 am
jitendra.padhiyar (1/15/2013)
January 15, 2013 at 5:47 am
jitendra.padhiyar (1/15/2013)
DELETE FROM PTPortalUser.PTJOBLOGS WHERE INSTANCEID < 614469
and got error message:
Msg 8908, Level 22, State 6, Line 1
Table error: Database ID 23, object...
January 15, 2013 at 5:45 am
jitendra.padhiyar (1/15/2013)
Ohh.. Is there any way to know how much data lost? Or how to find what table affected by that ?
How much, no, not after the fact. Which table,...
January 15, 2013 at 2:49 am
Err... Joie asked you to run CheckDB with no_infomsgs, not CheckDB with the repair allow data loss option specified. Do you have any idea what data was lost when you...
January 15, 2013 at 2:28 am
A unique index is required if the table is to support net changes as well as all changes
http://msdn.microsoft.com/en-us/library/cc627369%28v=sql.105%29.aspx
A capture instance will always include a table valued function for returning all...
January 15, 2013 at 2:20 am
Index pages are 8kb, like all other pages in SQL.
http://www.sqlservercentral.com/articles/Indexing/68439/
January 15, 2013 at 1:19 am
Please read through this - Managing Transaction Logs[/url]
If the log file has grown too large, a once off shrink to bring it back to normal size is fine. Log backups...
January 15, 2013 at 1:17 am
sej2008 (1/14/2013)
Would like to know whether DCL and DDL statements are logged in sql log file before hardening on data file?
DCL?
All modifications to the database are logged first before the...
January 15, 2013 at 1:16 am
Viewing 15 posts - 14,791 through 14,805 (of 49,552 total)