How to capture ROI ?
Thu, 23 Oct 2008 22:10:17 -0700
If I am going to buy SQL Server , how do I show ROI ? I have heard people
talk about ROI over 3 years and breaking even in 1 year.. what does that
mean ?
Can someone give me an example ?
...
|
how to insert file to SQL server using VB
Thu, 23 Oct 2008 21:13:00 -0700
HI all
How do i insert fixed length text file which contains many rows of info to
SQL table using VB?
Thanks ...
|
Keep tempdb with data.mdf on 14 spindles RAID 10 or move tempdb on its own 7 spindles RAID 10?
Fri, 24 Oct 2008 00:00:05 -0400
I wanted to move tempdb to its own drive but IT says keeping it on a
14 spindles RAID 10 would be much better than putting it on
a different 7 spindles RAID 10.
Is IT correct?
It's a SQL 2000 Enterprise edition server and with perfmon tempdb
has 90-95% of the transactions/sec vs the user databases. The te ...
|
Pending Reboot Requirement
Thu, 23 Oct 2008 18:04:15 -0700
We are trying to uninstall a database on a SQL Server 2005 box, and I keep
getting a 'Pending Reboot Requiment' message which prevents me from going any
further.
Some posts suggested I clean out the PendingFileRenameOperations values key
from HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Mana ...
|
SQL 2005 installation problem
Thu, 23 Oct 2008 20:10:54 -0500
Hi folks,
I have windows 2003 enterprise x64 edition (sp 2), when I tried to install
sql server 2005 enterprise edition (evaluation) it fails to install. I got
the message " SQL server service failed to start." and it rolls back the
installation.
TIA
...
|
Index Usage
Thu, 23 Oct 2008 22:06:01 GMT
Is there a script that you know of, or query against a DMV(s), that would
return all the stored procedures that use a given index?
I have the following that gives me the index and the table (object) it
belongs to, and the index usage (scans, seeks, lookups and updates), but I
would like to know where (on what ...
|
SQL Server 2005 Bulk Insert
Thu, 23 Oct 2008 14:57:12 -0700 (PDT)
HI my name is Bhavin, and I want to insert the data from CSV file to
SQL Server 2005 Database. I am using SQL Bulk insert command. But I
have problem will adding the data to the databse
Here is the code
BULK
INSERT CSVTest
FROM 'c:\csvtest.csv'
WITH
(
FIELDTERMINA ...
|
|
|
SQL Server 2008 Question
Thu, 23 Oct 2008 14:49:01 -0700
Hi all,
Does SQL Server 2008 comes with 32-bit and 64-bit? Where can I find
information about 32-bit and 64-bit for SQL Server 2008? I could find this
information with SQL Server 2005, but couldn't find any for SQL Server 2008.
Thanks a lot in advance for any help.
Han. ...
|
What about backups appended to an existing backup set?
Thu, 23 Oct 2008 14:43:47 -0700
Are the daily backups (and t-log backups) added to a single backup set (all in the same file) overwritten automatically after they expire?
Thanks,
B Atwell ...
|
Cleaning up expired pieces of a single backup set
Thu, 23 Oct 2008 14:31:49 -0700
This thread talks about using a cleanup task to remove old backup files. What if you append the new backups to a disk based backup set? How do you get rid of the contents of a backup set that are expired without overwriting the whole set? ...
|
