all groups > sqlserver server > february 2006 > threads for sunday february 26
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
Table Size
Posted by rupart at 2/26/2006 10:40:26 PM
Hi,
Is there a way to get table size? I want to find out which tabel using the
most space. I saw there is a way to estimate the size with some formula and
calculation but i believe there must be some sp_ or other method to get the
exact and accurate table size.
TIA... more >>
Table partitioning in SQL Server
Posted by sai at 2/26/2006 10:13:59 PM
Hi All,
Can some one tel me if SQL Server (Version 8) has any built in
table partitioning features or we need to code on partitioning the
table.
i have a table in which columns are created dynamically. Sometimes,
the total number of columns exceeds 1024 columns (max columns allowed
in ... more >>
networkIO and 100Mbps NIC
Posted by Hassan at 2/26/2006 9:37:33 PM
I see a lot of networkIO in waitstats . Does that mean I need to increase my
NIC to a 1Gbps ?
Whats a better way to find out if I am pushing too much on my n/w interface
card ?
... more >>
shrink and reorg of DB
Posted by sat at 2/26/2006 8:22:18 PM
Whats the basic diff betn shrink and reorg..
Can the 2 be done one after the other on a single db.
Rgds,
Sat
... more >>
MS SQL 2000 license
Posted by Win at 2/26/2006 12:24:28 PM
Hi All,
I am new to MS SQL 2000 and would like to get the license
information of the product. My company currently decided on MS SQL 2000
(not MS SQL 2005) and would like to have it as a database that provides
data to the general public on internet. I wonder what edition I should
get? It... more >>
SQL Server 2003 Reporting Service
Posted by Spin at 2/26/2006 10:51:09 AM
Experts,
Does the SQL Server 2003 Reporting Service need to be installed on the SQL
Database server itself or can it be installed where just the SQL client
tools are installed. Secondly, does it require SQL 2005 or is SQL 2000 good
enough?
--
Spin
... more >>
Service account credentials
Posted by yba02 at 2/26/2006 3:36:27 AM
Hi,
SQL 2000 is running on a cluster in a 2k3 AD.
What is the safest way to change SQL service account passwork without
affecting anything else, having the fact that that service account is a
member of backup operators group.
Thanks
Yba... more >>
Inventory system.. Reads and writes
Posted by Hassan at 2/26/2006 12:01:03 AM
How does one go about building a highly transactional inventory system where
one goes about searching , adding and decrementing inventory..?
Can one share their high level architectural design ?
I am afraid of intensive blocking . When one goes about buying an item from
an inventory, how d... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Can we result a xml when we query in Sql2005
Posted by ad at 2/26/2006 12:00:00 AM
When we use select from a table in Sql2005, it reult a tabulate table.
Can we result a xml when we query in Sql2005?
... more >>
Newbie question
Posted by Joe at 2/26/2006 12:00:00 AM
I noticed your reply to Alison - having the same problem. How would I enter
the code you gave
select
table_schema
from
information_schema.tables
where
table_name = 'ascis_acadyear_setup'
into visual studio?
... more >> |
