Gail Shaw

Forum Replies Created

Viewing 15 posts - 14,791 through 14,805 (of 49,552 total)

RE: I think I already know the answer but... :unsure:

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

#1577421
RE: Index optimization failed for User databases

Print the command (rather than executing it) and see what it returns.

January 15, 2013 at 8:19 am

#1577362
RE: Size of the ldf file increasing

Abu Dina (1/15/2013)
3) When you check the size of your files you find that the data file has grown to 1GB and the log file 2GB!
4) A week later...

January 15, 2013 at 6:55 am

#1577330
RE: Does Change Data Capture require a table have a primary key

drew.georgopulos (1/15/2013)
Second, NUTS! the requirement of a pk or unique index torpedo's my intention, as the source does not create uniqueness and attempts to create the minimum requirement, a unique...

January 15, 2013 at 6:27 am

#1577306
RE: Size of the ldf file increasing

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

#1577293
RE: Torn page issue

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

#1577283
RE: Torn page issue

jitendra.padhiyar (1/15/2013)
Just googled error message and found this issue occurs because the SHRINK operation cannot remove a page from the SYSFILES1 system table on the primary data file of the...

January 15, 2013 at 5:47 am

#1577282
RE: Torn page issue

jitendra.padhiyar (1/15/2013)
The were trying to perform below delete operation:
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

#1577281
RE: Torn page issue

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

#1577211
RE: Torn page issue

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

#1577204
RE: Does Change Data Capture require a table have a primary key

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

#1577198
RE: tempdb per processor cores?

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

January 15, 2013 at 1:20 am

#1577169
RE: index architecture

Index pages are 8kb, like all other pages in SQL.
http://www.sqlservercentral.com/articles/Indexing/68439/
http://www.sqlservercentral.com/articles/Indexing/68563/
http://www.sqlservercentral.com/articles/Indexing/68636/

January 15, 2013 at 1:19 am

#1577167
RE: Size of the ldf file increasing

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

#1577166
RE: transaction log working

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

#1577165

Viewing 15 posts - 14,791 through 14,805 (of 49,552 total)