Posts Tagged ‘SQL Server’
Puzzling Situations: Using MultiValue Parameters with Stored Procedures in SSRS
Why developers go WTF? with SSRS MultiValue Parameters + SQL Stored Procedures, and how to fix that. A T-SQL Tuesday joint. This months theme: Puzzling Situations.
FIX: SSIS Script Component Error “The value is too large to fit in the column data area of the buffer”
SSIS Error “The value is too large to fit in the column data area of the buffer.” and Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException. Fix
HOW TO: Uninstall SQL Server Embedded (from SharePoint or WSS)
Uninstall SQL Server Embedded edition How To.
FIX: Cannot connect to MICROSOFT##SSEE database
If you can’t connect to the MICROSOFT\SSEE instance for sharepoint, try the following:
Use “\\.\pipe\mssql$microsoft##ssee\sql\query” as your Server name in SQL server management Studio.
FIX: SQL Server Stuck in Single User Mode – And You Can’t Get In
Ever get a SQL Server 2008 database stuck in SINGLE_USER_MODE, then find you can’t maintenance it, access it, and even SP_WHO2 fails?
Maybe you dropped it into SINGLE_USER_MODE to perform a DBCC CHECKDB type of repair, then tried to access it again and voila…you’re not the only one in the database. This could happen in a number of scenarios, but a typical one in a SharePoint environment is the SEARCH database.
FIX: FTP Task Blocked When Run in SQL Server Agent
Got the connectionstring and credentials down pat, and no error message when executing a SQL Server Agent Job that included an FTP task in SSIS. It just sat there, and [...]
Analyze and Optimize SQL Server Reporting Services Reports
Things to look for in SSRS optimization include the following:
Long running reports
Which reports have the longest total duration?
If the TimeDataRetrieval is high, the data source could be a bottleneck, or [...]
Free eBook: SharePoint & SQL Server 2008
Microsoft has released a free eBook for DBAs that manage Office SharePoint Server 2007 on SQL Server 2008. It provides guidance to improve the performance of MOSS on SQL Server [...]
Connect to SharePoint database on MICROSOFT##SSEE
This handles the annoyance when trying to connect to the embedded SQL Server that SharePoint uses by default for its config and content. When you attempt to connect with SQL [...]
