all groups > sql server (microsoft) > may 2007 > threads for may 8 - 14, 2007
Filter by week: 1 2 3 4 5
OS/Data/Logs all on RAID 5
Posted by cricketweb NO[at]SPAM gmail.com at 5/13/2007 12:28:07 AM
A new server has been configured where I work and the OS, SQL Server
Data and Logs have all been put on a Raid 5 array. I challenged this,
and got told this "is the best way of doing it in regard to
performance" by a senior DBA. This server will contain over 40 fairly
large databases, and is a p... more >>
How to update selected rows in database? Please Help
Posted by Sand at 5/12/2007 5:07:52 AM
Hi,
I have the following code.
Code Snippet
Private Sub BtnUpdate_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles BtnUpdate.Click
Dim a As DataTable = CType(DgvCnts.DataSource, DataTable)
Dim changedRows As New ArrayList ' retrieve changed rows
Dim ... more >>
DBCC INPUTBUFFER results into table
Posted by Tom at 5/9/2007 4:04:33 PM
Does anyone know if there is a simple way to get the results of a DBCC
INPUTBUFFER() request into a table? I have a process for monitoring
activity that will give me the results of sp_who2 into a temp table,
and want to scroll through the active connections and get the input
buffers into anothe... more >>
Adding a named instance in SQL Server 2005
Posted by Dan Gray at 5/8/2007 6:30:44 PM
I already have SQL Server 2005 up and running on a server. We have a new
program to install that requires a specific name for it's named service.
How do you install another named service in SQL Server 2005, run setup again
from the install CD?
Thanks
... more >>
Basic Table in SQL Server 2005
Posted by Sabir at 5/8/2007 12:42:36 AM
Hi,
Could someone tell me how to create a basic table in SQL Server 2005
using Enterprise Manager?
Thanks,
Sabir Barkaat
... more >>
|