Does SQL Server have a query cache similar to mysql, whereas the query result is cached, if the table has not been changed? If so, please refer me to more info. Thanks. -- http://www.dbForumz.com/ This article was posted by author's request Articles individually checked for conformance...more >>

I use a stored procedure that is calling several other stored procedure which update or append values in several tables. All of them are stored procedures with input parameters by which they filter rows to be updated or inserted into other tables. Filtration is based on certain actual values on ...more >>

I recently came across a database where the data are horizonally partitioned into 4 tables. I'm not sure if this was a poor design choice, or if it was done for valid performance reasons. The schema of the tables are essentially the same, it's just that they are named differenly and the columns a...more >>

Hi guys, I have a database table (documents) with a structure that looks like this: docID docName keyWords 1 testTitle01.doc dog,cat,bob 2 testTitle02.doc hello,world 3 testTitle03.doc please,help,me 4 testTitle04.doc is,that,a,dog 5 ...more >>

Hi. I'm coming from a background of developing mdbs and am trying to migrate our databases to adps running atop MSDE 2000. However, I've encountered a problem while trying to do analogous things to what I've done before with mdbs...for example: -Linking to a csv file on another machine: I am ...more >>

Hi When we issue a DBCC SHRINKFILE with empty option, the data file is removed and the space is alloted back to the OS. Same way when we issue a an ALTER DATABASE to remove a database, all the data files and transaction log files are dropped. But can these files be recovered again ...more >>

Sorry if this is dumb: I'm using SQL Server 2000 and have an sp that inserts several rows into a table with an identity column. I want to use the identity values from my newly inserted records to create entries in a related table. How could I do this? @@IDENTITY only gives me the last row. ...more >>

My platform is NT2000 and my database runs on a SqlServer 2000. I have a database where some of the user tables are owned by the user dbo. I would like to change the user from dbo to another account. When I execute the sp_changedbowner to change the table owner I get the following error message...more >>

Hi all, I wanted SQL server to sent me an email when it reboots. I created an Alert but doesn't seem to be working. Any suggestions. Thanks, ...more >>

I'm a complete newbie. Need to insert a Company logo into a database column to use later on in a check printing application. Read how to insert the pointer instead of the object into the column. Below is what I did: SET QUOTED_IDENTIFIER OFF GO INSERT INTO BankInfo (CoLogo) VALUES(0xFFFF...more >>

Hello folks, first of all I really don't know how you gurus call this way of writing joins: SELECT A.FIELD, B.FIELD FROM TABLE_A A, TABLE_B B WHERE A.ID_FIELD = B.ID_FIELD I find this way very useful and readable. It works also with left and right Joins (using *= or =*...more >>

I have about 7 tables I need to join, but am having a lot of difficulty with the joins, that I need some help on. I'll provide the details of four tables to illustrate the scenario. I have one table called Product, which contains a complete list of products. I have another table called Date...more >>

Any advice from the crowd? Every time I try to run "Copy Database Wizard" I get an error message saying I must be a member of the sysadmin group and have permission to copy files over the network. I'm a local admin on both boxes and a member of the sysadmin group on both SQL servers and an admin...more >>

hi where i can get ms-sql 2005 beta version downloadable version . i'm not MSDN subscriber. Pls anyone can help. thanks...more >>

In MS Access I can do in one SQL statement a update if exists else a insert. Assuming my source staging table is called - SOURCE and my target table is called - DEST and both of them have the same structure as follows Keycolumns ========== Material Customer Year NonKeyColumns ======...more >>

Trying to get my jobs to send mail when job fails. Should be easy but it's giving me headache Had a whole slew of issues. Outlook is installed with a n outlook mail profile set up that can send mail in outlook. I can create a SendMail DTS and execute it to send mail Email works in these...more >>

I must import some exemplary file to database (MS Srrver 2000) ofcourse using procedure Transact SQL. This file must: 1.Read the xml file 2. Create table 3. Import this date from xml file to my database Ps. I create procedure who File xml imports to base, but unfortunately she only schedule...more >>

We've a database in MSSQL. For some reason, one transaction was interrupted at network level. That corrupted our database. If we try to attach it, we get the following error. Server: message 3624, level 20, state 1, line 1 Location: page.cpp:2412 Expression: m_slots [-m_slotCnt + 1 + i]....more >>

I made a search page for my website using mysql. I search the field "storyText" for a word, then display the result: SELECT * FROM story WHERE storyText LIKE '%$word%' ORDER BY storyDate desc The problem is in the ORDER BY. I would like the order to be related to the number of "word" found i...more >>

Hi there, had to rush some sql and am now going back to it due to a slow db performance. I have a db for sales leads and have created 3 views based on the data I need to produce. However one o the views, which has subqueries to the other views is VERY slow and it needs to be speeded up, ...more >>

Hei, I'm currently trying to write a program in C# that will allow users to parametrize their queries. For instance, I have a query like this: SELECT * FROM Customers Where Region = @Region AND Gender > @Gender How can I extract the Parameters names without using String manipulation (which...more >>

Hi, Apologies if this is better posted in an ASP group, but here goes anyway ... Is it possible to work out what parameters a stored procedure expects, using ASP? I would like to take the name of a stored procedure, work out what input parameters it has and build a form based on them in ...more >>

I need to build an automated email that gives the completion messages when a database is restored (i.e. "Executed as user: sa. Executing RESTORE DATABASE DB1 FROM DISK='h:\backups\DB1\DB1_db_200411082056.BAK', RECOVERY [SQLSTATE 01000] (Message 0) Processed 3816 pages for database 'DB1', file '...more >>

Hi all, I have de following application to do : I receive several .csv files from another application in a determined folder of my PC. Those files are named with the format log1.csv logs2.csv logs... The number of file is variable but the internal format is always : time_sec;level So th...more >>

hi, i run a sqlserver 2000 and im having problems setting a permission a column in a table.. under a database i have a User that has dataread rights on each table in the database, but in one table i want to prevent the user from seeing a column in one perticular table. i have created the...more >>

I'm trying to install a default instance of Developer edition on a laptop. I'm getting the following promblems shown in sqltp log. The laptop has previously had the SQL Developer installed but has since had OS installed. I've tested named pipes to another server (net view, net use) and it see...more >>

Dear All, How to reach to the highest level of normalization for database designing? Guide Lines Needed. What will be the characteristics of a database of a completely normalized databae? Check List needed. Thanks SuryaPrakash Patel ***************************************** ...more >>

Hello, There are three tables: OS-GroupOFCompanies (Table1) GoC_GroupOFCompaniesID (PK) OS-Organization (Table 2) Org_OrganizationID (PK) OS-UnitAddress (Table 3) Unit_UnitAddress (PK) Scenario: (1)GoC_GroupOfCompanies has -one to man...more >>

Hi experts, having a parent-child-table with the columns child_id, child_name, parent_id in SQL Server 2005 I just cannot create a parent-child dimension in BI Dev Studio. Can anyone give me some hints? The Dim Build wizard doesn't create the hierarchies, manually setting "parent" property ...more >>

Dear Friends, Suppose a database (SQL SEVER 2003) is consists of 500 Tables & 1000 Views. As I understand from the theory, that Views are nothing but the queries stored in the databse. Whenever a view is referenced than it starts fetching data from tha database. Thus , it will force the proces...more >>

Dear Group I'm having trouble with the statement below. I tried CASE and IF without success. What I'm trying to do: There is a field in the database called Business_TelNo. If the field has some value, I would like to return a generated field (LaBusinessTelNo), which is the label of Busines_Te...more >>

I'm writing a VB6 app which calls several stored procedures on my SQL Server DB. The first stored procedure must complete its inserts before the second stored procedure can query the modified table for its results. My problem is that the second stored procedure occasionally returns a differen...more >>

I?m getting an error when I execute a stored procedure which is try to insert a row to a table. The error is: Server: Msg 1934, Level 16, State 1, Procedure SRV_SP_IS_EMRI_SATIRI_EKLE, Line 32 INSERT failed because the following SET options have incorrect settings: 'ANSI_NULLS.'. In my sp,...more >>

I'm trying to order a varchar column first numerically, and second alphanumerically using the following SQL: SELECT distinct doc_number FROM doc_line WHERE product_id = 'WD' AND doc_type = 'O' ORDER BY CASE WHEN IsNumeric(doc_number) = 1 THEN CONVERT(FLOAT, doc_number) ELSE 999999999 END,...more >>

Hi Friends, I have tried almost everything but I cant seem to shrink the transaction log. Executing DBCC SQLPERF(LOGSPACE) gives me this info: Database Log Size (MB) Log Space Used (%) Status MY_eems 368.49219 16.034182 0 I made a complete backup of the database an...more >>

As an example, I am building an authentication mechanisim that will use data in the 3 left tables to determine rights to objects in a destination table, diagrammed below. In this structure, multiple records in the left tables will point to multiple records in the right table. Normally, I would a...more >>

Is there a neat way to find an ordinal value from a table, for example the median or 95th percentile value in a column, without walking through the table in ascending or descending order? Thanks, Jim Geissman Countrywide Home Loans...more >>

Hi : Can i call 2 procs within one task? I have sp_proc1 ? (and have declared one global variable as input parameter) now i have another sp_proc2 which uses same input parameter but if i write two statements like this within one task, i get an error exec sp_proc1 ? exec sp_proc2 ? I...more >>

We are installing an application with MSSQL database at our users place. Now we have two instances of the same database: - developing database, on which we are working at - production database, which is at our user's place. That 2 databases would have to be syncronised. Users will of cour...more >>

I have a "source" table that is being populated by a DTS bulk import of a text file. I need to scrub the source table after the import step by running appropriate stored proc(s) to copy the source data to 2 normalized tables. The problem is that table "Companies" needs to be populated first in...more >>

Hello Chaps, Just a little sounding on removing out of hours from some datetime date that I have. Basically we have a helpdesk that logs calls when they are entered and when they are resolved. Now, if this happens during the day we just subtract one date from the other to give the time it too...more >>

Hi, I am a newbie at all this, but here's what I want to do: We have a very large database sitting on a SQL server that is on a remote computer. I can access it through remote desktop and browse the Enterprise Manager and the DB. What I am trying to do is create a Visual Studio .Net program...more >>

Dear Reader I am trying to design a database. How can I make best Judgement that Indexing (which I am trying to fix during Diagram Desingning process)is ok. I am able to identify the best candidate for the indexing. Below is the details I want to understand: Area ZIP City County Dis...more >>

If I have table1 and table2, which both have the same fields Product and Qty. Can you help me with this query.... table1 has two rows Row 1 Contains ProductA with a Qty of two Row 2 Contains ProductB with a Qty of four table2 has has two rows Row 1 Contains ProductB with a Qty of two Ro...more >>

I have a table with over a million rows and one of the fields contains amounts of money in text format. What is the most efficient way of converting this field to a number format that I can sum on? Regards, Ciarán...more >>

Using SQLServer ver 7.0, two tables: TableA = contains all inventory data TableB = contains four fields: ID, source, date_from, date_to This is where multiple range of dates are populated. Sample 1: 1,'A','9/1/2004','9/30/2004' Sample 2: 2,'A','1/1/2003','3/31/2003' 3,'A','10/1/2004','10/3...more >>

I'm getting a little confused about what is supported in MS-SQL ActiveX and what is Visual Basic and what is VBScript. Can someone please point me to a website, recommend a book or if I've missed it where in the MS-SQL help that deals with the ActiveX supported in SQL. I'm not looking to do we...more >>

Hi, I have a table in SQLServer2000 where e.g. the actual time is insert for every record (smalldatetime). But how do I select every records newer than 90 minutes? /Chris...more >>

Dear Group I admit, this might be a very ignorant question. BOL says about the ntext data type: Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. I've stored a string consisting of around 45.000 characters in a ntext field - done by copying the st...more >>

I would like to reopen this discussion. I need to create this table using SQL that will return this dataset. BRAID RATEDEFID MIN(BRADATE) MAX(BRADATE RATECODE PRODNAME 614 14 12/1/2002 12/4/2004 Rack Beach Tower Terrace 618 14 12/8/2002 12/11/2004 Rack B...more >>

I have added a domain global group to the local administrators group on server running sql 2000 with sp3a. The os on the server is w2k with sp4. The builtin\administrators group has sa rights. Yet members of the domain global group, after they logon to the server through a remote desktop session can...more >>

Hi, Is there any way that calls to sp_addrolemember and sp_droprolemember can be enabled for non database owners and non sysadmin members? This would be very helpful for an application I'm in the middle of developing, in which users have the right to view some data and edit some data in a s...more >>

I am working on an application with a sql server backend. the sql performance always begins great, but decays quickly over time. if i restart the sql service the performance shoots back up. The degredation is gradual and slows to a crawl after about 8 days. During this time I monitor several...more >>

I have a field that contains date information, and sometimes time information as well. I would like to be able to take that date and do a calculation on it. Here are some examples of what is in the field: 01/12/2003 5:04:00 PM 24/11/2003 19/05/2003 6:30:00 AM How can I take that date, ...more >>

I start a full backup on a database at 5pm. The backup job takes 3 hours to complete. While the backup job is running, someone inserts records to the db. Will the backup include the new records? Or in other words, are the contents of a SQL Server backup a snapshot of the database at the start t...more >>

I'm running SQL query to caluclate projected food costs. The calculation is this: (ReportedFoodSales / PlanFoodSales) * FullPlanFoodSales Seems simple enough to me. Using the following numbers, SQL comes up with a different answer than what I do with a calulator. The data types are m...more >>

I have an asp page that opens up a crystal report...however; randomly I either get the report or I get this error: ADO Error Code: 0x80004005 Source: Microsoft OLE DB Provider for SQL Server Description: Connection failure SQL State: 08S01 and its happening alot... Where should I begin lo...more >>

I have 2 tables joined together by the IDs, People and the pets they own PEOPLE ID NAME 1 JohnSMith 2 JaneDoe PETS ID PET 1 Dog 2 Cat 2 Hamster 2 Hamster 2 Fish I have create another where the PETS are in one column separated by semi-colons and removing the dups NEW TABLE ID ...more >>

I have a field that contains codes like fhj#asds kjjljlj#12 And so on. What I want to do is create two new fields (field1 and filed2) that split the original filed at '#' If a field does not contain '#' I would like its entire contents to be saved in field1. Also how do I ensure that I...more >>