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 >>