I too have experienced ridiculous scripting times, so ridiculous that I cancelled the process that had been running for over 2 hours and generated it with SQL 2000 in about...

As Jeffrey said, it does come down to how important the data is, and how important it be that the data be available. Importance has a direct relationship with the...

We use Idera SQLSafe. While it is not perfect, it was the best solution, in my testing, when we were looking for an enterprise solution in 2004. It continues to...

Sent a PM with screen shots attached.

Thanks,

Chris

Sorry, I see pages 1 through 3, but I see the same list of threads on every page. It doesn't actually change the page content when I go to a...

I have to balance management with performance. The view in question comes from 4 different tables of HR information. I try to avoid column-level rights wherever possible, because while it...

So I tried to give it a hint, by adding a default to th email vauem

It performed the same whether I used "user@domain.com" or a legitmate email address.

I also tried...

Recompile was one of the first things I tried. It did nothing for the performance. I saw the thread on SQLPerformance.com forums about parameter sniffing, but have not yet tried...

Not sure what other place you speak of. All of this testing was done on one DB server and 2 DBs. The performance is identical between the 2 DBs even...

There are several manufacturers that offer encrypted USB drives, and even fingerprint identification on the USB drive. Lexar is one. As far as encryption for an existing, put in the...

Just went through this myself.

See: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=347813

In my case, query hints would help a lot, but constructing the TSQL query within the procedure and executing with sp_ExecuteSQL made it...

Update:

The MS response on this situation is that this is how the optimizer works. Because it does not have the actual value at compile time of the procedure, even though...

Tweaking indexes may have slightly changed the execution plan but did not speed anything up.

MS is stumped so far. I have sent them a bunch of information they requested by...

At this point I can't do anything with indexes on my view. I am running SQL 2000 STD edition, which doesn't support that. Also, when we looked into indexing views...

Kevin, taking your suggestion and putting the sub-queries into joins, I sped up the return of all records, 16,500, by 25%, Initial 8 seconds and subsequent 6 seconds, vs the...