Actually JDE went to an even better solution shortly before they were purchsed. We built images on a SAN and had each client connect to a LUN there. They could...

To handle individual tables, you can rebuild the clustered index, which will remove the data around and reassemble it with less fragmentation. However, you want some fragmentation in the tables....

It's definitely IO. Is this SQL 2000 or 7? 7 will be worse, but in either case, you can make the change in EM and then hit the "script button"...

When you see the "Please Log In", have you tried F5?

I never have an issue in Firefox or IE 6 on this machine. Need to check IE 7 on the...

Can you clarify what you need to store and where it comes from? Is it the value inside the page somewhere? If so, you need a parser to parse the...

You might want to check out more of a coding site for this. Like http://www.4guysfromrolla.com.

The other thing is I've used the free ASPEMail component that seems to work better for...

Check this out:

http://www.sqlservercentral.com/columnists/sjones/20010424135929_1.asp

Charindex or patindex will work.

The other thing you can do is write some obfuscation scripts and backup/restore production, then run the script to change data that might be identifieable, names, SSNs, salaries, whatever.

Keep in mind that this uses 1434 to find them and lots of routers are configured to block this after Slammer (it used this as well).

Finding instances can be hard....

Under the Logins tab, under security, you may have Windows groups listed. I.e., BUILTIN/Adminstrators is added by default as a login and given SysAdmin access. This means you don't need...

Thanks and I'll pass along.

New format coming Monday (1/1/07), so I'd love to hear comments.

Steve

Sorry and apologies for the issue. Not sure what's wrong, especially since the login and forums are all .NET code. We have had some session issues reading articles since that's...

Is this SQL Server 2000, Standard or Enterprise?

Please let us know which version and then what the issue is. If this is a performance issue, has it always been this...

Please clarify and include the type of application you're dealing with. .NET and OLEDB/ODBC apps would connect differently.

If you want to force people to move to procedures, you need to...

You can use the ROUND function to change things in a query or even convert to a char and then use SUBSTRING, but ninja is right. Do this in the...