weve followed all the known methods to improve performance; and now are ready to start denormalizing the tables. Can anyone see anything obvious that i can do to improve the perofmrance of this sp under heavy load? CREATE procedure sprListingSearch( @Culture nchar...more >>

hai, declare @askey char(16) declare @asno varchar(6) declare @asalfa varchar(10) set @asno = '2569' 1. ) set @asalfa = '' 2. ) -- set @asalfa = 'a' --set @askey = replicate(' ', 6 - len(@asno)) + @asno + replicate(' ', 10 - len(@asalfa)) + @asalfa -- print len(@askey) I want to ge...more >>

I created 4 single column indexes on a table with about 20,000 rows. This table is replicated out to about 4 other databases The CPU usage went up to flat out. That was two hours ago and the server will need to be used in about another 2 hours I'm assuming that the process won't finish before ...more >>

Here's where I get it in the 'catch ex': cmd.CommandText = "DELETE FROM TBL_RegBuyer " & _ "WHERE buyr_buserid = " & TextBox1.Text ^ | here------- Th...more >>

I have the classic problem of multiple SQL Server databases (one per company) with identical schema and I need to be able to update all databases with schema changes easily and reliably. If I was able to utilize a USE DATABASENAME in a stored procedure (where DATABASENAME is a variable passed as an ...more >>

I have the following stored procedure ALTER procedure SelectGeneratedMEN a select numbe from generate_meno update generate_men set number = number + I take the value from the number column and concatenate it to some other characters to generate a unique value in the format my customer ne...more >>

I'm stuck trying to write a SELECT statement to accomplish the following: Database tblScores has three fields: StudentID, TestDate, and Score. I want a list of all students' most recent test scores. Not all students took all tests, so the students' most recent test dates are not all the same. I ...more >>

Hi I got a small problem that I really don't know how to solve; Lets say you have a service where you can order stuff, both members and non members can order here. Members do have an ID which comes from a user table, this id is put into the order table when a member place an order. The o...more >>

I'm designing a db for several entities for which I need to store addresses (possibly > 1 per entity). I could create address fields in each table but that seems like a lot of duplication, espec. when I have to then write data-access code for them all. What I've done so far is create an Addres...more >>

Hi, All I send a RESTORE DATABASE command for sql server 2000. That database Fix in Loading state and can not accept any connection for some minutes or hours. Sometime complete this command with no ploblem. Thanks. ...more >>

Hi all, Database driven website, searching through the page content... I'm aiming to produce a relevance percentage for a search based on the number of times that the search criteria is located within the search column(s)... example: 3 pages searched, search criteria appears in page 1 ...more >>

Hi, Not sure if you guys are taking questions on Yukon...but if you do, I would like to know if the new Workbench IDE supports version control of database, as well as server configuration settings. I think this is important since in the course of a development effort, these settings can ...more >>

Hi, does anyone know where I might find a sql programmer to do a small project? ...more >>

Just 6 months ago i've writed an app in vb 6 and sql server 2000 Because my hd crashes i've recently installed all the software i've used to work with I installed all the service packs and patches including sql sp3 but.. now i'm modifiyng that app and i've discovered that every time i try to upda...more >>

Hi I'm using SQL Server 2000 and want to design a table to keep unit of counting like following: code description ----- ------------ 1 litr 2 gallon 3 pound 4 ounce I defined code as PK ,which design is better? code char(1) or code int any help wo...more >>

trying to build a generic procedure to remove duplicates but I can't save because of errors on lines with if statements can anyone help resolve this ?? ============================== CREATE PROCEDURE [NCL_RemDup] @vTable varchar(50), @vSQLString varchar(2000) AS DECLARE @SQLString VARCHA...more >>

Hello, I'm sure this must be really easy but I just can't find any reference to it in BOL. I need to join two numbers together as follows. declare @id int set @id = 55 Insert into t(a,b,c) values (1,@id + 0001, c) the value @id + 0001 needs to be 550001 Thanks, Andrew ...more >>

How to count the possible values in a columns group? For example, number possible values for column v3 for any (k1, k2) combination (1,1) there are 3 possible values (1,2) there are 2 possible values create table myTable ( k1 int, k2 int, v3 int ) INSERT INTO myTable(k1,k2,v3)...more >>