Search results for query: *

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

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

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

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

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

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

Hi Everyone, I have a user / client who created a SQL Job on their dedicated server, so they are set as the job owner, and they have permissions for SQLAgentUser in MSDB, but all of the sudden now, they can no longer edit their job (i.e. Job Steps, etc). We even set the user to...

Greetings: We have an AS 2005 server with SP2 installed. A client is trying to use Pivot Tables with the OLAP cube, however, I guess the "Value Filters" are not displaying for them. According to the following two websites: http://www.microsoft.com/sql/technologies/analysis/overview.mspx...

What is the easiest way to find all numeric and decimal data type columns in a database? I'm presuming I'd select from sysobjects, but not sure if I should select on xtype, or another column, and also what specific column value I should search for to find the data types I want to find. Any...

I am almost positive there is a stored procedure that you can run and input the SQL Account on the system in SQL 2005 where it will tell you the last date the password was changed on that account. Does anyone know what that S.P. is named? -Ovatvvon :-Q

Hi all, The Problem I have a client who is testing their app with SQL 2005. It was working fine in SQL 2000. On the new DBMS, when a query is run (which was not causing problems in SQL 2000), it is giving an error stating: Server: Msg 8152, Level 16, State 14, Line 1 String or binary data...

Hi, I'm running Visio 2003. I try to connect to a db server on the same domain, to have Visio reverse engineer the db, but it is having issues. If I select the MS SQL Server driver, it gives me the following error message after typing in the UID/PWD credentials: The currently selected Visio...

I have little exposure to A.S. There are three security levels: Read Def (which I presume only allows users to read the cubes, etc); Process database, and then Full control. If users need to create cubes, etc, will they need full control? What is the difference between process database and...

I have a client with a table in their database that is 97 GB in size: 12 is the data, 84 is Unused space. I'm unable to shrink the DB. The db is comprised of three columns: 1) int 2) nvarchar(250) 3) float Question: I know int and nvarchar shouldn't be a problem. Does anyone know if...

Hello all. I have a couple clients who have jobs that use CmdExec to run their processes. If I set SA to be the owner of the job, and even if I grant all three SQLAgent roles (including SQLAgentOperatorRole) to my individual client, they cannot edit the job. They can only view it. However...

Hi All, I have a 270 GB database that has a lot of activity on it 24/7. Approximately 30% of the database is unused space. I've tried shrinking it every which way, but can't. It completes successfully, but the space remains. (I can get rid of unallocated space no problem, but unused...

Hi all, As you know, we can select the top or bottom set number of records by specifying something like... Select Top 25 * From someDBname Is there something like mid or middle where we can specify what record to start at, and how many records to retrieve after that? For instance, if a...

I have hundreds of Views and Stored Procedures where I need to add View Definitions permissions to for the Public role for the database. What would be the easiest way to set the permission for each View and SP for the DB Public Role short of manually going through each one in the GUI and...