Hi,
We have a pretty large database with Transaction Replication to a secondary server (pull subscription). Some tables are starting to get pretty large so I want to partition them.
On some tables, I have to recreate the primary keys with a new column used for the partition schema.
The...
Hi,
I have a table (ParentVal) with four child tables (ParentValA, ParentValB, ParentValC, ParentValD) each with foreign key constraints.
ParentVal has 15000 records
ParentValA has 1000000 records
ParentValB has 2000000 records
ParentValC has 15000000 records
ParentValD has 30000000 records...
I'm wondering if I'm going about this correctly...
I have a data file on the PRIMARY filegroup located on drive H: (100gb 1/0 etc...) The data file is getting close to 100gb so I had IT add another drive to the server.
What I want to do is stop the growth on the H: drive and start writing to...
I have a record with an xml data type field. The value starts out raw, basically just a "<mynode />". I also have some procedures that handle related records (in the thousands) and it checks whether to perform taskA or taskB and add an attribute to the xml.
Does the xml dml have some way of...
Hi,
I'm running this fairly large web project (aspx/c#) on VS2003. The issue I'm having is when I debug and attempt to stop debugging, two things can happen...
1. The IDE disappears as if I clicked on the X instead of just the "stop debugging" button.
2. When the IDE doesn't disappear (after...
I'm maintaining some legacy code that doesn't seem to work correctly...
An ActiveX dll was created a while ago in VB6 to process some data in the database. This dll is imported into a VC++ (visual studio .net 2003) project with the #import directive, but when it attempts to create an instance...
I am wondering if there's something similar to what's on 2000 that'll give me some minimal server side debugging capabilities.
I don't want to install vs.net on the machines running simulated production environments but it would greatly help if I could somehow see what's going on in the...
Hi,
I've just been given administrative control of a machine with Windows 2000 server that people use to run various software to test with.
While doing a clean-up of one of the HDDs, I tried to delete one folder and got a message:
"Cannot delete Nul: the parameter is incorrect."
I opened a cmd...
What would be the oracle equivalent of the following?
if exists (select * from dbo.sysindexes where name='myindex_idx' and id=Object_id('dbo.mytable'))
drop index dbo.mytable.myindex_idx
go
I've tried
if exists(select * from user_objects where object_type = 'INDEX' and object_name =...
I have a string object as follows
"abc
def
ghi
jkl
mno"
I would like to transform it into
"abc
def
ghi
jkl
mno"
I'm not familiar with regular expression pattern matching so I'm asking here.
I tried something like
text = text.split(/^\r\n/).join('');
but that doesn't do anything.
Any help...
I just finished reinstalling XP pro on an Athlon XP 1700+, Shuttle AK31 MB, 40 Gb Seagate barracuda (3 partitions), GeForce 2 MX, Fortissimo sound, 538TX NIC, USR modem, 256MB ram...
It kept blue screening and finally with a "can't find registry" error so I formatted and reinstalled. After the...
Hi, I was wondering if it's possible to open up a select element (combobox?) by clicking on another object, as if I were actually clicking on the select?
<select id="justATest">
<option>this
<option>is
<option>just
<option>a
<option>test
</select>
....
<button...
I'm running a few machines hooked up to a linux firewall/nat server. On occasion, I like hosting a game, and I have setup several port forewarding rules to do so. However, in order to get the external ip (24.xxx.xxx.xxx) from a windows machine, I need to open a browser, login to the web admin...
I have a div with its overflow set to auto. Inside, I have a table with several rows (10) but I only ever want to show 4 rows at a time so the height of my div is 100px.
Is there a way to always have the last row showing at the bottom? If yes, then how?
sample
code
<div...
Hi. My home setup is as follows...
I have a Linux Firewall/nat (smoothwall 1.0 + any updates) setup as the server, 192.168.1.100-150 for DHCP. This is hooked up to a Netgear switch. One machine runs Windows XP-Pro with static IP. The other machine runs Win98SE with static IP. My laptop has...
I have a page with several elements, ranging from tables to inputs of type text, checkbox, button etc...
I have a div created at the start with the following properties, style="position:absolute;top:0px;left:0px;zIndex:100;visibility:hidden"
What I was trying to do is change the...
I'm using a
<button class="..."><img src="..."></button>
the class removes the the border and background of the button, sets the size for it and places the cursor as a hand.
I'm doing it this way because it is accessible when using the tab key and activates when the...
I have my document with lots of controls and I'd like to have the cursor use the 'wait' style but I've not found any way to have it like this for everything in the page.
I can always set anything to use the following while processing something
object.style.cursor = 'wait';
then when finished...
Hi, I'm looking for information on whether it's possible to add a row in the middle of a table. Ex. my Table contains 2 <tr>s, add a <tr> between the original two. The cide below just appends to the table but I haven't found how to insert after the indicated row...
[code]
<!DOCTYPE HTML PUBLIC...
What am I missing here? btw, this seems to only work in IE, which is fine for the moment...
<html>
<head>
<title>Language selector</title>
<style type="text/css">
div.lang{
position: absolute;
visibility:'hidden';
font-size: 10px;
float: left;
border: 1px solid #000000...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.