I would like to confirm with you guys: If i have 64 bit sql server with 20G
of memory, should I mark 'Use AWE to allocate memory' on 'server
properties'-->'memory' window?

i was wondering what an upper limit for SQL Server performance i should be
looking at.
i googled and found this article for SQL Server 2000:
http://www.sqlmag.com/Article/ArticleID/16087/sql_server_16087.html

I am trying to solve a problem with a function in a DB I have
inherited.  The database is running on single SQL Server 2000 SP4 on
Windows 2003 Enterprise as a VM.
The function takes a single parameter indicating the record type.  It

I have a SQL Server 2005 Std Edition.
I am running the checkdb command on a Database which is about 71 MB
(mdf file).
How long does CheckDB run. I have been informed that it could run for

I see plenty of deadlocks in my application. They do not happen inside of
transactions as many books like to describe. But:
1. locking mode is serializable.
2. 2 similar update statements collide with each other. There is something

we are rolling out a new SQL 2005 server to replace our current 2000 box,
However one application will install SQL express 2005 as its database during
the install process.
Question

Hi.  I have a 64-bit server that I'm running SQL Server on but I'm not
sure if SQL Server is 64 bit or 32 bit.  I read that the server would
have to be in a WOW mode to support 32 bit SQL Server.  This is an
environment that I recently began working on.  My question is, how can

We just upgraded our production servers to SQL2005 SP2 build 3239 (CU7) and
of course we have some issues. We had a 701 error this morning that I feel
is because of the number of adhoc (dynamic) SQL plans in the cache. I just
took a peek at our cached plans and can see a 5 to 1 ...

I have a SP created in a center DB A.
I created a table in A with one field dbname (15 db names)
DBname
db1

We are trying to trouble shoot a problem and we are not sure what is
the queries that the application sending to my sql server. is there a
way to audit the queries executed by SQL Server?
Thanks

I just bought SQL Server 2005 Developer Edition, it comes with eight
CD's: Three pairs of CD's for 32-bit x86, x64, and Itanium-based
installations; an MSDN Library CD; and...
The other CD (next-to-last in the box) has kind-of a scalloped design

My rant - profiles slow things up when you connect VIA VPN.  I use Source
Safe religiously and don't want the profile - it gets in the way - ho hum,
waiting for the server to synchronize... hmmm, just ate lunch, getting
sleepy, still waiting..., ho hum <snore>.  

I would appreciate any help I can get with my problem
I am a has-been informix DBA trying to get my head around the import of data
into an old version of Sql Server that does not have the latest import tools.
I need to import 70 separate excel files, comprising 1.5 gb of data into ...

I am running SQL Profiler for one of my server.
But when I m giving the server name to connect, i am getting the error
as:
" In order to run a trace against SQL Server you must be a member of

I am running SQL Server 8.00.2039 SP4 on Win 2003 SP2 and want to monitor my
SQL Server by setting up couple of SQL related performance alerts, so that I
know how SQL server is doing .Is there a way I can setup query threshold (how
many queries are being processed at a given ...