Saturday, May 11, 2013

[SQL Server 2008 issues] restored database failed

SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General

[SQL Server 2008 issues] restored database failed

restored database failed

Posted: 10 May 2013 06:53 PM PDT

I recently stored SQL Server 2012 on my pc but when I tried to restore any data base it gives me this error:ADDITIONAL INFORMATION:System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\GVApp.mdf'. (Microsoft.SqlServer.SmoExtended)

Difference between Lazywriter and checkpoint

Posted: 18 Jan 2011 05:18 PM PST

I am trying to understand the difference between lazy writer and checkpoint.If Lazywriter is supposed to "age out" dirty pages from data cache to the disk then what does checkpoint do ?As per my understanding It is when the Lazywriter decides to flush the dirty pages to the disk that checkpoint occurs or are they two totally different processes?If yes then can anyone please explain the difference?And if they are same then does lazywriter also has the additional responsibilty of writing the pages log modified to the Tlog file?

SQL Condition for SSRS multi select parameters

Posted: 10 May 2013 12:31 PM PDT

Hi All,I can't figure out the best way to implement this..so here is my simplified table:[code="sql"]declare @tbl table(Id int identity (1,1), Para varchar(200), ParaType varchar(150))insert into @tblselect 'Paragraph1...', 'Type1,Type3,Type4' union allselect 'Paragraph2...', 'Type1,Type3' union allselect 'Paragraph3...', 'Type1,Type3,Type5' union allselect 'Paragraph4...', 'Type3,Type4' union allselect 'Paragraph5...', 'Type1,Type2,Type3,Type4' union allselect 'Paragraph6...', 'Type3,Type5' union allselect 'Paragraph7...', 'Type4,Type5' union allselect 'Paragraph8...', 'Type3,Type5' union allselect 'Paragraph9...', 'Type5' union allselect 'Paragraph10...', 'Type1,Type5'select * from @tbl[/code]Each type is one check box (in a drop-down) on my SSRS report which lets the users select multiple types.So if user selects Type2 and Type4 I would expect to see strings that have Type2 or Type4 words in them:[code="sql"]select 'Paragraph1...', 'Type1,Type3,Type4' union allselect 'Paragraph4...', 'Type3,Type4' union allselect 'Paragraph5...', 'Type1,Type2,Type3,Type4' union allselect 'Paragraph7...', 'Type4,Type5'[/code]Used Jeff's splitter but not sure where to go from there. Thanks.

I know which *file* is being hammered -- how do I find out *who* is doing the hammering?

Posted: 10 May 2013 11:18 AM PDT

I have a production SharePoint system with about 100 databases, it just got really slow, users are complaining a lot.When I run a query against [b]sys.dm_io_virtual_file_stats[/b] and sort by [b]num_of_bytes_read[/b], one file has [i]massively[/i] more Reads than any other -- it shows [b]75 TB[/b]! (yes, I double-checked!) It is [b]SharedServices_Search_DB.mdf[/b], so I know exactly which file is causing the problems. The SAN guy says yes, that LUN is swamping the entire SAN with Read requests.So how do I find out what application, or what process, or what procedure, or what service account is actually causing all these Reads?Doing this type of performance analysis is my weakness. :( Are there scripts I can run that will answer the question: This one file has a huge number of Reads, and those Reads are caused by X"?Any help much appreciated!

code folding in ssms?

Posted: 10 May 2013 06:37 AM PDT

Hello - What are some techniques you use for code folding in SSMS? For example, in Visual Studio you can add regions like this:#region Protected Methods//some code here
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog