Geeks With Blogs

News
The Wrecking Bawl Destructuring query language, one keyword at a time.
I started getting timeouts from SSIS 2012 using the SSISDB and I couldn't make any sense of them, they seemed random. When things were bad I couldn't even expand the Integration Services Catalogs node in SSMS. Just by sheer luck I figured out the problem: too much data was being logged in SSISDB and the data file was up to 180 GB, with the log file ......

ERROR: cannot execute DELETE in a read-only transactionI kept getting errors like that but I didn't think anything had changed with my company's PostgreSQL installation. It turned out that there was a VIP that got applied to a secondary server (slave perhaps, made it a duplicate VIP) so nine times out of ten I was hitting the wrong server. I hope this ......

I had an SSIS 2008 package that copied new/changed data from the production database to an archive database every 2 minutes using Change Tracking, a staging database, etc. The package was stored in the SSIS repository in the SQL Server 2008 instance where the archive database was stored. I upgraded the package to SSIS 2012 and deployed it to the SQL ......

My Droid Razr was driving me crazy with how slow it was to respond most of the time and how quickly the battery would get drained. I finally gave in and did a hard reset on it, which was a little annoying because I thought my apps would get restored and they didn't, but I'm very glad I did it. My phone can finally make it most of the day without being ......

Today I got an error in Access 2013 saying "Cannot open database ''. It maybe not be a database that your application recognizes, or the file may be corrupt."After doing some digging I figured out that Access 2013 has a database limit of around 2 GB, so when I was trying to import data that would push me past that limit, instead of giving me a useful ......

Ever have to create insert statements for a SQL Server table but can't figure out how to do so without hitting a character limit?  The only way I found (with rows that are over 50,000 characters) was to use sqlcmd with the -y parameter set to 0.

Want to create a SQL Server query using a table created at runtime that just has month numbers and year numbers? I did, so here's how I did it:DECLARE @StartDate datetime = '9/1/12', @EndDate datetime = '8/1/13'CREATE TABLE #cal (TheYear int, TheMonth int)INSERT #calSELECT YEAR(dateadd(month, number, @StartDate)), MONTH(dateadd(month, number, @StartDate))FROM ......

I was getting the error below when trying to deploy to my SQL 2008 R2 cluster, which was odd since I had never had any trouble before. The problem ended up being that when I double clicked on the SSISDeploymentManifest file my computer was using the SQL 2012 version of the deployment utility because I had recently installed it. Once I used the 2008 ......

Statistics for INDEX 'IX_DWOrderStatus_DWDateEnd... ......

I got this message from the 2012 version of the console after installing the Power Tools found here:
http://visualstudiogallery.msdn.microsoft.com/b1ef7eb2-e084-4cb8-9bc7-06c3bad9148f

The problem was that I was not a sysadmin in the SQL instance, once I fixed that the error went away.


Ever wonder why when you click on the green line in SSIS the Data Flow Path Editor doesn't actually let you edit anything?  I did.  Then I realized I needed to make the changes I wanted in the source task by right-clicking it and selecting Show Advanced Editor.

Today I got an exception in a report using SQL Server Reporting Services 2008 R2, but only when attempting to go to the last page of a large report: The report execution sgjahs45wg5vkmi05lq4zaee has expired or cannot be found.;Digging into the logs I found this:library!ReportServer_0... e ERROR: Throwing Microsoft.ReportingServices... ......

For anybody getting an arithmetic overflow error in Microsoft.Data.Schema.TSqlT... in Visual Studio 2010, what resolved the problem for me was deleting the schema comparison file in my database project and then getting it from TFS again. I guess it must have been corrupted somehow. UPDATE: That only worked temporarily, the error came back when ......

In case anyone is storing their files as blobs in SQL Server and is interested in the best way to export them, check this out:http://stackoverflow.co... ......

I have two Great Plains databases, let's call them DB1A and DB1B, that are schematically identical and the data is 99% identical but DB1B has a tiny bit more data. I'm trying to optimize a very complex query that uses views nested in views and is way too long to post all of here. The query was averaging 1 min 43 sec before I started. I noticed that ......

Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net | Join free