I am trying to tweek several queries for MsSQL.
The same query varies from 2 to 30 seconds.  (
On ORACLE it was consistent.)
Can anyone explain what is going on?

In Performance Monitor, I can't see any of the
"SQL Server:*" in Performance Object field, but the
database runs fine.
What happens?  

Ok, anyone know anything about MySQL? The only way I see to use data within
tables for use in MySQL is to export as text file but I dont see a way to
import the data from the MySQL Console Manager.
Then my next consideration would be a query to create the tables and insert

I'm trying to use the CDW to copy a database from sql 6.5
to sql server 2000 from the 2000 server. Somehow, whatever
password I use doesn't seem to work. Is there something
wrong I'm doing? Does anyone has any idea on what I should

Is there any mean to lock a database from all users in the way that nobody
can:
1. read/write
2. write

I have the following case.
I have two databases in the same server.
First one: OTG
second one: OTG_MA

I have just finished my install of SQL2K on Win2003.  I
want to make a complete backup of the server.  Do I back
with the SQL services running, or do I stop them?

Hi, all
I setup an alert in sql7 that sends me an alert if the DB size rises above
8.5 GB.
I check db allocation size is 8.5GB and data size is 6.5GB. means 2GB free

please, i am receiving an error in log shipping of sql
server 7.0. the message is "could not redo log record..."
i found this message at microsoft, and it says that it is
a bug that ocurs when toy make index operations in the

i wanna move table data from one filegroup to another , i
can do it in Enterprise Manager . can i use script to run
it in SQL Analyzer ?
Your answer is highly apprieated .

This cursor is a select on a large table.  Each update occurs once for
each row.  Does SQL hold all changes in memory on dirty pages until the
cursor is done (or check point is reached) and is this cursor pinning a
large table in memory?

When I run perfmon against the sqlservr.exe process, its
percent of processor time goes over 350% percent.  Is this
a bug in perfmon.  If so, how do I report it?  We are
running a 4-cpu box, WINNT 4 with SQL2K sp3a.

On occassion I have to set close to 100 seperate  
permissions on various objects, and obviously that gets
tedious with enterprise manager.
In my Oracle days I would 1) create a SELECT statement

I have a database in full mode, can i issue a delete
command that deletes a single row bypassing the
transaction log???
Thanks in advance

Hello
I use command OSQL and i have in output file strong
character when i use the command xp_cmdshell
test.sql