Could you run Profiler trace to see what exactly takes a lot of time? At least make sure where the delay is: in the database or in the front end

In...

Hi,

What do we know about the application?

- Does it use third-party FullText Search product? Add a lot of space then

- Is it a web app that uses Indexing Service? I...

Carlos,

I did not get any error messages. But then I followed the example in the article directly.

Did you try certificates before? Maybe you did something as an example before in...

Remi and Hans,

Thanks for your feedback. I will use this query then. It will be a line in several quarterly reports, that is why I said performance is not an...

Steve,

Good Job and Good Advice. I read somewhere that if something of a major proprtion happens a DBA should sit back and relax for a couple of hours before he...

Hi,

I am continuing my findings following reading Part 3 of "SQL Server 2005 - SQL Server Integration Services". I do understand it is a pre-release and things may change. How...

Hello Jose,

MS Access and SQL Server have different SQL Syntax for some statements.

How many queries we are talking about?

I would use in MS ACCESS Tools ->Analyze -> Documenter

Click on Queries...

Something Like That ? The HITS table will contain only so many records as the number of original IDs in RESUMES

select ID INTO ##TempTable from resumes  where <search conditions>

Update HITS...

Hi,

The best way will be DTS. The "quick" way is to script a list of bcp commands, see BCP utility syntax in BOL. You may use a query towards sysobjects...

Hi Carlos,

I think it is good to read today's editorial that I mentioned

http://www.sqlservercentral.com/articles/articlelink.asp?articleid=1928

It is like a walk-through, easy to follow. It is what I did. Let us here know how...

Rita,

If you don't have access to system logs then maybe you have access to SQL Server error logs? But if you don't have access to system logs do you think...

Hi,

For the graphical database diagrams with comments I would use ERwin or ER Studio. For the Data dictionary in the table format itself I would use a simple query from...

Nick,

First of all you need to evaluate every one of 60 applications what authentication they use. I did not hear yet that 60 apps use only SQL Server authentication or...

Yes, we did.

The place where you should look first is Windows Security Log. If you will see logon/logoff events every 4 seconds it is Enterprise Manager from another computer on...

Hi Valentin,

When you say Internet do you mean Internet (via proxy) or Intranet (web access on the same network). Also, is user XXX an SQL standard login or Windows login?...