SQL Compilation and execution plan

SQL Server Database Engine

Index ‹ SQL Server

- Previous
  - 1
    - Documentation of RMO and Merge Replication Is your RMO application running on the Subscriber server, or on a 4th server totally outside the Pub/Dist/Sub topology Tag: SQL Compilation and execution plan
  - 2
    - sp_send_dbmail generate ansi file attachment format This has indeed been fixed in SP2. The failure was in creating a unicode .csv file without the initial BOM mark. That has been remedied, and your .csv files will open without incident. You can evaluate this, and many other fixes, by downloading SP2 CTP2. jkh Tag: SQL Compilation and execution plan
  - 3
    - CUBE FAILING/HANGING if anybody still interested the problem went away after CTP of SP2 was applied. When is SP2 going to be officially released Or is there a hot fix for this problem Tag: SQL Compilation and execution plan
  - 4
    - about update sureshv wrote: I am doing as it is shown in the link you provided.but i connect to a database if it had to update a record after using union all. And it inserts a new record. Would you please make it much more clear with it. You'll need to provide more information, BUT, are you sure you are comparing data appropriately That is if you are comparing against a char field, trailing spaces are important to ensure a match. Just ensure that your comparison fields are trimmed appropriately before doing a comparison to decide if the record exists or not. Also, ensure that you are using appropriate error/data flows to direct the data appropriately (insert versus update). Just a suggestion. Tag: SQL Compilation and execution plan
  - 5
    - printing error Hi, some of my application users doesn't have Admin Privileges to their machines. When they try to print the reports, its giving a message "Unable to load client print control". Please help me how to solve this problem Tag: SQL Compilation and execution plan
  - 6
    - ODBC Connection Fails from cluster node hmm, If you are able to connect when you test the DSN but fails in your app, I'm not sure what I can do. There are probably some issue with your app. I hope you test your app and DSN under same account. Tag: SQL Compilation and execution plan
  - 7
    - SQL Server 2005 - Building a development Server After considering all my options in depth I have decided that I will upgrade my current machine. I looked into the problems I have been having and most of the slow performance seems down to IO. I have ordered an extra gig of RAM and couple of 160gb hard disks. I will add them to my machine and use one new drive for sql server data files and the other drive for log files. Hopefully this will bring adequate performance, and I will be able to continue using my development machine as a sql server. If I still have problems, I will look into buying a new machine, and will swap the 2 new drives over. Tag: SQL Compilation and execution plan
  - 8
    - Silent install using VBScript Hi, Hi.. i am new to vbscripting.i need to create the vbscript for ( .netframework2.0,MDAC2.7,XML4.0,VC++2005,windowsinstaller3.0,OWC10) with silent installation via VBscript.before that i need to check the machine have my pre-requisites or not,which machine does not have my pre-requisites through script i have to install. Kindly provide any solution for this.you can reach me at senthil3.n @tcs.com. thanks, N.senthil Tag: SQL Compilation and execution plan
  - 9
    - Sql Server Reporting Services 2005 returns 404 not found File permissions look correct to me. From IIS the virtual directory has read access (I also added Script Source and Write to be sure). The files themselves have read/write permissions for two reporting services users, and SYSTEM, Administrators, AND Users group all have full control. I added a test htm page it it loaded. Home.aspx is set as the default document under the Reports virtual directory and I tried explicitly entering home.aspx into the URL. Tag: SQL Compilation and execution plan
  - 10
    - exception handling - best practices Sorry, that comment was a response to a different question, and should not have been in this thread. My regrets for any confusion. Constraint failures cause block failure and unfortunately, cannot be handled by TRY...CATCH. Let me emphasize that I would agree with your collegue that suggested handling the issue in TRY...CATCH. I would not waste the resources for a 'double hit' with the 'IF EXISTS' possibilities. The only exception to that for me is switching between an UPDATE and an INSERT as I indicated earlier. You could also easily handle the UPDATE or INSERT using TRY...CATCH -but in my opinion, it is not an ERROR condition, but a business logic 'decision'. Tag: SQL Compilation and execution plan
  - 11
    - Scheduling an automatic backup Unless you are ready to purchase additional third party products, we have provided you links to the best 'free' options available to you. (And they do not provide everything on your 'wish list'.) Tag: SQL Compilation and execution plan
  - 12
    - Using Integrated Security from .Net Web to access SQL Server 2005 If I am posting to the wrong forum, please point me in the right direction. We have upgraded to SQL Server 2005 and Window 2003 from SQL Server 2000 and Windows 2000, and have been having all kinds of problems with security of our web applications. We have been forced to put the system account of the web server as a user in the database in order for the web applications to work. We have lost the ability to control security at the user/role level. Is this the way security is going to work in Windows 2003/SQL Server 2005 How do I use integrated security so that I can secure web pages and database objects Thanks Tag: SQL Compilation and execution plan
  - 13
    - Accessing the underlying sql query from the rdl file Our client uses the report builder to generate reports for collection of employees. We would like to use the employee records in this report to perform some additional processing (such as the list of employees gets assigned to a particular group). Programmatically, I can retrieve a byte stream from rs.GetReportDefinition( "\myClientEmpReport") and deserialize the stream into Report object (as define by ReportDefinition.xsd). I can then manually drill down and retrieve the SematicQuery xml from the commandText field. The problem is how to convert the SemanticQuery format into a T-Sql query that I can run against the view that the report model is based off of. Is this possible Thanks, Arjay P.S. Running SQL 2005 Reporting Services, VC# 2005, ASP.Net 2.0. Tag: SQL Compilation and execution plan
  - 14
    - IBM DB2 as Data Source apart from downloading and installing the MS DB2 oledb adapter, If you are using IBM DB2 on AS400 iseries, you still need the iseries client software to be installed on your SSIS server system. I have no experience with other than iSeries, but I reckon the IBM client software would still need to be installed. Tag: SQL Compilation and execution plan
  - 15
    - Reporting Services 2005 Subreport issue... Sorry, I'm new at RS. I didn't know I could return a parameter from a subreport back to the main report. If so, that would handle my needs very well. I'll dig in that direction for awhile and see where it leads me. Tag: SQL Compilation and execution plan
  - 16
    - SSIS Data Conversion: Convert a String (like yyyymmdd) into Datatype dt_DBDATE or dt_DBDATE Hi All, I need a solution for the following: I have a field with datatype string, length 8, in the form yyyymmdd (f.e. 20070604). Now I need to transfer this field into a field with datatype dt_DBDATE or DT_DBDATE. I tried to perform this with a derrived column and type cast (DT_DATE) or (DT_DBDATE), but this does not work. Any hint for me!!! Thanks in Advance ulrike Tag: SQL Compilation and execution plan
- Next
  - 1
    - SQL Reporting Services - Page X of XX counts in header Hi Larry, Thanks for providing the links for other, I will be sure to do the same in the future. I have a few questions regarding your suggestion to use a subreport. How will that reset my page counts The sub-report header is ignored <right >....and the global page numbers can only be used in the header.....could you clarify for me Much appreciated, Wendy Tag: SQL Compilation and execution plan
  - 2
    - Export to Excel Hi, In my report header i have the text boxes those are in the following format: Date: Parameters!Date.value Name: parameters!Name.Value and one image How to merge these to line up to avoid excel extra columns Thanks Tag: SQL Compilation and execution plan
  - 3
    - ?? 933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available I've read about this hotfix at http://www.kbalertz.com/Feedback_933097.aspx but I can't find anything on microsoft.com about it. It sounds like a worthwhile hotfix, but I'm wondering about the absence of an announcement on microsoft.com. Anyone else know about this hotfix Thanks! Tag: SQL Compilation and execution plan
  - 4
    - Layout question We have a report that is printed landscape and contains a main table with values. Inside this table we also want to create a "sub-report" table based on two other criteria (charges and credits), but this data is still grouped with the main table. Here is a simple schematic of the report XXXXXXX XXXXXXXX XXXXXXXXXX XXXXXXXXX Charges XXXXXXXXX XXXXXXXXX Credits XXXXXXXXX XXXXXXXXX XXXXXXX We have placed a rectangle in the last column of the main table to accomodate two other "sub-tables": one for Charges and the other for Credits. We need to keep the heighth of each row in the main table the same (without extra white space) so we cannot move the second table for Credits below the table for charges. I hope this makes sense and anybody with any suggestions, it is appreciated. Tag: SQL Compilation and execution plan
  - 5
    - Flat File Data Source with variable number of delimited columns I am writing a package that will process delimited flat files that will come in one of a few different versions. Within each flat file, the number of delimited columns will be the same, but each version of the file has a different number of columns. I have tried configuring the flat file data source to expect the version with the largest number of columns, but it will then throw away rows that have less than this number of columns (warning: There is a partial row at the end of the file). Is it possible to use a single flat file data source that will work with all of the different width files Tag: SQL Compilation and execution plan
  - 6
    - Stuck on a Inner Query Correct Rich. DOB calc's have to take month/day into consideration to get a proper value. Tag: SQL Compilation and execution plan
  - 7
    - help with WHERE clause I have a situation where I want to be able to match an exact string value and if that is unsuccessful then match all strings like the search parameter. The scenario I'm working on right now is searching for users by username. An example for simplicities sake is if I have the user "admin" and "administrator" in a database, if I search for "admin", I only want that single user to be returned, however if I searched for "adm", I want both users to be returned. Here's the approach I've taken so far: SELECT * FROM Users WHERE ((@Username IS NULL) OR ((Username = @Username) OR (Username LIKE N'%' + @Username + N'%'))) I expected that if (Username = @Username) was found, a single row would be returned and the rest of the clause would be ignored. However, it seems as though the LIKE is still being executed because if I search for "admin", I still get two rows returned even though I only want the single row with the exact username. What do I need to do to achieve the results I'm looking for Tag: SQL Compilation and execution plan
  - 8
    - SQL in OLE DB Thanks a bunch for clearing that up!! Tag: SQL Compilation and execution plan
  - 9
    - Unused Connection Managers Or you could use 6 XML config files, one per connection. It means you have a few additional files to manage, but you don't have to put all the connection managers in every package. Tag: SQL Compilation and execution plan
  - 10
    - Please help me SSIS... Hi Mathew, I appreciate your patience... the source is in the database and the Destination will be a shared folder to put the Text files. Source DB is on the same server and has all the tables in the same DB. Regards, Dev Tag: SQL Compilation and execution plan
  - 11
    - How to debug database engine stored procedures on SQL Server 2005? 1). When you right click stored procedure in the Query Analyzer on 2000 you can select debug from the list of menues. I can't find this functionality in the SQL Server Management studio. 2). By the way I also can't find where went the output of my print statement. 3). Does server cursor functionality is still working in 2k5 Tag: SQL Compilation and execution plan
  - 12
    - using uniqueidentifier datatype Hai, I got the solution. By changing column property Rowguid to Yes we can generate auto GUID. Thanks Maju. Tag: SQL Compilation and execution plan
  - 13
    - Error 18210 Backup up SQL Server 2005 Database to network drive Oj, the reason why I put *supported* in stars is, that it is sure supported, but not reliable in terms of just having a network share associated on a UNC share. (I thought he explanation should made that clearer, sorry for the poor explanation :-) ) The reliablity descrease due to your mentioned outages on the network. Having big backup files for the transfer over the network is there not recommended undless you have a SAN or a NAS which ensures more reliablity for the transfer. I often used the UNC path backup too on customer sites but either tried to shape the task to copy the files to different time windows or used a local backup and copied the files over with a mechanism (like xcopy / robocopy) to restart in the case of a connection loss. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- Tag: SQL Compilation and execution plan
  - 14
    - Adding records Neither unfortunately, it fails when opening the recordset. I can open it fine for reading, but as soon as I add the adLockOptimistic parameter, it fails, I've tried all lock types too just in case. Tag: SQL Compilation and execution plan
  - 15
    - Value of next record Is your problem solved If yes, can you please mark my post as answer Shyam Tag: SQL Compilation and execution plan
  - 16
    - Date filter in MDX this is interesting... I had this filter clause in where clause and I had the (null) problem... I moved filter clause in select in subquery and everything is fine now... Sorry for missing the changes in your post. I've made so many tests and I thought I posted same as you Thanks a lot, Darren Tag: SQL Compilation and execution plan

Chang-Il Kim

Hi all,

I��m having a test regarding to the image data type. The test program is written with sql native api and just update the image data type column, but I looked the SQL Compilations/sec and Batch Requests/sec counters in SQLServer:

QL Statistics using Perfmon, both values are almost the same. It seemed whenever the stored procedure is called, SQLServer compiles it and makes execution plan again. But when I had a test without image data type, SQL Compilation/sec was 0. SQL version is Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) (Build 2600: Service Pack 2).

Is SQL server working the way expected or am I missing something

Top

Re: SQL Compilation and execution plan

Mostafa Elhemali MSFT

Please look at this MSDN article in order to find out more about what's causing your recompiles:

http://support.microsoft.com/kb/308737

If you're still facing problems it would really help to give us a simple script that illustrates your problem (table schema & exact queries).

Top