Since SELECT INTO doesn't usually copy over indexes and modifying the default file group before & after a SELECT INTO could cause major problems later on (what if you forget...

We're always happy to help.

And remember, the only forbidden question on this site is "Why is the sky blue?" ... @=)

Sounds like you got the job then. @=)

Interesting note. In the Microsoft Self Paced Training kit for 70-441, the book says

However, you cannot optimize all types of queries. For example, a query such as...

Enterprise 32 bit (for the servers) and Developer 32 bit (for our local PCs).

If the arabic script has no Roman/English characters in it, you should be able to use the following WHERE clause.

WHERE MyColumn not like '[a-z]%'

And if your collation is set up...

Verify via the SQL Server Surface Area Configuration Tool that you have xp_cmdshell enabled on this server. Usually when something takes that long before returning an error, it's stuck...

You can't downgrade a DB to SQL 2000, but you can script out all the objects, recreate them in SQL 2000, move some of the data (top 1000 or 5000...

I can't give you actual monitoring scripts because I didn't write some of them and I don't have permissions to hand the ones I didn't create. Also, you can...

BOL also has some good tutorials. And if you don't have access to SQL Server at the moment, you can either download the eval version of 2k5 or (recommended)...

And save all your T-SQL scripts! You'd be amazed at how handy that comes in 6 months down the road when you need to replicate that "one time" job.

Dennis,

The best way to see what SQL process are using up the memory is go into System Monitor and choose the regular OS memory counters as well as whatever SQL...

You should also check out the Certification Forum on this site to see what other people have posted about these exams.

I've done it where I've had multiple data sources in the report, then just edited the DataSets right after Testing so that it pointed to the proper data source when...

SQL 2k5 has a whole bunch of new system catalog views that help you identify unused indexes, etc. Check out "sys.dm_db_index" in BOL. This will get you to the...