Recent content by Ovatvvon

Awesome. Thanks! -Ovatvvon :-Q

Hi everyone, Quick question: If a motherboard, such as the "ASUS RAMPAGE FORMULA (x48)" has two PCIe x16 slots, and I want to use both slots, do they have to be two SLI video cards working together? Or, can I use one for a video card, and the other for a disk controller card to setup a RAID...

Ok. I have been using avg. sec/read & write all along. Microsoft recommended % idle time too, which is the only reason I included it, but it seems, like you said, worthless. Any idea what IO's / second should look like, both for DAS and SAN? (i.e. non-cached vs. cached, and I/O's per...

Hi Everyone, For anyone who's used PerfMon (at least on Windows 2003): I used it to collect performance data while users pounded the database. The results came back a bit funny for the % Idle Time counter though. In several cases, the MAX value for all counters was above 100%. In fact, it...

I checked with DBA's for another client who used this solution. Apparently the deal is, if you have a database snapshot on the same server as the source database, it will forward the request through to the source database, except on those rows that have been changed, in which case it will ref...

Hi Everyone, According to: http://msdn.microsoft.com/en-us/library/ms187054.aspx Database Snapshots in SQL 2005 do not provide a "true" separate database to read from, for reporting purposes. Instead, only initial updates at the page level will be stored in the snapshot, but the user will be...

Hi, I realize this is probably a rather stupid question but: Are there any added permissions by assigning an account as a Database Owner (i.e. sp_changedbowner 'user account'), rather than simply giving it DBO permissions within a database? -Ovatvvon :-Q

Jay is correct. I did not mean to give the impression that you cannot install on one side of a cluster. You can. :-) -Ovatvvon :-Q

Hi, When enabling Full Text Indexing on a database in SQL 2005, you can easily enough click the checkbox in the database properties GUI. But if you want to specify where on the file-system you want the FT files to reside, where do you specify that? The only place I know of is in the files tab...

I am not aware of the need to stop the cluster services yourself to install, although during the installation it may bring the cluster down once or twice. Also, just an FYI (in case you don't know), Integration Services is NOT cluster aware, so when your cluster fails over to the other node...

Hi all, We're trying to find a good solution to do incremental updates across databases. I was looking at the Change Data Capture feature in 2008, as well as Merge command for it. Does anyone know if this feature requires the two tables (source and destination) to be in the same database? Or...

This select query runs on our servers, and runs for a few days without ceasing, causing the CPU to run between 90%-100%. I ran an estimated execution plan against it, and 80% of the cost is from an Index Seek, and about 20% is from the sort. I did a rebuild on the Index, and updated the stats...

Recycle SQL Server and make sure you get the first connection...(or wait for the existing connection to end). -Ovatvvon :-Q

CruiseMan, I would try going to Tools, then Options, as it suggests, and look for anything that may be referencing some settings, etc. If you can't figure it out there, worst case scenario is you could just uninstall/reinstall. It shouldn't take that long. Do you have the latest Service...

Gate tec, Right click on the database (HRPERKDB), then select properties. When the dialog window opens, go to the OPTIONS tab along the top. Once there, in the first section, you will see two check boxes, Restrict Access and Read-Only. You're Restrict Access checkbox is checked with the...