-
as seen on Server Fault
- Search for 'Server Fault'
I have a problem with sqlservr.exe (version 2008). It use a more memory. I checked on windows taskbar manager, sqlservr.exe usage ( Mem usage - 8GB Ram). I dont know how can I fix it.Got the following metrics of the server using Perfmon:
SQLServer:Buffer Manager
Buffer cache hit ratio
13
SQLServer:Buffer…
>>> More
-
as seen on Super User
- Search for 'Super User'
I have a windows 7,32 bit laptop. I am the administrator with all permissions.
when I click on the SQL server 2008R2 set up file,it says :
"SQL server set up has encountered the following error:Failed to retreive data for this request" click on OK.
I have uninstalled all the components of SQL from…
>>> More
-
as seen on Simple Talk
- Search for 'Simple Talk'
In my previous post, I introduced the SQL Monitor data repository, and described how the monitored objects are stored in a hierarchy in the data schema, in a series of tables with a _Keys suffix. In this post I had planned to describe how the actual data for the monitored objects is stored in corresponding…
>>> More
-
as seen on SQLIS
- Search for 'SQLIS'
If you are building SSIS 2008 packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post. See also CreationName for SSS 2005. We start with…
>>> More
-
as seen on SQL Authority
- Search for 'SQL Authority'
The job of an SQL Consultant is very interesting as always. The month before, I was busy doing query optimization and performance tuning projects for our clients, and this month, I am busy delivering my performance in Microsoft SQL Server 2005/2008 Query Optimization and & Performance Tuning Course…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've got a Reporting Services report that has two row groups: Category and SubCategory. For columns it has LastYearDataA, ThisYearDataA, LastYearDataB, ThisYearDataB.
I added two columns (one for A and one for B) to handle an expression calculation (to show a percentage different from LastYear to…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
My report is as follows:
One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data)
The second table is a variance report for data that has been shipped…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
after a number of failed attempts i seem to have successfully installed the Reporting services add-in to my WSS farm. However, I seem to be missing most of the enhanced functionality eg no report library template, no report center site template. the only additional functionality available is the report…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
When I open Reporting Services Configuration Manager on my server, an error message appears that says:
Reporting Services Configuration Manager
An unknown error has occurred in the WMI Provider. Error Code 800706B3
This error appears before I can even attempt to connect to an SSRS instance.
In…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hello!
So... here's my story:
I'm trying to create a SQL server data extension (to be precise, I'm trying to get some sample code to run) (SSRS2005).
I've done the following:
Placed the extension assembly into the ReportServer/bin folder.
Placed the assembly into the Private Assemblies folder…
>>> More
