There are two points for fragmentation of database files.

First is FileSystem fragmentation, which occurs in the OS level, when data is added to the database, and it grows, but...

Get some MCDBA books that are Microsoft certified material. They cost a bit, but should include practice questions.

Second thing is to get yourself a kick ass PC and have a...

Read up on the protocols and ports that SQL Replication uses. By default SQL Replication uses UNC file sharing, but can be configured to use FTP. I'm guessing that if...

Checkout BCP Format files. I'm pretty sure that with the BCP command line command and a format file you can skip the first two rows and the some at the...

Nuppers! It won't work in standard edition.

Standard edition will allow you to create the index on the view, for compatibility reasons, but only Enterprise Edition will actually use it.

As...

Just a thought, but is your file always bigger than 14? have you tried setting that number higher, or even reversing the test to

if oFile.Size < -1 then

to make...

There is such a thing as over-normalisation. Use Separate SPROCS for each action, otherwise you won't be able to use sql security to enforce who can do what.

Eg. You...

Go Up the Chain! Get the application layer to strip out the junk data from the inputs before saving it to your database.  Use a Regular Expression, or HTMLEncode functions...

Hmm. There has been some articles here about Application Roles. But basically it comes down to how you have secured your server.

In good security practice, users should not have...

On the SQL 2000 server (A), use the sp_addlinkedserver command to allow you to query the SQL 7.0 server (B).

Then :

Select  TableA.vendorid, TableB.vendname

from A.HFCMaintenanceHD.Vendor_Store_Table AS TableA, B.HFC.PM00200 AS TableB

where...

Bobs example has the correct test. Don't use DATEDIFF(yyyy to determine someones age! Add time difference you are testing for to the birthdate date, and compare if it is greater than...

ergh! Text! That aside I noticed in your example code that your output field is not correctly defined. It should be something like:

CREATE PROCEDURE [dbo].[test]

   @var text OUTPUT

AS

 -- Some SQL code

GO...

Steve is probably right, bandwidth is usually the issue with VPN's or implementing the wrong sort of VPN (such as software VPN's instead of VPN's on a dedicated router).

As far...

You can restore a database from Enterprise to Standard version of SQL Server.

Note however that Enterprise only features won't be enabled in the database when it is restored on the...

Are you using the Windows Scripting Host Scripting.FileSystemObject to achieve this?

If so, make sure you specify the full path for the file destination, otherwise it won't what directory to put...