Probably this question has been asked hundreds of times and yet net search has not generated satisfactory enough answer, at least, to me. And OK, let's assume your organization has more than 200 employees, just one measure to indicate that it's not small and data processing needs are quite ext...more >>

Hi Can someone please tell me whats wrong with the last line of the query below. The first three lines work fine but when i add the fourth line i get an error message (see text at ERROR MESSAGE) sql_HTTermijnRecords = "select * from Orders where FaktuurGeprint = 'J'" & _ "...more >>

Hi - hope I'm in the right place - I'm having trouble with a sql statement for a web page using access as the db (explains the date bit!) I have two tables - RoomTypes and Availability. The query below brings back the information I need - except I need to filter it one more time and exclude...more >>

Hello, I am currently working on a monthly load process with a datamart. I originally designed the tables in a normalized fashion with the idea that I would denormalize as needed once I got an idea of what the performance was like. There were some performance problems, so the decision was mad...more >>

Hi, I have a big log file in my database. Probably it is result of debugging process of my application (break execution before commit). What should i do with this log ? Is it possible just to remove it ? best regards pluton ...more >>

Hello everyone, I am hoping someone can help me with this problem. I will say up front that I am not a SQL Server DBA, I am a developer. I have an application that sends about 25 simultaneous queries to a SQL Server 2000 Standard Edition SP4 running on Windows 2000 Server with 2.5 GB of memor...more >>

Hi everybody, After days reading stuff about indexing, extents, pages, 8KB, 64 KB, IGNORE_DUP_KEY, CREATE INDEX, bla bla, lalalala, lllllll, grrrrrrr and testing with different kinds of queries, indexes, situations i'm getting confused, irritated, etc. SITUATION I have the following situat...more >>

Hello, I have been placed in charge of migrating an old access based database over to sql server 7.0. So far, I have imported all the tables into sql server, but now I have come across the issue of needing to split a string variable. For instance, in the old database, the variable for name ...more >>

Hi, I am expanding our data warehouse solution with new filegroups on several subsystems. I want to know which idea is better! - create clustered indexes on tables to 'move' them to new filegroups - create these tables on the new filegroups. The background of this question is as follow...more >>

I am using a select statement like SELECT ENAME FROM EMPTABLE WHERE ENAME ="vishal" I am getting the result as 1 row affected. Ename ---------- Vishal The Problem is the query I have passed is "vishal"(lower case) and getting the output as "Vishal"(V is Upper Case) How do I solve t...more >>

I am reading "SQL Server Query Performance Tuning Distilled", on page 104 it talks about one of the index design recommendations which is to choose the column that has very high selectivity of values instead of a column that has very few selectivity of values. My question is if I have currentl...more >>

I want to learn SQL Server 2005, so should I buy the Developer's Edition, or just use the Express Edition? Which would be more beneficial? Thanks, Niraj ...more >>

Hi Guru, After spening quite sometimes to watch my box, I've seen PAGEIOLATCH is a lead blocker in my SQL Server 2000 server. Below is the detailed: SPID lastwaittype waitresource blocked status cmd 57 LCK_M_S KEY: 7:963690681:8 65 sleeping execute 65 PAGEIOLATCH_SH 7:1:217904 0 sleeping se...more >>

Hello all, Say we've got these data: ---------------------------------------- CREATE TABLE #Test ( pid INT PRIMARY KEY NOT NULL, type CHAR NOT NULL, data VARCHAR(10) NOT NULL ) INSERT INTO #Test (pid, type, data) SELECT 1, 'A', 'pizza' UNION ALL SELECT 2, 'A', 'cake' UNION ALL SE...more >>

My use of wildcards thus far has been limited to matching a given string anywhere in a column as follows: SELECT * FROM Table WHERE Column LIKE '%string%' However, I'm wondering if there's a way to do this in reverse. That is, is there a way to match the column anywhere in the string? Pseu...more >>

Hello, Does anyone know what procedure to run to show information such as the owner of a specific database for MSSQL2000? I want to make a script to loop through all the databases on a server and display owner and other helpful information. Best regards, Andreas ...more >>

Hi All, I have a little scenario here, i am need of inserting some rows into a temp table which will be returned by a procedure... Here is little explanation I am planning to make a proc A and a temp table in proc A. I will be calling proc B from Proc A. What i want is the data returned by...more >>

I am trying to develop a stored procedure for an existing application that has data stored in numerous tables, each with the same set of columns. The main columns are Time and Value. There are literally hundreds of these tables that are storing values at one minute intervals. I need to calculate ...more >>

Hi all, I encountered this small problem I have two tables A and B with two columns 1 and 2 each, I would like the first column of each table when match the first in the second table is to subtract the second column so the result would look as follows Column 1 | Columnn 2 wher...more >>

Hi dear members, Can onyone please tell me that how can we load multiple files/ or even a single .SQL file stored on any physical location(Hard Disk) from SQL prompt. i have written some scripts in diffrent files, now i want to run those scripts, Do i always need to manually open those scripts ...more >>

Hello: I'm using MS SQL Server 2000 developer edition and trying to implement log shipping to the secondary server. I copied a database MDF and LDF files from primary to secondary server and all data is there, but this database still in recovery mode so I can not apply log shipping to it. My q...more >>

Greetings, Just wanted to know if there is any parameter in BCP utility that can ignore triggers, indexes and constraint defined for a table? any help will be greatly appreciated TIA ...more >>

I've gotten sort of fed up with dealing with regional date settings on the client side and am considering the following scheme - just wondering if anyone has a negative view of it or not: Instead of @StartDate datetime, @EndDate datetime Use: @StartDaysDiff int, @EndDaysDiff int ...more >>

Hello 2 all, Maybe my question can be very stupid, but I'm a little confused. When I run sp_who on my database, I see one process (accessing remotely my database from another database on another SQL server) many many times. Well, I assume that this is one process, because I cannot imagin th...more >>

HI, I'm pretty new to MS SQL, My problem is setting .... =Format$(Date(),"mm" & "/1/" & "YYYY") (Which is from my MS ACCESS database) as my default value in MS SQL. How can I do this since format() does not seem to be a function that is in MS SQL. The above function works great in...more >>

Greetings, If I use a "select into" to clone a table, all attributes are created correctly, however, if I use the same statement across a linked server, my identity column loses its IDENTITY specification. Is this a known issue or basic functionality of using "select into" with linked serve...more >>

Hello to all, I've fallow problem. I've a sp called as a job of SA each minute. This runs pretty nice, but from time to time, the job is aborted, and I don't know why. Considering my logging, which is implemented in DB, I know, in which point it is happening, but I don't know the exact erro...more >>

I have a table (table1) that has a bunch of fields.... [field1] [field2] [field3] [field4] [field5] None of these fields are unique, but if I combine them, then they are unique. I know there is a way to make multi-field primary keys, but when I try I get an that field1 is not unique, ...more >>

I would appreciate some help on a procedure that I have. Using Bulk Insert, I would like to import records from a text file. The issue I have is the file contains a header - '1AMC_TO_Axiz' and a footer '1AMC_TO_Axiz2". Using a format file, I can get the import to work by editing the file and ...more >>

Hi, I want to get the count of rows per each 20 minutes, is that possible? Is there a date function or any other function that I can use in Group by clause, which will group the data of every 20 minutes and give me the count? Thank you. Vidya ...more >>

Hi, I have a really interesting one for you guys... SQL Server 2000 sp3 on Windows Server 2003 If I run this query: declare @find varchar(50) SET @find = 'TTLD0006423203' SELECT TOP 250 ConsignmentID, c.Created FROM tblConsignment c WITH (NOLOCK) WHERE c.ConNoteNum LIKE @fi...more >>

Hello all. I'd appreciate some help with this one: First the DDL: CREATE TABLE [Document] ( [IDDocument] [uniqueidentifier] NOT NULL , [IDParentDocument] [uniqueidentifier] NULL , [IDDocumentType] [uniqueidentifier] NOT NULL , [Number] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_A...more >>

Hi,all, When I use following sql, an error occurs: insert into #tmprep EXECUTE proc_stat @start,@end There is a "select * from #tmp " in stored procedure proc_stat, and the error message is : Server: Msg 8164, Level 16, State 1, Procedure proc_stat, Line 42 An INSERT EXEC statemen...more >>

Witam! Mam problem z polaczeniem sie z baza danych po TCP/IP przez port domyslny 1433, nie mozna sie telnetowac ani nic z nim zrobic, poprostu niezyje. Port jest zamkniety i nijak nie moge go zmusic do jakiejkolwiek komunikacji nawet po localhoscie. Skaner portów wykrywa go jako zamkniety. Czy w...more >>

We're using ASPUpload as a tool to upload files to our server and save the details to SQLServer. However, I have an application where I need to return the pkID of the just saved file. I'm assuming that I could use the @@Identity command but cannot get this to function. Has anyone used this com...more >>

hi, where can I find and download trial version SQL 2000 Enterprise Edition 64-bit? I would like compare 32-bit and 64-bit version (system : I can Windows 2003 64-bit) Jacek ...more >>

Hi to all, I'm trying to use the copy database wizard to copy a database from the 2000 version to the 2005 version of sql server. I choose not to copy logins so I expect to find a database with only an administrative login o none at all. When I start the created package it throws an error sayin...more >>

Hi all, SQL Server 2000 service pack 3 running on Quad zeon windows 2003 server with 6GB of ram. A few months ago we split our databases into operational and completed data... So now instead of doing select * from tblTest, we do select * from tblTestboth where tblTestboth is a view like ...more >>

How do you set the "Timeout Period" in SQL Server 2005? ...more >>

Hello, I read several articles of newsgroup about the bulk delete, and I found one way is to: -create a temporary table with all constraints of original table -insert rows to be retained into that temp table -drop constraints on original table -drop the original table -rename the temporary ...more >>

Hello! Can somebody tell my something about performances when using mysql and php! Where i can find document about this performance? How php and mysql behave in use of multiple connections? ...more >>

Hi, I am using MS Access as the front end and it's using ODBC link to connect to the backend tables residing at SQL SERVER. I have some queries that are doing some calculation and the time taken to retrieve the data has been quite slow. The no of data in that table is around 500K re...more >>

Hi , I am running SQL server 2000 sp3a and i have set up my database to be in "Full Recovery" mode. I am not able to understand if i have set anything wrong here : 1. Full database Backup - every weekend 2. Differential Backup - twice a day 3. Txn log backup - 4 times a day (4hrs apart) ...more >>

I am working on tuning the procedure cache hit ratio for my server. We have added 4 Gb of memory to the server, which has helped. In addition, I have run the DBCC FREEPROCACHE, which helped for a couple of days to get the hit ratio up to about 84% (from 68%). When I use the performance monito...more >>

I am working on queries for a SQL database. I have much experience with Access and am trying to ween myself off of it. The query I am working on now is supposed to return a set of data like the following: LatestVersion(Ver)/VersionUpdate(Update)/Location(SheetNumber) A/aa1/3 This works fin...more >>

Hi, Is there a reason why we have to pay more for licensing for a different kind of processor? Why are we not charged for the Hyperthreading on some processors also. If Oracle is really conserned about the low end business market (small and medium), then they should drop their attitude on...more >>

Hello, Here is a brief summary: Table 1 = All Accounts - with fields such as Customer ID and Account # Table 2 = Deposit Balance Table - with fields such as Account #, Balance Table 3 = Loan Balance Table - with fields such as Account #, Balance All accounts are either deposit acco...more >>

I have a problem with Enterprise Manager - when I refresh list of tables or databases it hangs (is not responding) for long time - about 10-30 minutes. What is more important during my refreshement users are unable to work normally - it hangs entire server. Some other details: 1. I am only d...more >>

Hello All. We have tested following SQL script from query analyzer: -- Script begin DECLARE @I int; SET @I = 1; WHILE @I < 10000000 BEGIN SET @I = @I + 1; END -- Script end The script was tested on the folowing PCs with following results: PC 1: Pentium 4: CPU: 1.6 Mhz RAM: 256 Mb ...more >>

I'm trying to return an integer from the following table that returns the number of unique cities: tblEmployees Name City John Boston Frank New York Jim Omaha Betty New York The answer should be 3. DECLARE @EmployeeCities int SELECT @EmployeeCities = SE...more >>