|
unit of waitime in DBCC SQLPERF(waitstats)
Is the unit of waittime in ms ? or secs ?
...
Fri, 24 Dec 2004 13:09:20 -0800
|
How to use cp855 endoded text in a database?
Hello,
I'm trying to enter a text encoded in cp855 in a table field which must
be defined as char. The cp855 encoding is 8-bit encoded text. This
text, will then be transfered into a POS terminal and display localized
text. I'm having problems settings up the correct collation and the
method for entering the ...
24 Dec 2004 07:51:40 -0800
|
Reported space usage is inconsistent in EM, sp_spaceused & sysinde
What is a reliable accurate method for determining space usage of an object
in the database?
My SQL Server application needs to be able to accurately report the
percentage of freespace available in a filegroup. To do this, we need to
accurately obtain space usage metrics from SQL Server. I have compiled ...
Thu, 23 Dec 2004 11:53:03 -0800
|
Database Design
Can anyone tell me what the effect would be of restoring a filegroup from an
older date than the other filegroups in the database.
The tables in the older filegroup contain fewer records than the current
one. My main concern is that the sysindexes table will still contain
reference to a greater number of re ...
Thu, 23 Dec 2004 20:58:08 +0330
|
MSDTC in Cluster Group
Why is it a bad idea to have the MSDTC Resource in the Cluster Group, even if
the MSDTC has its own IP Address and Network Name?
In my planned multiple instance sql cluster, I can see giving up a physical
disk to the Quarum, but another disk to MSTDC as well. Since the MSTDC
doesn't use tons on disk spa ...
Thu, 23 Dec 2004 08:49:09 -0800
|
Checkpointing Not Happening in Simple Recovery Model
The server is Windows 2003, SQL Server 2000, sp3 Standard Edition.
We have at least two databases on this server in simple recovery model. Of
course, one of these databases is tempdb so this is very problematic.
The transaction logs just keep filling up and filling up, growing to max,
and finally become ful ...
Thu, 23 Dec 2004 10:39:42 -0600
|
sql server 2005 availability
Thanks for all the input. Everyone here seems to agree to use the DBCC
SHRINKFILE option.
However, after posting here, I sent an inquiry to my vendor and they are
suggesting the DETACH/ATTACH option to create a new, empty log file.
Is there a downside to either option?
NOTE: The vendor is not for our ...
Thu, 23 Dec 2004 11:31:18 -0500
|
...
|
Transaction Log ENORMOUS!! Help
Is there any way I can give user permission to run SQL profiler witout giving
them sysadmin access
thx220 374310 <8A7277EA-004A-455D-97AF-09026913CD7F@microsoft.com>
Thread-Topic: SQL memory leak or need more RAM?
thread-index: AcTo90trbkzkSoBtQOGqpJZOBjIBMg==
X-WBNR-Posting-Host: 64.179.35.121
From: =?Utf- ...
Thu, 23 Dec 2004 06:03:03 -0800
|
SQL memory leak or need more RAM?
Hello,
I'm new to SQL but I have noticed that when its loaded fresh, its memory
consumption is low. However, over time, (a day or 2), it will suck up MOST
of the server memory (1 GB) with no (or little) connections to the server.
If I stop the MSSQL, it releases all the memory. Is this a memory leak?
...
Thu, 23 Dec 2004 05:29:06 -0800
|
Recover data from Tables Sql2000
Good Morning,
We have a Win2003 server with SQL2000 running on it. We have an Access Order
Entry application front end with the back end on a database. I was updating
some product pricing in our database and I accidentally DELETED about 360
products. I imported a table with new pricing, and I was updating th ...
Thu, 23 Dec 2004 08:05:49 -0500
|
Question about stored procedure
Hello.
I have such question:
I have created stored procedure which takes one parameter, when this
parameter is 0 I don't want to include it in WHERE, so it must be used only
if it is not equival to 0.
How can I do this?
Here is a simple of stored procedure:
----------------------------------------------- ...
Thu, 23 Dec 2004 14:52:11 +0400
|
SELECT TOP 1000000 from partitioned view
I created a partitioned view where I have a check constraint in the columns
which is one of the PK columns.
When I SELECT data from the view the execution plan shows that all tables
are accessed even though my SELECT close only need to access one of the
member tables.
I can type SELECT top 100 * from partit ...
Thu, 23 Dec 2004 01:39:02 -0800
|
Importing data from Btrieve to SQL - Migrating data to new SQL ser
I have an old Btrieve database written by some programmer in the distant
past. It's currently running on an old 3.11 novell server. That applictation
being updated every day.
I need to get that data out of the old Btrieve DB and into a new SQL
database.
What an easy way (tool) to migrate this data over int ...
Wed, 22 Dec 2004 21:07:03 -0800
|
error - microsoft jet database engine can not find the object tabble_name
Hi,
I try to export my data from sql server to excel, when i preview the
data, it all runs fine. When i run export, it prompt me this error. How can
i ensure this object is exist? and how do i verify this error? In the
enterprise manager, i can view the records for my table.
--
Thank you very much ...
Thu, 23 Dec 2004 12:49:28 -0800
|