I have a 4x quad core. Both Data & nc Index files are on the same 12-Disk Raid 1+0, each within their own separate filegroups. I have the data...
Using the following configuration, which one gets the Raid 10 on the server? Server: Raid 1 for the OS 4-disk Raid 10 (temp db or trans logs?) Drive...
Inside my db's filegroup I have one file per processor core. Should I also create a separate filegroup for index and create one file per proc core in...
I have no experience with Sql 2005 and am finally jumping into from Sql2k. Setting up a brand new install for client of mine and would love to hear...
How would I pass a table variable into another proc?
What is optimal way to do this? I have table variable with one row of data. I need to pass the columns into a stored procedure. so lets say my...
Have SQL 2000 running on a 3-month-old Dell 6850 w/220 drive shelf, Dual 3.1 Xeon, 4G Ram. The machine is a little monster and runs well. We hit is...
Hi Dine, Actually Sql 2000 does not open in a new place. It opens right in the window you are working on at the time. At least in mine it does. So...
Tahsin, Maybe I didnt say this correctly, sorry. In sql 2k query anaylzer, open it up and connect to a db. Now you have an open query window....
Tahsin, Right, but are you saying that there is no option or override to make it so that I can open a file inside that same area if I want to,...
Sorry for posting such a silly question, but for the life of me I cannot figure this one out. In Server Management Studio, when I have a Query tab...
<br />I had mispoken earlier. What I am seeing here is blocking locks, not deadlocks. I can use NOLOCK on inserts?<br /><br /><br />Thanks for your...
I guess my question is: What is the best way to go about inserting 10,000 TEXT rows in about 5-10 minutes, without having mass locking? Thanks
SQL 2000 on brand new Dell 6850, Quad Xeon, 3.1Ghz, 4G Ram, 220S Drive shelf U320's Have large amount of xml coming into SQL Stored Procedure...
I'm trying to parse through an xml doc via OPENXML that is passed into a stored proc. The xml is not using CDATA and the text in some of the nodes...
I have a table that gets changed maybe once every two months. I have several stored procs that call this table via a JOIN all day long (more than...
No, nothing is running. I could have a single blank window connected to the db on same machine and this problem occurs when I try to go up to File...
No, there are no patterns to this. I even tried it with local machine db and disconnected all remote servers. Same thing occurs. Any ideas?...
Has anyone ever seen this? On a brand new install: Windows XP Pro Sql 2k sp3 I have about 6 Enterprise Mangers plugged into an MMC Console, all...
Separate names with a comma.
