SQL Server

Page 2957




  • Topics
    Replies
    Last post
  • How do I go about placing photographs in SQL?
    by aerospaced
    2 Replies
    Last post by aerospaced
      • I have SQL 2005 Server and Visual Studio 2005 and I am working in vb. I want to create a database which has photographs.
  • Average of children
    by strippy
    5 Replies
    Last post by PedroCGD
      • i know this question has been around for some time, and have read most of the answers, but well still looking at how to do this in standard edition of sql 2005. to what i understand Average of children calculates the average not on the lowest level but on the next one (i.e. it sums the values on daily basis but it calculates an average on weekly or monthly basis). my problem was that i needed to c
  • Query Time Limit?
    by dgolds
    2 Replies
    Last post by Arnie Rowland
      • I know I can use SET QUERY_GOVERNOR_COST_LIMIT to prevent a query from executing if its estimated execution time exceeds the value of the specified time in seconds, but is there some way to have a query stop executing (and raise an error) if the time exceeds a specified time For example, if the query takes longer than 20 seconds, have it stop executing and raise an error Thanks, -Da
  • Personal Web Developer Kit SQL Error
    by heebiej
    8 Replies
    Last post by heebiej
      • Hi folks, I get this error message when I try to run my personal web page starter kit (Ctrl + F5) which has come straight out of the box: Server Error in '/WebSite1' Application.
  • SQL Server - using a cursor to find and sum login/logout times
    by Jon_V
    3 Replies
    Last post by mastros
      • Hi all, New to using cursors and i was after some help. We have a trace running to find instances of certain sp's, these basically tell us when someone logs in and someone logs out (1 row per event). Importing into a table basically gives me process, user, datetime e.g. 'login', user1, 2007-02-15 10:21:35.590 'login', user2, 2007-02-15 10:21:36.100 'logout', user1, 2007-02-15 10:
  • Query performance problems with join on UDF-based computed column
    by Kevin Dente
    14 Replies
    Last post by Vlad Scherbinin
      • We have a table with a couple of computed columns. The value of the computed column represents a foreign key reference into another table. We're seeing a major performance problem doing a query joining between the two tables with one of the columns, but not the other. In other words, this kind of query is very fast: select * from TheTable A, FKeyTable B where A.ComputedColumn1 = B.KeyColumn but th
  • Pointers to the best documentation on star joins and the optimiser
    by peternolan9
    5 Replies
    Last post by peternolan9
      • Hi All, we are just starting to do some testing on sql server EE with dimensional models.....we have had one or two problems we have been able to solve using the new peformance dashboards etc. However, as is inevitable, we are seeing strange behaviour of a query....in a star join it seems to be doing an eager spool and trying to spool the entire fact table to tempdb....hhmmm.... R
  • Multiple Select statements + Stored Procedure
    by obrienkev
    6 Replies
    Last post by obrienkev
      • Hi all, I have 2 select statements in my Stored Proc. I want to display the results of each query in my DataGridView. However, only the data of the last select query is returned. Why is this Thanks.
  • hidden views
    by MyraK
    4 Replies
    Last post by MK13
      • hi , i have created views in database Test, in sqlServer.when i had to export Test to another database Test1, the views become hiddden. i can't see the views and when i try to create them again, i get this msg: There is already an object named 'view1' in the database. so how can i resolve this problem thanks,
  • Login Failed for <domain name>\<Machine Name>
    by loulou296
    3 Replies
    Last post by DavidJennaway
      • For some reason , the report server is trying to login as <domainname>\<machine name> - its supposed to be <domain>\<user name> or ASPNET or Network Service Authority - I have no clue why it is pickin gup machine name. Any ideas and how to fix
  • adding client server aliases
    by JRandall
    2 Replies
    Last post by JRandall
      • How can I import a client alias list in SQL Server 2005 Configuration Manager The tool provides a way to export a list, but not to import a list. Adding 100 SQL Server instances via the GUI is time consuming and agonizing. Thanks, Justin Randall
  • Profiler trace bind variables
    by CSC-Benefit
    4 Replies
    Last post by CSC-Benefit
      • Hi, Could anyne help me on which options in Profiler could be used to trace the bind variables in DML Given a table, X (col1 number, col2 varchar(10)), where col1 is primary key. Example DML statements: 1) insert into X values (@parameter1, @parameter2) 2) update X set col2 = @parameter2 where col1 = @parameter1 3) delete X where col1 = @parameter1 where @parameter1 and @parameter2 are bind varia
  • aspnet_wp.exe crashing intermittently
    by ashwin_kanhere
    1 Replies
    Last post by ashwin_kanhere
      • I have an application which is providing printing facility using a custom hardware interface device. Whenever a print is required user punches in his ID number into the hardware device, and hence an underlying application gets the event and it calls a managed DLL, which inturn calls the Reporting services webservice on the same server. Problem starts after some days (typically after 2 -3 days), wh
  • Problem for Calling A Stored Procedure, Please help.
    by xxd
    14 Replies
    Last post by xxd
      • I am writing a Stored Procedure for other server (using C++ to receive the output values) as below, where @Total £¬ @balance£¬ @A are output values create proc [MaxTime] @number varchar(30), @numbera varchar(30), @numberb varchar(30) as begin declare @balancefloat declare @table varchar(20) declare @freetotal varchar(20) declare @SQL nvarchar(4000) declare @A float d
  • Data Type Range
    by Tech02
    6 Replies
    Last post by Tech02
      • Hi, When I set a tinyint field as identity, it automatically sets the identity seed as 1. I wonder whether the increment is set to go around in loop. Say, I have the range of 256 numbers for a tinybit. So, an identifier should go from 1 to 255 and then to 0 and then back to 1. Is that right
  • A CLR SVF works on my DB instance but not on the other one
    by marina B.
    7 Replies
    Last post by marina B.
      • Hello, I have scalar valued function that simply convert a date from UTC to LET by using the .NET functions.. The code is very simple: Partial Public Class UserFunction <Microsoft.SqlServer.Server.SqlFunction(isDeterministic:= True , Name:= "ConvertLETDatetoUTC" )> _ Public Shared Function ConvertLETDatetoUTC( ByVal DateLETFormat As SqlDateTime) A
  • Scheduled Profiler
    by Gary Watson
    6 Replies
    Last post by Gary Watson
      • I need to get performance stats off a number of live servers. The stats need to cover the time from 07:00 to 19:00 every day. I'm after things like CPU, Memory and IO, but also I want things like transactions and stored procedures. Can profiler provide this kind of information, and can I schedule the jobs The systems are all running on Windows server 2003 and SQL Server 2005.
  • I can't get SQL Server 2005 Enterprise Edition working
    by Abbas Naqvi
    5 Replies
    Last post by Mike Wachal - MSFT
      • Hi all, I can't get SQL Server 2005 Enterprise Edition working on my notebook with Windows Vista Business Edition. I installed SQL Server 2005 Enterprise Edition and then i ran SP2 for SQL Server EE. But now when i a am trying to connect to any server from SQL SERVER MANAGEMENT STUDIO i can't see any Server in Server Name list. When I click on Browse for more, I don't see any s
  • Default Constraint on columns Pros and Cons?
    by Darin Clark
    8 Replies
    Last post by Louis Davidson
      • Are there any vices to using default constraints on all columns in your table. For example an Int that defaults to 0 or a char or varchar that defaults to '' I know that 0 and Null are not the same thing. But if your programs don't have the concept of NULL then you have to convert the NULL to zero. So, DEFAULT CONSTRAINTS on every column. Is it good or Bad Thanks
  • Exporting reports to PDF
    by Addin
    9 Replies
    Last post by Addin
      • Does anybody know how to export reports to PDF so that it fit to page Thanks, Addin
  • PIVOT sql_variant into underlying dataypes
    by Jim Bennett
    5 Replies
    Last post by Louis Davidson
      • Does anyone know of a way to PIVOT an sql_variant column so that the resulting columns will be their proper underlying datatypes I wish this to be done in a View. I currently do this by hard coding the conversion as follows: SELECT A, B, C MAX(CASE Letters WHEN 'D' THEN CONVERT(int, LetterValue) ELSE Null END AS D, MAX(CASE Letters WHEN 'E' THEN CONVERT(datetime, LetterValue) ELSE Null END AS
  • SSIS - Best way to copy files from one directory to another
    by Linda Cornerstone
    14 Replies
    Last post by Linda Cornerstone
      • In SSIS, I was to: take files from c:\directory1 copy them to c irectory2 with a different name (concatenated date on the end) delete them from c:\directory1 Should I be using the Script Task for this I am wondering if I should be using the File System Task which copies directories or files, but I don't know if I could rename the files during the copy. Also, I want the direct
  • Help exporting data from .csv file to Sql server
    by Dev2624
    7 Replies
    Last post by Dev2624
      • Hi i am trying to export data from .csv file to sql server and my data is coming as "xyz" where i want only to store as XYZ i am using derived column but i am not able to capture " and replace it what approach should i take here , also i am trying to convert String True to Boolean 1 and vice versa for False in database how do i do that please help me with this.
  • ReportServer DB and ReportServerTempDB databases
    by bluemoon2181
    4 Replies
    Last post by bluemoon2181
      • Hi all, Is it possible to cleanup ReportServer DB and ReportServerTempDB by setting the time interval For example, I want data in these two dbs to be deleted automatically after 5 or 10 minutes. How can I do that because as new reports are added and executed data goes on increasing in very short time and hurts performance. Thanks, Prashant
  • admin or other role
    by --Janis
    1 Replies
    Last post by Arnie Rowland
      • I have one other question. How do you define roles What role(s) are required to fully administer SQL Server What role(s) are required to fully administer a single database in SQL Server thanks,