Hi all I'm reasonably new to SQL Server Reporting Services and Report Manager, and completely new to SSRS's Subscriptions. We're running SSRS 2008. Out of the box it seems that a user with the Browser role can create a Subscription to a report and schedule it to run at any time they choose. As an admin I have setup a schedule called "...
Greetings Friends I am facing one problem, i have a tool which has been developed in C#.Net 2005 and it will create Database by executing SQL scripts; the scripts are running in batch. When run in XP it works fine; but problem starts when it runs in Windows Vista 32 bit O.S. with SQR Server 2008 Express;i am logging the error in log f...
what is the difference (system resource wise) between using views and temporary tables? I have a complex report that will be built from numerous tables. I am trying to determine if I should use a series of views or temp tables (SQL 2008). Is there a difference? ...
Often I need to pull the production database of some project to my local sql server to add features, test out stuff etc. Today my procedure is to create a backup on the production server, somehow get that to my local machine - and then create a new database locally and restore the backup on top of that. It is a pain, and takes more t...
I am getting an error when attempting to display report parameters in a textbox. I have constructed an expression like: ="My Report for " & Parameters!ReportMonth.Value & " " & Parameters!ReportYear.Value ReportMonth and ReportYear are string values The error I am getting is: "The Value expression for the textrun ‘Title.Paragraphs[0]...
Hi, I am using SQL Server 2008 and I have the following SQL script: Select o.CustomerId as CustomerNoId, OrderValue, OrderDate From dbo.Orders as o Inner Join ( Select Top (10) CustomerId From dbo.Customers where Age < 60 ) As c On c.CustomerId = o.CustomerId This works as desired when used with dbo.Customers and dbo.Orde...
Hello Everyone, I currently have mirroring setup between three computers, principle, mirror, and witness. During the day, all these systems are fine; they failover with the failover command, and the failover when unplugging any of the stations. My problem is at night I lose Quorum between the three stations, and the only way to get it b...
I am replacing an Access application with a web app, but the client is using SQL Server 2000, and I am using SQL Server 2008. So, I have the database redesigned, with foreign keys, but now I need to get the data on the client's system. Part of the problem is that they have images that are over 32k, so osql failed as the command buffer ...
We are trying to display the images on to the reports without embedding them in to the reports. One of the ways is to use images from databases. But, we are having issues with that. Here is the issue we are having: Since SQL Server 2008 has File Stream option for storing images. We have created a table (XX) to store the images using fil...
I am storing results of a bikerace (think Tour de France) - and the results of the individual stages. Rider - Stage - Time Klaus - 1 - 4:12:01 (4 hours, 12 minutes and 1 second) Klaus - 2 - 1:22:12 Klaus - 3 - 0:12:54 Klaus - 4 - 2:59:05 What datatype should I use to store the time value? I looked into the TIME datatype, but it do...
We ported a database server from SQLServer 2005 to SQLServer 2008 (SP1). The new server has more Processors (4 Quadcore versus 1 Quadcore ) and more memory (4GB versus 64GB). Processors are 2.1Ghz(new) versus 2.0Ghz(old). The new OS is Windows Server 2008 and the old is Windows Server 2003. The databases were transfered via backup/rest...
Does any one know if the limitaition on SQL Server 2008 that a geography cannot be larger than a hemisphere (described here) has been fixed/relaxed in 2008 R2? ...
Hi, Let's say we have SELECT * FROM A INNER JOIN B ON [....] Assuming A has 2 rows and B contains 1M rows including 2 rows linked to A: B will be scanned only once with "actual # of rows" of 2 right? If I add a WHERE on table B: SELECT * FROM A INNER JOIN B ON [....] WHERE B.Xyz > 10 The WHERE will actually be executed before the...
We have built an ASP.NET application (with C#.net language) and hosted on Windows Server 2003 Operating System. The database is SQL Server 2008. Now we need to do a search involving 4 tables and one of the column of table is varchar (2400) and the other columns are of normal lengths (E.g. Varchar(50) etc.). This search gets fired when...
I have code that has a Dictionary defined as: Dictionary<int, StringBuilder> invoiceDict = new Dictionary<int, StringBuilder>(); Each Value in each KeyValuePair the Dictionary is actually three separate values currently created as follows: invoiceDict.Add(pdfCount+i, new StringBuilder(invoiceID.Groups[1].ToString() + "|" + extractFi...
Can someone figure out how to get rid of the NOT EXISTS statements in the WHERE clause? SELECT TOP 100 PERCENT Ftm.AcctID AS [Acct Id], Act.AccountNumber AS [Account No.], Act.AccountTypeId, ISNULL(Cnt.FirstName, '')+ ' ' + ISNULL(Cnt.LastName, '') AS [Full Name], Ftm.FinTransTypeCode AS [Trans Type], Ftm.F...
Hi, how big (binary(xy)) should I make my table column in SQL database if I want to store there pictures taken by camera - that means variable size up to.. I don't know.. 7MB? But if I should rather limit the size up to 2MB or something, I would. Whats your opinion? EDIT Or where else should I store them? I am building a web gallery us...
I'm working with a client who has just upgraded from SQL 2000 to SQL 2008 and their view query times have gone up a lot. I had a look at the views and couldn't see much wrong with them. When I ran the view directly on the server, the times were OK. When I ran via Management Studio remotely, the time goes from 2secs to about 30secs. So,...
I have a background process that is constantly inserting into a table in real-time. It could be thousands of inserts an hour (with a few updates). This same table is used by the web application to get some data needed to display to the user. Currently whenever the background process runs its inserts/updates, the web app seems blocked a...
I am looking at FILESTREAM attribute in SQL Server to store files in it. I understand it stores the files on hard drive and stores the file pointer/path information in DB. Also, maintains transactional consistency in the process. There also seems to be a limitation "FILESTREAM data can be stored only on local disk volumes" for the FILES...