Hi, We are having performance issues on our web app during peak times, which is currently split between one 2003 IIS6 Web Server, and one SQL Server 2005 DB Server. The query times on the DB server look fine (around 30ms), and the CPU is low (under 20%), yet queries can take a long time to execute on the web server (over 1 second). I w...
We have a SQL generator that emits SQL conditional statements generically for specified fields (which for the sake of discussion: we will label as myField). So, if myField is of type NVARCHAR, we can do a comparison of said field against a string like so: myField = 'foo'. However, this does not work for fields of type NTEXT. Thus, w...
In SQL Server (2008), I have a FullText index on two columns, call them Table1.FirstNames and Table2.LastNames. After profiling some queries, I came up with the following results: SELECT * FROM (Table1 LEFT JOIN Table2 ON Table1.SomeKey=Table2.SomeKey) WHERE CONTAINS(FirstNames, 'Bob') OR CONTAINS(LastNames, 'Bob') => 31 197ms SELEC...
I've got an instance of SQL Server 2008 Enterprise with Reporting Services installed also. I am hosting and administering this locally. My issue is that when I connect to the Report Manager web application I only get the Home|My Subscriptions|Help menu in the upper right hand corner. I am connecting using Windows Integrated Authentica...
My application currently needs to upload a large amount of data to a database server (SQL Server) and locally on a SQLite database (local cache). I have always used Transactions when inserting data to a database for speed purposes. But now that I am working with something like 20k rows or more per insert batch, I am worried that Transa...
I have been doing a coding in for last 7 months. Most part of it has been the updations to the very poorly coded software in asp. Now I am going to redevelop entire software in asp.net. I want it to be very efficient. I need some tips and guidance about how to plan project and design a good database. Thanks in advance for help. ...
Hello Guys, Here I am facing a problem that I want to pass a dataset to a SQL Server stored procedure and I don't have any idea about it and there is no alternate solution (I think so ) to do that, let me tell what I want ... I have an Excel file to be read , I read it successfully and all data form this excel work book import to a da...
2 Hi! I am trying to create stored procedure that gone return varchar value, and that value I need to display in textbox. This is the code for stored procedure: Create PROCEDURE Status @id_doc int, @Name varchar(50) OUTPUT AS select @Name =items.name from Doc,Items where @id_doc=IDN and doc.IDN=Items.ID return @Name This is t...
I have a package in SSIS, in the data flow I have a script component that is a data source, setting variables to an Excel Data Flow Destination. With ScriptOutputBuffer .AddRow() .scriptRowID = 2 .Filename = Variables.foundFile .RunTime = Now .Status = "found" End With Unfortunately the dates are coming out in the ...
I have readonly access to the master database however the following query only returns a subset of users. What permissions are needed to return the rest of the users? SELECT [name] FROM master.dbo.syslogins ...
I'm using SQL Server 2008 and I have 3 tables, x, y and z. y exists to create a many-to-many relationship between x and z. x y z -- -- -- id xid id zid sort All of the above fields are int. I want to find the best-performing method (excluding denormalising) of finding the z with the highest sort for ...
I have been doing a coding in for last 7 months. Most part of it has been the updations to the very poorly coded software in asp. Now I am going to redevelop entire software in asp.net. I want it to be very efficient. I need some tips and guidance about how to plan project and design a good database. Thanks in advance for help. ...
i am trying to run a query in another server and need to specify it in the select statement but the server name has got an '-' in it, like server-name. this is producing the error in the title. How can i fix it? ...
Hello all What I want to do is, inform the users about my program that "there is an update going on in database, so the results may not be correct." Thus I have to check if there is some process (like writing or deleting) on my table which my program uses. Edit: The way that I update my table is I use MS Access, I copy from MS Excell ...
I'm using Navision Dynamics 5.0 and need to export all the financial data into my datawarehouse on a regular basis (1 time daily). And therefore I don't want to use csv-files as exporting method. Which other methods are normally used? This must be a regular task for all companies who uses Navision Dynamics, and needs to get the data out...
Can someone please explain to me what the # symbol means in MS SQL Code. I've tried Googling it, and even searching on StackOverflow, but can't seem to find the answer. I feel like an idiot - having one of "those" days. Please help. ...
In Java, Hibernate is king in terms of automating code/DB synchronization. And I'm aware NHibernate is a .NET equivalent, and that LINQ has some cool SQL functions (despite not being developed further IIRC). But, is there any advantage from pairing .Net development with a SQLServer database? Magic automatic persistence of objects perhap...
Possible Duplicate: highlighting search results in php/mysql I am doing a search with a query, in MSSQL, like this: SELECT ctext FROM Table WHERE ctext like '%filter%' Then, I am wanting to highlight the hits with php: function highlightme($str, $filter){ $html = "<FONT style=".chr(34)."BACKGROUND-COLOR: yellow". ...
I am migrating to Postgresql, but I am facing a problem. A "trick" I am using with SQL Server is to login always using a single user (tipically sa) and I write the program_name in the database connection to check the number of currently logged users in the application. Everytime I do a db connection for UserX I set the program_name in t...
Hi. I've got the following SQL table: CREATE TABLE [dbo].[Test]( [TestID] [int] NOT NULL, [TestNum] [int] NULL, [TestReason] [varchar](50) NULL ) So TestNum an INT which allows NULL values, and I've inserted a whole lot of data into the table, of which some of the rows contain a NULL value for TestNum If I then run the fo...