Hi I'm baffled by this one. I have put an index on one column. When I query the table using the indexed column in the where clause it does not use the index(slow). If I put "(index=ix_tbl_col) where col = 2 " it does Correctly use the index and is much faster. I've run dbcc checkdb, up...more >>

Hi everyone, it seems to be something really simple, but I'm hitting the wall here. Where does sql 2005 actually keep stored procedures code? The issue is: When I change the code of SP from SQL Management Studio it works fine. I can modify code without any problems. But when I connect to sql se...more >>

Hi, I was hoping someone would point me in the right direction. I have table with a few million records. Each record has a timestamp field. I want to be able to calculate what is the average time between all the timestamps in the table. It is further complicated by needing to remove from the ...more >>

I have three date parts namely, Year Month Date/Day as integer values stored in one column each in a table in a SQL Server 2000 database. I need a function to serialize/compose/create a datetime type out of them so I could use that in a query (pseudosyntax) as below: SELECT CreateDat...more >>

Hi can anyone help me with this? I have would like to be able to output some data in a very specific way and unfortunately my SQL isn't quite up to it. The database is not SQL Server so in this case only SQL can be used. I have 2 Practically Identical tables that record test results from ...more >>

Hello, I want to use SQL Query analyzer to... For a group of records matching a specific criteria I want to move values from Field1 to Field2 and change Field1 to Null. BTW: Is this the right news group for SQL questions? Thank you, dbuchanan ...more >>

Hi I am looking for info. on how to synchronise a database on SQL Server 2005 Express, to SQL Server Mobile on my PDA. I want to have an application which can either update the data on either version, and have them synchronise back to each other. Can anyone point me in the right direction...more >>

I Installed SQL Server 2005 developer without specifying anything, hence I missed the samples. I then re-run part of the installation specifying the sample databases and scripts. Now the situation is that I have the AdventureWorks and AdventureWorksDW databases, I have the SQL Server Report S...more >>

Good day, I was just reading the minimum requirements for the SQL Server 2005 versions and was floored to discover that SQL Express will not run on Windows 2000 Professional (http://www.microsoft.com/sql/editions/express/sysreqs.mspx). Could this be a typo?!?!? SQL Server 2005 Workgroup a...more >>

Friends, I have a wierd query, atleast wierd for me. I have a stored procedure where I am passing parameters and updating a record. It may happen that not every column values is being updated. Before firing the update statement I want to have name of columns, that are going to chan...more >>

I am trying to figure out how to make a column in SQL 2005 Express case sensitive. I am a little lost on where to set it to what as a has a different meaing / value than A and so on and so forth. Collation ? But which and where to set ? Thanks Chris ...more >>

Hi, I have a table called A and another Table Called B. A table has the following Column and Values ID One Two Three ---------------------------------------------- 10 test01 test02 test03 11 test11 test12 test13 12 test21 test22...more >>

Need monitoring tool for the SQL Servers what can monitor 15-20 SQL Servers together and at least check the following: - structural integrity/other DB errors; - query blocking; - DB/Log size increasing. It would be perfect if tool can help to find out the reason why it have happen; - it w...more >>

say i want to produce a report for a video rental store showing all customers and how many movies they rent from each genre. i want a report that looks like this: [Customer Name] [Drama] [Action] [Comedy] Rick B 2 17 0 Tracey K ...more >>

Hi, Our VB.NET program onnects to SQL Server SP4 via OLEDB. When we open a connection and then we have a network interruption of min 10secs during the open connection (what happens sometimes at the customer site), we get a General Network Error when we try to execute the next query. Even when...more >>

What are the performance limits and how do they manifest themselves? Our school is running a database on MSDE (about 3 years old) and users are complaining of performance degradation - freezing, hiccups, etc. The main .ldf is now 2.3GB big which I understand to be above the limit. I never see m...more >>

I got MSDE in my web control panal with database name and admin user. i don't know how to create table or select from the table. i need snipt codes to create a table. thanks in advance ...more >>

Hello all, One of our databases ate up about 9GB of a partition which caused havoc with several network processes (like cannot print,etc). Normally, I detach the database, delete the log file and then reattach and let it recreate the ldb file. All has been working great. The problem is that...more >>

We are using Sql Server 2000 on a dual processor machine. On one sql connection there is a real time application executing 5 queries every 100 milliseconds. On a second sql connection there are queries that take 2 seconds to execute every 10 minutes or so. The problem we have is that when...more >>

DELETING 100 million from a table weekly SQl SERVER 2000 Hi All We have a table in SQL SERVER 2000 which has about 250 million records and this will be growing by 100 million every week. At a time the table should contain just 13 weeks of data. when the 14th week data needs to be loaded the...more >>

After a restart, the server will run ok for a few minutes then hit full memory usage. we have plenty of memory and only a small intranet app running. We do have some large unused databases What can it be? thanks ...more >>

I am doing my own dating site. I will like to add the functionality similar to other sites. Where a user can make a search to get people near a certain address. I don't know where to start, or if MSSQL provides any built in methods or procedures to do such calculations. Any one with any clue? ...more >>

What is the syntax to allow a user to execute any stored procedure or select any view in a database? Thanks ...more >>