When backing up a database and restoring on another computer, you should reset the database owner when you restore it. The reason is that SQL Server...
Like is used to find strings in string data fields, like a varchar, char, etc. It is good for things like that. However, the database has to load...
As far as I know from the seminars I have been to, SQL Server 2008 has Transparent Data Encryption (TDE). It is available only in the Enterprise...
Yes, you can partition an existing table. Steps (after backing up the database): 1) Create the filegroups for each of the files that will be needed...
I am wondering if table partitioning would be appropriate in this case. Create new filegroups for each of the partitions, with one partition per...
Another question, are they 32 or 64 bit? One 32 and one 64? Is one set to allow only a certain amount of memory to SQL Server (this can be set), or...
I agree, clear the buffers to make sure both are being judged correctly.Others can chime in, but if everything else is equal, I would also look at...
The creation of Maintenance Plans results in the creation of SSIS packages. Therefore, SSIS is required in order to execute a maintenance plan.We...
One thing to watch for in this instance is the fact that Express Edition sets Auto Close to true by default. That means that if no one is using the...
When you attempt to restore the database, the drives (path) that the original data files were using are apparently not available on your machine....
I am new to the forum, so forgive me if I am getting this whole situation wrong. When inserting the rows from one table in a database to another...
Separate names with a comma.
