I have setup a role as described but for some reason when using Access via an ODBC connection my users still have permissions to tables that I have removed.....Access issue???
Thanks
/jxc
I have a database which contains in excess of 1200 tables. I would like to setup a scripting model which will prevent some users from accessing all but 50 tables. Is there a really quick way to do this?
I have a requirement to move my SQL server databases from 1 volume to another. I can move user databases without a problem by simply using backup and restore. I am not sure however what is the best way to move the system databases which are created on install. Once moved I need to give up my old...
I have a value in a view which I need to convert to a date and time datatype
eq: 199912102359
I have tried the convert function but without success.
Thanks in advance
Just an update....
I have updated the statistics on the W/E and this was definitely the problem. My 5 combined queries (I run them sequentially) took approximately 29 mins on average on Friday. I reran this morning and they completed on average in 8 minutes.
Thanks again Terry for alot of...
Yes, There is only 1 index on this table.
I double checked the execution plan to ensure that it was using the index. All the where clauses point to elements in the index.
Thanks
/jc
Now I'm confused the stats seem to indicate that fragmentation is not a problem. Any additional thoughts.
/jc
DBCC SHOWCONTIG scanning 'BudgetsTable' table...
Table: 'BudgetsTable' (205399951); index ID: 1, database ID: 8
TABLE level scan performed.
- Pages...
Hi Sorry I didn't get back sooner but too many projects and not enough hours.
It appears as though I may have 1 of 2 problems. Many rows added recently or statistics. As you suggested the indices may be the culprit. This table has increased its rows going from 1.5 million rows to over 8.5...
Thanks for the response...
I'll try to answer the questions based on what I know now and I will check a few things that I have not thought about.
1. Absolutely consistent..
Query 1 will range from 1-1.5 mins
Query 2 will range from 5.5 - 7.5 mins
2. Cache Hit....I'm checking
3. No locking...
I have 2 queries which are almost identical except that the criteria is slightly different.
The first query Accountid = "Project1" returns 262,000 rows completes in 1 minute. ( Database has 9,000,000 rows )
The second query Accountid = "Project2" returns 182,000 rows...
I may be wrong on the efficiency of a sparse index however Here is what I am trying to accomplish and thank you for your patience as I was not able to respond last week.
I have a main table with a key that joins to four views.
The four views are of the same table and I do this in order to...
Can you create an index on fewer entries then the rows in a table (sparse index). I have a table with 30,000,000 rows and would like to have an efficient way of querying the data.
Signed
newbie to sql indices.
We have recently changed our SQL server from NT security only to mixed(NT and SQL logins). This has caused a problem for our NT logins which were used by the Veritas netbackup client. The SQL activity log simply shows login failed for the NTlogin account used by Veritas. We have tried...
I am trying to prepare data for OLAP and was wondering if anyone is using a specific tool to denormalize their data.
If you are using the tools within MS SQL, perhaps someone could provide an example of a query or DTS package.
Thanks
/jxc
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.