|
Browse by Tags
All Tags » SQL Server 2005 ( RSS)
-
|
Issue : To Create a Pivot table styled SSRS report and show and hide columns based on user options. Initial issue was to move rows of data into columns. Original approach was to use SQL command 'Pivot'. But the issue faced was the fixed column...
|
-
|
The SQL Azure Team Blog just pointed out that the November CTP for SQL Server 2008 R2 also includes support in Management Studio to connect to SQL Azure . Nice to know, and something I’ll be looking to blog more about as I investigate Microsoft’s SQL...
|
-
|
I suspect that there is a quick answer to this ... you don't. You revisit the data feeds and make them much more manageable. That's not always possible, however, and recently a colleague and I were set a challenge to load some very wide datasets...
|
-
|
I recently came across an annoying 'feature' of SSIS when importing data from Excel. SSIS can sometimes completely ignore a column(s) of data in a worksheet. This happens when there is no data within the first 8 rows (default setting), so this...
|
-
|
The initial release of SQL Server 2005 Service Pack 2 (SP2) contained an issue that caused maintenance plan cleanup tasks to remove data before the specified cleanup interval. Install this update to correct the interpretation of existing cleanup task...
|
-
|
This makes a massive difference in performance. Rather than using the "Table or View" option when selecting your OLE DB Source, instead use SQL Command and use "SELECT x,y,z FROM ViewName": Reason? "In “Table or view” access mode...
|
-
|
If you come across the above error when trying to deploy a 2005 cube, the only resolution I was able to find was to uninstall Analysis Services 2005 and install a new instance. There are a number of recommendtations to delete RSA keys and database connections...
|
-
|
Came across this problem while configuring Reporting Services on a SQL 2005 instance. Error: When the report manager virtual directory URL is accessed, the request fails with the error message HTTP status 400: ' Bad Request in Reporting service '...
|
-
|
When migrating a database from SQL 2000 instance to SQL Server 2005 instance, the maintenance plan is also migrated automatically. If the option to delete old backup files is selected in 2000 maintenance plan, the migrated plan in SQL Server 2005 doesn't...
|
|
|
|