SQL Server

Page 3341




  • Topics
    Replies
    Last post
  • I need help with a slow sql 2000 server
    by rtaiss
    4 Replies
    Last post by Ajmer Dhariwal
      • Hi, We have a server that s too slow. The tables have about between 1 million and 3 million records each. We have about 30 tables for production. The other tables are mostly look up tables (just for personnel and categories and so on, only static tables) 1/ do u guys think that s too much data, I mean about 3 millions records in a table. Because the manager said, may be if u archive some records a
  • Database growth excessive when changing varchar length from 50 to 100.
    by NozFx
    1 Replies
    Last post by NozFx
      • Hi all, I'm trying to get an understanding of a serious problem I have with a large DB in production. This is going to be obvious to someone (everyone probably) <bg> I have a table which consists of numerous varchars and ints but also a Text type field. This table resides in a SQL 2000 Database. This DB currently has a data file size of 16Gb and a Transaction Log size of 17Gb.
  • Very large table maintenance
    by Andy Fordyce
    3 Replies
    Last post by WesleyB
      • I have been asked to look at some performance isssues with an application that utilises a 800GB table. This table is huge and contains 4 int columns and 1 decimal column. The table has a clustered index that covers 4 of the int columns and is heavily fragmented and it has not been maintained for a long time. The system has limited free space to even attempt rebuilding the index. Does anyone have a
  • Crosssell in cube? How?
    by Frank2808
    7 Replies
    Last post by furmangg
      • Hi guys, I had some users ask me this the other day and I'm not even sure where to start... We have a dimension (product) which has a one to many relationship with our customer fact table. In this configuration, we can easily see how many customers own each product. What the user is requesting is to be able to see how many customers have different product combinations. For example, h
  • Check for column before adding a column
    by llebron
    1 Replies
    Last post by João Paulo Figueira
      • How can I test to see if a column exists before adding a column to a sql mobile table thanks, Luis
  • How to get the meatdata of a result set
    by Ricky Wang
    6 Replies
    Last post by Ricky Wang
      • How do I get the column names of result set returned by "Select * FROM t1" I am using ASP.NET library (SqlCommand for example) to issues this SQL statement. Thanks, Ricky.
  • Images in emailed reports
    by tonyzoc
    0 Replies
    Last post by tonyzoc
      • If I have an email subscription of a report, the images do not show up either embedded or as external web. I'm using Groupwise email client and also tried Yahoo web client. When I send one to my Outlook accounts the images do appear. Is there a way to make the images appear in non-Micorosoft email clients I'm resorting to sending PDFs, but for some reports I'm prefer it be an HTML email. T
  • Having Two datasets in a Single Report
    by shanthi
    13 Replies
    Last post by smssms
      • Hi, i have developed a report with sql reporting services 2005 which consists of two datasets in the same report. Any performance issues it will cause Thanks, Shanthi
  • multi lingual where clause
    by kyus94
    2 Replies
    Last post by Arnie Rowland
      • I have a table with nvarchar column. In query analyzer when I run query with foreign language words that are already there in database it dose not return any rows To test it I returned rows with Select * table. Then from result window I copy chinese characters and put it in SQL where clause in SQL analyzer .When I run query it dose not return results. What could be the cause..its
  • creating system dsn to SQL server 2000 Sp 4 fails
    by Jax1970
    3 Replies
    Last post by Anton Klimov - MSFT
      • Hi, I hope someone can help me out here I have a fresh install of SQL Server 2000 (standard edition - sp4), on a server running Windows 2003 SE (v 5.2.3790). I am trying to create a system dsn on my client pc (running Windows 2000) to a newly created database in SQL server called BLISS. I am getting the following error message: Connection failed: SQL State :'01000' SQL
  • Oracle Database behind reports
    by Jeremicus
    0 Replies
    Last post by Jeremicus
      • Quick question regarding using an oracle database to store the information used in reporting services. I've looked for the information but sites seem to often either be unclear or incomplete in their explanations. Basically, if using an oracle database behind the reports, I know the report server needs to have the oracle client tools installed but do the clients using the reports also need the cli
  • HELP!!! - Internal error. Buffer provided to read column value is too small.
    by Rohan - RSRK
    0 Replies
    Last post by Rohan - RSRK
      • This is the situation... I have a table PST_AVM partitioned by SRC_SYS_ID. It has data in three of the partition and constraints and index on it... Now, this is what I do that causes SQL Server generated and error. Here are the steps: 1. Drop all constraints and indexes on PST_AVM 2. Truncate partition for a given SRC_SYS_ID within PST_AVM table. 3. Load data for the same SRC_SYS_ID
  • Error with Subreport: One or more parameters required to run...
    by cochese
    0 Replies
    Last post by cochese
      • Somewhat of an anamoly, I can't figure out for the life of me what would be causing it. I have multiple subreports in a report (yes they all work separately); that isnt the problem. The problem is that when I have a subreport in one location, it works okay, but when I try to move it higher up in the report, it throws an error message. Essentially my setup is like this: I have 2 datasets: Current a
  • Conditional page breaks in SSRS
    by Rayz
    14 Replies
    Last post by Lisa Nicholls
      • Hi, I am having trouble setting conditional page breaks to my reports. i.e... I am having a report where I need to allow user the option to set page break between a group or not. Based upon the option selected by the user, I need to add page break to the report. I tried with all possibilities inside Sort and Group dialog box, but could not figure out how to toggle the opti
  • Howto remove printer symbol
    by hmayer
    2 Replies
    Last post by Lisa Nicholls
      • I am looking for a way to remove the printer symbol from the report manger because it dows not work on some client machines because they are locked down. For us it is completely sufficient to export to PDF. Is there a setting or an entry in the web config or something else. A hint would be helpful Thanks HANNES
  • Security - Stored Procedure - View - Table
    by DotNetP
    8 Replies
    Last post by Arnie Rowland
      • Hi all . I am going to consult you about a security concept . In my database I have a set of tables (eg. City , Country , ...) and I have a corresponding View for each Table (eg. V_City , V_Country , ...) and There are a set of Add/Delete/Update/List stored procedures for each object , the user which logs on to database has only EXECUTE Privilege on defined stored procedures and does not have any
  • SHOWSTOPPER!!!!
    by Krams
    11 Replies
    Last post by bjoseph954
      • Hi, Currently, with the setup that I downloaded off of the MSDN library, I ran the default.htm to install SQL Server. I get the error wit hthe splash.hta etc. I went around those to trun the Setup.EXE from the SQL SErver x86 folder and the setup runs fine. It also allows me to choose the installation path for Various components. HOwever, each tiem I choose D for the components, it seems like ther
  • query to split a database column ?
    by daniel ku
    13 Replies
    Last post by Arnie Rowland
      • How can i write a query to split a database column and shows 2 new columns. In my database column I have 2 mixing items and need to split out to 2 columns. Normally I have to write a query and change parameter and run another query. For example a database column with average number and range number. Thanks Daniel
  • auto insertion of records
    by ddhungry
    3 Replies
    Last post by ddhungry
      • hi, i'm quite new to sql and would like to ask if there is any way to automatically insert records from a table, for example dailyTransaction, into another table, for example transactionHistory, daily maybe around midnight or something. would also have to delete the records in dailyTransaction after it has been copied over to transactionHistory table i've done a bit of searching around and i think
  • Scoped Calculations and Aggregate
    by Michael Riemer
    1 Replies
    Last post by Michael Riemer
      • I have a measure which is defined as 0 and then Scope'd for certain dimensions to be a percent of the total as below: CREATE MEMBER [Measures].[Revenue Percent] AS 0; SCOPE ([Measures].[Revenue Percent]); THIS = ([Measures].[Gross Revenue]) / ([Measures].[Gross Revenue], [Area].[Sales Area].[All], [Direct Response].[DRS].[All]) SCOPE (Descendants([Area].[S
  • Two log files generated using "c:\\" + @[System::ExecutionInstanceGUID] + ".log"
    by jaegd
    3 Replies
    Last post by jaegd
      • Why are two log files generated when using a Text Log Provider with a Connection String property set to the following expression "c:\\" + @[System::ExecutionInstanceGUID] + ".log" I've set up package logging with a view to getting a unique, and linkable log. However, two files are always generated, no matter what the DelayValidation settings may be on the connection manager, f
  • Numer comparison
    by Bukhari
    14 Replies
    Last post by DaleJ
      • Hi, I have table with four fields ID, Date1, Date2,Date3,Date4. Dates are in numeric farmat like 20070927. How can i get largest date (from date1 to date4) on each row. Please suggest query. Thanks
  • Paging in MDX
    by MDXProf
    2 Replies
    Last post by MDXProf
      • Hi I am new to mdx.i want to know can we implement paging in mdx query is there any function in mdx so that i can return resultset based on count.i am using topcount function to return 10 rows.but i want to return result for next top 10 and so on.. in same query. like we do in paging. Thanks in advance
  • Importing / Exporting Data using ssms
    by Bill Schanks
    9 Replies
    Last post by Bill Schanks
      • I have installed ssms, and the toolkit. When I right click on a database I don't have Import/Export under tasks. However I do have C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe installed and can invoke it manually. What do I need to do to get it to show up in tasks
  • how best to write this query?
    by mtm81
    13 Replies
    Last post by Ian Roke
      • I need help on writing a query which will return my results as I need them. I have three tbls. TimeType, TimePlan and TimeSpent TimeType simply lists the Individual Jobs (types) a user can be doing. The TimePlan and Time Spent each list individual records with start and end dates and what TimeType was being performed. Each TimeType can have multiple starting and endi