SQL Server 7.0 - multiple processors
Mon, 29 Sep 2008 13:21:00 -0700
Does anyone know if SQL Server 7.0 supports multiple processors and or
multi-threading?
Thanks! ...
|
Locks - For How Long?
Mon, 29 Sep 2008 16:26:33 -0300
Is it possible I verify for how long a lock exist?
Thanks!!!
Felipe
...
|
using synonyms and aliases
Mon, 29 Sep 2008 09:52:53 -0700
I'm starting to explore for the first time the use of synonyms and aliases
on SQL Server 2005, to avoid having to hard-code server names in stored
procedures that do cross-server queries and joins. Books Online is rather
terse on the subject.
Anyone know of a good online tutorial or discussion? Basically I ...
|
Convert Field containing comma-separated text to fields?
Mon, 29 Sep 2008 09:15:01 -0700
Hi. I have a column named 'Departments' which contains a comma-separated
list of integers (i.e. - 1,2,6,10,25).
I want to write a SELECT statement where I can pass-in the integer I'm
looking for and retrieve that record. For example (this is just pseudo-code):
SELECT * FROM table WHERE @myinteger IN (Dep ...
|
is drop column always metadata-only?
Mon, 29 Sep 2008 09:07:02 -0700
For simple data types like int and char(), is dropping a column always a
simple metadata operation - assuming the column is not indexed, not an FK,
etc?
Have some big tables to try it on ...
(yes I should know this already, but I'm not certain)
Thanks.
Josh
ps - and if it is metadata only, what's ...
|
finding most time consuming sql statements
Mon, 29 Sep 2008 08:09:00 -0700
I am an Oracle DBA who has to support SQL SERVER 2000 databases. I need to
find most time consuming SQL statements in SQL Server 2000 Standard Edition
databases. It seems one can get this information from SQL Profiler tool, but
I want to find is there any other way.
1. I am sure this information is in data ...
|
Can not acces SQL "database" Performance counter remotely with WMI
Mon, 29 Sep 2008 07:47:01 -0700
I have SQL Server 2005 Standard on X64
Service pack 2 plus patch UC4
After apply patch UC4 on several servers I lost the access to SQL
Performance counters using a tool that uses WMI to get the counters. I could
fix many of them except one with the specs above.
On the server logged with admin account I ca ...
|
|
|
Locking Issue - No Locks Left
Mon, 29 Sep 2008 06:20:01 -0700
Hi Folks,
System Information
SQL Server 2000 Enterprise SP3
OS: Windows 2000 Advanced SP4
Cluster
Memory: 8GB
AWE enabled
Min Server Memory: 1,024
Max Server Memory: 3,854
Locks: dynamic
Server Usage: Dedicated SQL Server
Problem: Locking
I have a locking issue that is affecting the application. ...
|
sp_send_dbmail and email encoding
Mon, 29 Sep 2008 03:27:31 -0700 (PDT)
Hi,
I use sp_send_dbmail to send some emails and I have the problem that
one of them has
<meta http-equiv="Content-Type" content="text/html;
charset=ks_c_5601-1987">
and the other
<meta http-equiv="Content-Type" content="text/html;
charset=iso-8859-1">
inside the body (text inserted by sql server) wh ...
|
Low cost SQL Express installation
Mon, 29 Sep 2008 09:43:44 +0200
Hi,
One of our customers has a big Novell network, but want to use our solution
based on a SQL 2005/Express server.
Since they are not interested in paying for 3000 client access licenses to a
Windows server we have to find the cheapest wasy to do this.
Do they need CAL if the clients are not connecting ...
|
