Search results for query: *

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...

Anyone know any good rules of thumb for predicting how large a fulltext index will be on disk based on whatever the size of the database / column is? -Ovatvvon :-Q

It actually turns out there was an issue, somehow, with the user's Domain Login being lower case at one point, and upper case at another. We had our Microsoft Premier support guy look at it, and he's writing it up as a bug to Microsoft, so it can be fixed. (FYI: we have had SP2 for a long...

This is a global company, and there are dozens and dozens of databases on each shared server from various groups throughout the company. We cannot/will not give access to the clients on the box itself. That's for our DBA's and Server Admin's only. :-) -Ovatvvon :-Q

I'm uncertain as to the Active Directory setup, since I don't handle that area. This was also for another DBA who sits next to me, not actually my client; but as I understand it, she was able to get it to work by removing the highest level from them. They had SQLAgent Operator Role enabled for...

Ya know, I was just thinking...this is silly. If they're admin's on the box, they should be trustworthy. If they're not trustworthy, they shouldn't be admin's. Am I thinking about this wrong here? -Ovatvvon :-Q