Close

Monthly Archives: June 2013

Maximum Request Length Exceeded when Deploying a Model to SSRS

Error “Maximum request length exceeded” in Reporting Services This error came up while trying to upload a 3.9Mb SSRS report to a new SQL 2008 R2 reporting server. Solution: open the web.config file found in: C:Program FilesMicrosoft SQL ServerMSRS10_50.#####Reporting ServicesReportServer #### stands for your instance name Modify line 40 or the line with below: to: […]

Read More

SQL Server 2014

Click here to learn more “Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered in the prior release by providing breakthrough performance, availability and manageability for your mission critical applications. SQL Server 2014 delivers new in-memory capabilities built into the core database for OLTP and data warehousing, which complement our existing in-memory data warehousing […]

Read More

Truncate Requires Control Rights

Below is an output from a sql login session, the sql login account has select permissions, and attempts to truncate [quickly delete rows without logging each transaction] the table which has over 10,000 rows of data. SQL Code truncate table  [AdventureWorks2012].[dbo].[MyList] Result ========== Msg 1088, Level 16, State 7, Line 1 Cannot find the object […]

Read More

SELECT INTO

This is a quick way to copy data from one table to the other. The other table will be created. See example below, using the AdventureWorks2012 sample database from Microsoft SELECT [AddressID]       ,[AddressLine1]       ,[AddressLine2]       ,[City]       ,[StateProvinceID]       ,[PostalCode]       ,[SpatialLocation]       ,[rowguid]       ,[ModifiedDate] into   MyList FROM   [AdventureWorks2012].[Person].[Address] Result (19614 row(s) […]

Read More