Friday, May 31, 2013

[SQL 2012] Log file continues to grow after backup (full recovery mode)

[SQL 2012] Log file continues to grow after backup (full recovery mode)

Log file continues to grow after backup (full recovery mode)

Posted: 31 May 2013 02:07 AM PDT

I recently upgraded to SQL Server 2012 from SQL Server 2005. The database is in full recovery mode and I take full backups nightly and transaction log backups hourly. However, the transaction log is not being shrunk after backup and continues to grow daily. Switching the database to simple recovery and running DBCC Shrinkfile will reduce the file size. However, the issue continues after the database is back in full recovery and log backups are taken. Has anyone experienced this issue?

Questions on installing a PowerPivot for Sharepoint instance in a cluster

Posted: 31 May 2013 02:25 AM PDT

Hello all,Still reading through documentation; however have some quick questions (for now) on how to properly setup a Sharepoint instance for PowerPivot. Short version is that we have a multi-node, multi-instance cluster in which we host several different database instances. One in particular is purely for our Enterprise SharePoint. Now that we're moving to SQL 2012 and SharePoint 2013, I'm a bit confused on a couple of key pieces.1) Does the SSAS instance reside with the database instance, or the Sharepoint application server?2) If using SSRS integrated mode on the database instance, I can still have the SSRS application end live on it's own server correct?3) Heading to lunch, will come back to this as I'm drawing a blank at the moment.Thank you

Update query with right([xxx],2) changes varchar to smallint

Posted: 31 May 2013 12:58 AM PDT

This shouldn't be that hard.My situation. Working with addresses on a map. Some of the addresses will be the full length. 4 or 5 characters that are numbers but reside in a varchar column. One column contains the number of characters(numbers) I want presented. For example, think of a row of townhouses. I want both ends to show the full address i.e. 9900 to 9908. The inner addresses will only have two i.e. 02, 04, 06, 08. My query will show apartment numbers, but that isn't a concern.My query:UPDATE [Parcels].[tbl_Address_Basic] SET [FONT_TEXT] = CASE WHEN [FONT_NUM] = 9 THEN [APPT_NUM] WHEN [FONT_NUM] = 4 or [FONT_NUM] = 5 THEN [ST_NUM] WHEN [FONT_NUM] = 2 THEN RIGHT([ST_NUM_TXT], 2) ENDProblem: After update, the column only returns 2,4,6,8 instead of 02,04,06,08. 9900 would return 0. ST_NUM is small int and I thought that was the problem, so I created ST_NUM_TXT which is varchar(10). Same result. I've tried casting and same thing. I tried right('0' + [ST_NUM_TXT], 2) and same thing. I tried ('a' + [ST_NUM_TXT], 2). I know, I know, but I was out of ideas. I received the error: "Conversion failed when converting the varchar value 'a00' to data type smallint". I've tried casting on the inside and outside. I'm out of ideas. BTW, FONT_TEXT is varchar(10). Any help would be appreciated.Monte

Help on performance issues using SQL Server 2012

Posted: 30 May 2013 10:03 PM PDT

Hi,I need help on performance issues with our new database server using SQL Server 2012. A migration was done over the weekend. And we moved several databases to a new data center. Now the ERP system is slow and users cannot get their work done.I created a reindex and reorganize scripts, we were using a job but that was taking too long and failing. I ran a fragmentation analysis and using a threshold of 20% for reindexing and everything else reorganize. This enable the job to complete. However the performance is still awful. The database server shares multiple databases, one of the recommendations I've made was to have a dedicated server for the ERP system.There is an audit trail file that hasn't been purged in about 10 years. Could this be the reason for this bad performance. It's affecting all systems pointing to this database server.I didn't have a say in this decision - Now the business is ticked.Any help would be greatly appreciated. And if none if this works we need to migrate back to SQL Server 2005.

Open SSMS 2012 using RUN window

Posted: 30 May 2013 09:52 PM PDT

Hi,Just want to know what shortcut can we use to open SSMS 2012 as,we are using RUN(window + R) --> SSMS for 2K8

SQL Query autoformating

Posted: 30 May 2013 03:42 PM PDT

Hi all, There are many third party tools available in market to format your SQL queries. If you are using any of these tools then can you please share your experience. Which tool is better?

Parsing huge XML file into a database table using sql server

Posted: 30 May 2013 05:39 PM PDT

I tried to parse a huge xml file using sql server (OPENROWSET) into a database table, but got an error that says duplicate attributes (author). The author column varies for each article, ranging from one author to upto six authors. The columns I am really interested in are author, title and journal. Below is a snippet of the xml data. Any suggestions will be highly appreciated. Thanks in advance.<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE dblp SYSTEM "dblp.dtd"><dblp><article mdate="2002-01-03" key="persons/CoddD74"><author>E. F. Codd</author><author>C. J. Date</author><title>Interactive Support for Non-Programmers: The Relational and Network Approaches.</title><journal>IBM Research Report, San Jose, California</journal><volume>RJ1400</volume><month>June</month><year>1974</year></article> </dblp>

Kerberos on SQL Server 2012 Reporting Services Sharepoint integrated

Posted: 26 Apr 2012 02:07 AM PDT

Hi.I have sharepoint 2010 installed and SQL Server 2012. With SQL 2012, if using reporting services in sharepoint integrated mode there is no longer a Reporting Services Service, instead it is fully integrated into sharepoint.This unfortunately leaves me with no idea how to enable kerberos for reporting services when using SSRS 2012 in Sharepoint integrated mode.Any info i can find is for SSRS 2008 and Sharepont, not SSRS 2012 and sharepont.Can anyone advise what needs to be done here to ensure im using kerberos?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog