Viewing 15 posts - 1 through 15 (of 19 total)
I agree with all the posts that having a MCP, MCSE, or MCDBA does not mean the holder has the knowledge require to do the job. As technical people we...
February 15, 2005 at 10:10 am
You are right about the indexes being one of the keys. Another is size of the data inputs. It is hard (nearly impossible) to "push" the optimizer to choose one join...
February 9, 2005 at 10:05 am
Have you verified that the login is the same through Profiler? Try tracing the application access to the objects and verify the login being used.
June 17, 2004 at 9:28 am
Wasn't my intention to "prevent" access to master. You are correct in that everyone has access to master because the guest account is active in master. My intention was to...
March 3, 2004 at 11:05 am
I make it a habit of not allowing any login to have master as the default DB. I even go as far as creating an empty DB that I point everyone too....
March 3, 2004 at 10:31 am
I agree with Frank. Try getting together with the network admin folks and try to block the attempts with the firewall.
February 29, 2004 at 2:16 pm
If you really want to get fancy and this is a production project, then you could create a small web page that would query for the latest status and any...
February 29, 2004 at 2:13 pm
SQL Server will create the permissions needed for the account during installation, not on subsequent changes.
November 21, 2003 at 10:55 am
A alternate work around would be to add the security group's ID to the db_securityadmin database role. Create a new user-defined role and add that role to the db_datareader fixed...
November 19, 2003 at 9:21 pm
Besides documenting the many issues that often need to be documented, does your new role involve taking care of the daily review of backups, jobs, new users, and any minor...
November 19, 2003 at 9:04 pm
Review the section over SET STATISTICS PROFILE. This command will allow the query to execute as well as return the execution plan.
I also plan on detailing the output over...
July 28, 2003 at 6:57 pm
In the past there has been reasons to set up a schedule reboot process for Windows/SQL machines due to the large amounts of memory leaks which came from some Microsoft...
June 11, 2003 at 4:40 pm
I agree with Steve. Recently had to alter stored procedures to use paging because the amount of information return was in the millions of rows for a generic catch-all user...
June 11, 2003 at 4:34 pm
You have a long way to go. We currently have a 3.8 TB database and while there are some issues with having enough time to rebuild indexes after large 40GB+...
September 16, 2002 at 5:51 pm
select * from information_schema.routines
August 22, 2002 at 9:29 am