Too expensive.

I can understand why. Instructors don't come cheap and it it's 5 different instructors over a couple weeks, that is going to cost. Problem is, it's priced curently in...

You don't backup tables in SQL, you backup databases.

You can export the table as csv, or make a copy of it in another database

Can you please give us the table structure, some sample data and an example of what you want out?

Without that we're going to be guessing as to whether or not...

There isn't an undelete function. There's no history unless you have an audit-trail or similar. There's no built-in source control of any form in SQL.

Are you sure there's no backup...

If you can post the code, I'm sure someone will be able to help you remove the cursor.

Generally, yes, but you should test your queries to make sure they use the indexes you've created.

Use the fn_trace_getdata function to load the trace data into a SQL table. Then you can query the trace data to get your information.

The only metrics you can compare your...

If you're asking for all the values in the table to be read (as you are) the only way that SQL can possible do that is to scan the index....

Default database.

What you need to get out of the syslogins is the login name, the password (hashed) and the SID. The SID is what will link up the logins with...

Don't enable AWE with only 4 GB memory. Enable the /3GB switch in boot.ini.

As for the cumulative updates, run SELECT @@Version and compare the version number to the very comprehensive...

Jeff Moden (9/1/2008)

---

GilaMonster (9/1/2008)

---

Of course, because there are still going to be people writing queries with just the smallest amount of SQL knowledge (enough to do the job, not enough...

It only works if you're connected to a SQL 2008 server. If you're connected to any lower version, intellisense is disabled

Try restoring the backup to another server as a normal user database, then scripting the logins from the syslogins table.

Please, in the future, put SQL 2000-related questions into the SQL...

It's called that in DBCC showcontig. If you're using sys.dm_db_index_physical_stats (which I assume you are) then the avg_fragmentation_in_percent is the logical...

rbarryyoung (9/1/2008)

---

True, if you're talking about a USB Flash Drive, but SSD's are usually made with faster/better grade memory and designed for throughput equal to the bus speed (as hard...