Tag Info

Hot answers tagged

59

Really Short Answer - In Place is okay. You can review your configuration afterwards and implement the best practices for SQL Server 2012. A Longer Answer on SQL Server Upgrades/Migrations So this is an opinion thing and there isn't a necessarily wrong or right answer but I prefer migration style upgrades over in-place for a lot of reasons. That being said ...


12

In my experience, the same decision making process should be made as prior. AFAIK there hasn't been any 'world changers' with SQL Server installation, within the MS SQL Server product in itself, and the potential problems you have when rolling out software with millions of lines of code. Something bad could happen and now you're stuck with no 'ROLLBACK' ...


7

Using a database snapshot located on your production OLTP server will, in all likelihood, make performance worse. There are two main reasons: Extra write overhead. Snapshots are copy-on-write, so this will obviously impact performance. A snapshot will share pages from the old database on disk, but it uses its own memory in the buffer pool. If you have a ...


7

Why are you running a log backup job on [ReportServerQA5TempDB]? It should be in simple mode. From MSDN: ReportServerTempdb is created with the primary report server database and is used to store temporary data, session information, and cached reports. and Use the simple recovery model to backup the reportservertempdb database. Now the real ...


5

Mirroring is for individual database. For reporting services, you can user web server farms (AKA scale out deployment). It will allow multiple servers in a cluster. You will need SQL Server Enterprise Edition for this feature, though, as well as a load balancer (Windows has this or NW hardware like BigIP, etc.). See here for more info: ...


4

You could do something like this. declare @T table ( Department varchar(50), [Staff Name] varchar(50) ) insert into @T values ('Web - Electronics', 'Matthew'), ('Store - Electronics', 'Mark'), ('Web - Home', 'Luke'), ('Store - Home', 'John'), ('Store - Home', 'Paul'), ('Store - Home', 'Simon'), ('Web - ...


4

Any reason why you need to download the entire table every time to every location? select * from table w/o filters across geo locations is an uphill battle you're bound to loose. Filter the data remotely before download. Or make local read-only copies (eg. via log shipping).


4

I don't have 2008 to look at but do you have access to the RDL files that were published to the server? I can't recall if those are plain old XML files, but I think if you have those, it's probably a convenient way - you could parse them with Linq to XML, or XSLT. The schema is documented at: http://msdn.microsoft.com/library/dd297486%28SQL.100%29.aspx


4

Open "Reporting Services Configuration Manager" --> Database, verify the login under [Current Report Server Database Credential] is one of users in RSExecRole or not, if not, click "Change Credentials" button to change to an user in RSExecRole. You can also use commnadline utility rsconfig as well http://technet.microsoft.com/en-us/library/ms162837.aspx ...


4

Based on past interactions, I'm pretty sure that you're at least on SQL Server 2008R2. You could try filtering on the output of an Extended Event session. Here's a basic one to get you started. CREATE EVENT SESSION query_check ON SERVER ADD EVENT sqlserver.sql_statement_starting( ACTION (sqlserver.database_id, sqlserver.sql_text)), ADD ...


4

You can still install through ClickOnce deployment via (assuming you have configured SSRS with ReportServer as the installation path): http://<servername>/reportserver/reportbuilder/ReportBuilder_3_0_0_0.application It's still functional, but it's not full-featured. Source For example, Report Models are not supported and neither are ad-hoc queries ...


3

If you only want the reports stored daily (and not the data itself), you can create your five reports and setup a daily subscription to be delivered to a file share. See File Share Delivery in Reporting Services.


3

What's throwing it off is the XML name spaces in the tags. To get around this you need to use the with XMLNameSpaces clause. Give this query a go. I've tested this on a test instance (2008, not 2008 r2), so you may need to change the actual namespace definition to match your xml data. with ...


3

You should format your label so that there is a background color of white (instead of default none). Right-click on one of the labels and select Series Label Properties. Select Fill. By default this is set to No Color. Change it to White. Click OK. That should take care of it! ADDITION: It may be possible to write an expression to change the ...


3

If you have lost the historical data (i.e. it gets overwritten rather than stored as a transaction history) then you can't reconstruct the historical state - full stop. However, there are a few approaches to dealing with this. Build an automated process that queries the system through SSRS or some other mechanism and saves the historical reports to an ...


3

Using mirroring alone won't be sufficient since the mirrored secondary is not available for querying. You have to create and maintain snapshots, which can be annoying. Your options are, in no particular order: Mirroring with snapshots : effective but has management overhead. Backup and restore : Are you restoring from full backups rather than ...


2

Intuitively, if I was doing an OLAP solution for a retail chain, I'd say your infrastructure is really inappropriate for a system with substantial data volumes. This sort of kit has trouble with the data volumes you get in insurance, which is probably a couple of orders of magnitude smaller than I would expect to see in retail. As gbn states in the ...


2

Only a couple of things come to mind. Hack sp_dbcmptlevel and add a "IF suser_sname() = 'Your SSRS Account' RETURN" to the very top of it. Add a DDL trigger to the database that simply rolls back any alter database statements. There's no way to intercept the database call and prevent it from being sent to the database engine.


2

If you have an ASP.NET developer on hand, have them use the ReportViewer control to embed the report directly into a plain old aspx page. I've done this to a few reports, and they never show the usual "Report is being generated" message that you get when accessing them via Report Manager. (You might have to set AsyncRendering="False" on the ReportViewer ...


2

I believe that you need parametrized reports in SSRS - with a date parameter for your report. You will find the theoretical and practical details and some step by step tutorials about parameters in SSRS reports in the following articles: Adding Parameters to Your Report on MSDN Tutorial: Adding Parameters to a Report (SSRS) on MSDN - here more specifically ...


2

I wouldn't worry about setting the time component. Just write your query like this instead: WHERE SomeColumn >= @StartDate AND SomeColumn < DATEADD(Day, 1, @EndDate) You have @EndDate = Today() which by default does not have a time component (or rather it's already 00:00:00). Adding a whole day to that gets you tomorrow at midnight. So the ...


2

Data Driven Subscriptions is a feature that is only available in SQL Developer or Enterprise Edition.


2

Unfortunately, a workgroup is just a collection of computers on a local area network (LAN) that share common resources. They provide easy sharing of files, printers. But they don't provide shared security, like a domain. There doesn't exist something like workgroup users (as the domain users which can be used on all domain machines). So you'll need to use a ...


2

Well according to MSDN here: Group or User Type the name of a group or user account in your domain. If the report server is running under a local account, you must specify local groups or users. If the report server is running under a domain account, you must specify domain groups or users. Enter the account in this format: \. I would take ...


2

This is not possible using SSRS, but you can use powershell to read from CMS and then use the SQLCMD cmdlet to execute queries.


2

You can use an expression for the total that would look like this: =SUM(iif(Fields!Year.Value = MIN(Fields!Year.Value, "YourDataset"),Fields!Dollar.value,-1*Fields!Dollar.value))


2

Database Snapshots are read-only, so you couldn't run read/write ETL processes against the snapshot. However, you could point reports, end-user adhoc queries, etc. at the snapshot. This would allow you to run the ETL processes against the live database without interfering with user reporting. A new snapshot would need to be created after ETL processes ...


2

You should be able to write any sort of code in .Net and connect it into SQL Server. See http://www.codeproject.com/Articles/19954/Execute-NET-Code-under-SQL-Server-2005 for an example.


2

The page setup in the print options does not control your report parameters. You will need to use the Height/Width property of the report inside BIDS. Orientation in SSRS is controlled by setting these values. We have a report at our office that is similar to what you describe and there are two ways of (semi) achieving what you want to get done. The first ...


2

It is because it may not have a value at that pariticular field/place so first replace the value providing box with: iif(IsNothing(sum(field)),"0",(sum(field)) Then replace row summary field with the below expression: ...



Only top voted, non community-wiki answers of a minimum length are eligible