Monday, August 26, 2013

[SQL Server 2008 issues] DBCC checkdb lifecycle

[SQL Server 2008 issues] DBCC checkdb lifecycle

DBCC checkdb lifecycle

Posted: 25 Aug 2013 07:06 PM PDT

I first ran DBCC CHECKDB on an instance. It threw away around 2000 consistency errors.I ran repair_rebuild and it didn't fix any errors.Then I ran dbcc with REPAIR_ALLOW_DATA_LOSS and it fixed around 1900 consistency errors.I switched DB into multi user mode again and am running checkdb again.is there a way I can fix the remaining 100 odd errors?

Help On Query

Posted: 25 Aug 2013 06:53 PM PDT

Hi Everybody,I'm looking to import an excel file to sql server. Excel file having password.Is there any way to query the password protected excel files.Hope that distributed query will help me out.Please advise.Thanks

Log LDF file

Posted: 13 Aug 2013 07:25 PM PDT

I came to know that some records are deleted from Table in SQL SERVER 2008...We want to track it & see what happened & who deleted :w00t:No log backup is taken.. only LDF file is there which is almost 5GB now..please suggest how will i be able to read the LDF file to track the operation done yesterday when records were deleted :w00t:Please help its urgent.. Client need answer :crazy:

IP Restriction Feature

Posted: 25 Aug 2013 05:01 PM PDT

There should be a feature in database to allow only certain IPs to delete the data. Can we keep a log of the ip address when a record is deleted will help. Is their any solution for this.. please revert your expert advice:-)

Identify the size of my data cache in sql server

Posted: 19 Oct 2011 09:39 PM PDT

How do i check the size of the datacache allocated from the buffer pool by sql server?I appreciate this may be opening a can of worms, but if someone can advise on dmv or anything to show me the pool allocation sizes for the various pools in sql server i think i may be able to work from there.

Internal database snapshot

Posted: 25 Aug 2013 02:57 PM PDT

I ran dbcc checkdb on databases and noticed the following message: Internal database snapshot has split point LSN = 00000012a:00000222:0001 and first LSN = 00000012a:00000221:0001.what does this signify?

String to date conversion issue

Posted: 25 Aug 2013 09:53 AM PDT

Users of our app currently store date values in the following format:[b]Mon. dd, yyyy.[/b]Example: [b]Sept. 23, 2013[/b]We would like to convert these date values to MM/dd/yyyy, eg, 9/23/2013 and the code below does just that.[code="sql"]SELECT CONVERT(VARCHAR(10), CONVERT(DATETIME, SUBSTRING('Sept. 23, 2013', 0, 4) + ' ' + SUBSTRING('Sept. 23, 2013',6,9), 107), 101)[/code]When we run this code, now, we get above date, for instance, formatted to 9/23/2013.However, the issue we have now is that when we try to update same date value, it stores a different formatted value like:Sep 23 2013 12:00AMNotice that first, Sept. is now Sep which is wrong because t and period (.) are missing.Simply put, when we update a date value, it needs to follow similar format as this -> [b]Sept. 23, 2013[/b]Any ideas how to modify above query to produce similar result when a date value is updated?Thanks a lot in advance
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog