Viewing 15 posts - 5,881 through 5,895 (of 7,505 total)
I think you should also include @columnid = 13 in your trace setting to be able to apply a filter on it.![]()
March 6, 2007 at 10:17 am
So far, so good ![]()
how about disksubsystems ?
number of disks ?
type of disks ?
cache ?
rpm ?
write performance ? (ms)
March 1, 2007 at 7:18 am
... Hardware is nearly the same ...
- What are the HW differences ? (ram, disk,..)
- how about filefragmentation (disk level) ?
- If you just create empty objects and load with data,...
March 1, 2007 at 5:48 am
I/O ? Disks,..
How about the filesizes for the databases, are they the same, do they extend the same.
Has the new db been allocate at least the same size as the...
March 1, 2007 at 4:53 am
If you're just performing selects ... from ... without saving the results to variables or into another table, you sp will return it as a rowset.
February 27, 2007 at 1:19 pm
- check the command if parameters exist (hen you've been there already), just alter their values. Avoid the clear.
cmd.Parameters(
"@PIN").Value = pin.number
February 26, 2007 at 1:09 am
... "The user account I am using is member of the domain admins group, so this user should have access to it." ...
that is not the case if you removed...
February 24, 2007 at 9:14 am
if you're not providing values for all columns (except for identities) of a table, you should tell it which columns you're providing (values-order must match columnorder in the column-list ).
insert
February 23, 2007 at 4:55 am
did you add/alter the registry-key ?
Be carefull when messing with the registry !!! (backup before !)
-- HOWTO: Enable DTC Between Web Servers and SQL Servers Running Windows Server 2003
--
February 22, 2007 at 7:53 am
- keep in mind that if the clustered index gets dropped, your data will move back to the filegroup defined at "create table"-time.
- so if you can, create the table...
February 22, 2007 at 12:56 am
Builtin\Adminstrator is the group of local administrators of the server and accounts like local system / local service.
If you remove it, be sure you'r running the sqlserver service using a...
February 21, 2007 at 1:21 pm
did you configure MSDTC ? dcomcnfg.exe
February 21, 2007 at 7:47 am
Great. Sometimes, just sitting and reflecting the problem helps ![]()
Can you share the pittfall ? ![]()
February 21, 2007 at 4:54 am
maybe you should have a look at http://support.microsoft.com/default.aspx?scid=kb;en-us;906954
February 21, 2007 at 12:48 am
this name gets published through the cluster service. So the name will get published at sql-instance-install time.
BOL has more regarding "install a cluster"
February 21, 2007 at 12:43 am
Viewing 15 posts - 5,881 through 5,895 (of 7,505 total)