Viewing 15 posts - 28,426 through 28,440 (of 39,810 total)
I'd start here: http://www.sqlservercentral.com/Articles/Access
Then there are some Access books I've seen that cover this. I don't have any off the top of my head, but I'd look through a few...
May 30, 2008 at 8:57 am
It can't be 28MB of memory. I doubt SQL Server runs in 28MB.
You must have something else going on with the box. I'd re-open the case and work through it...
May 30, 2008 at 8:51 am
I'd avoid surgery if at all possible. Used to work for an ortho, and they make lots of little mistakes at times, nothing major, but it might cause you issues...
May 30, 2008 at 8:49 am
You can read about it here as well
http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/
May 30, 2008 at 8:43 am
Tend to agree with Alex, but you have to examine where each query is slow. What might be making it slow. Look through query plans, etc.
May 30, 2008 at 8:43 am
Personally I think it might be hard. Most likely we'll have some junior or intermediate DBAs nominating seniors at larger companies.
At the majority of my jobs, meaning 5 or 6...
May 30, 2008 at 8:40 am
I think you'd implement this as T-SQL logic, a stored proc perhaps, and then call that from SQLCMD.
May 29, 2008 at 8:30 am
don't forget to check for pathing issues. I'd get the virtual names and then set the new paths in my restore server for every file using some standard in the...
May 29, 2008 at 8:26 am
Securables are objects. It's not clear what you mean by "permissions (securables)"
It sounds like your other DBA gave permissions to execute all stored procedures. That doesn't have anything to do...
May 29, 2008 at 8:26 am
Specialization tends to happen over time, and it's not just technology; it could be industry or type of company. It's probably more common for development areas than administrators.
I haven't really...
May 29, 2008 at 8:23 am
There's also a wizard in EM that creates a DTS package for you. Use the Import Wizard against the target server.
May 29, 2008 at 8:20 am
All user databases should pick them all up. It's possible that "all" is resolved at design time and picks up specific databases, but I would have thought that was fixed...
May 29, 2008 at 8:19 am
As Matt mentioned, there is lots to look at. The specific query will matter, but indexing is probably more important. Check for indexes on the title or other relevant fields.
Also,...
May 29, 2008 at 8:15 am
Is this a remote or local connection? You might need to set the user and password or perhaps the trusted connection switch in your command or in your file.
http://msdn.microsoft.com/en-us/library/ms162773.aspx
How are...
May 29, 2008 at 8:13 am
A Christopher has mentioned, wrap your query inside another as a sub-select and return only the PKs needed to the outer query.
May 29, 2008 at 8:10 am
Viewing 15 posts - 28,426 through 28,440 (of 39,810 total)