Hi

db_ddladmin privs?? you have got to be joking! 🙂 my developers are lucky to get CRUD let alone anything else. Get them to write up and DTS, you...

whoa...

nows all queries are working? what the heck is going on here. Perhaps a bad proc cache entry?

just chatted with another developer and...

check your sqlnet config and in the wizard, play with the connection so that it matches the sqlnet.ora string at your client. Also, login to the server and try...

Hi

http://www.amcon.com.au, they are looking for DBA's for sydney, u also need oracle experience in australia (i found anyhow). U may need to travel (namely Canbera and Melbourne.)

Cheers

Ck

Hi all

Bugger it, im adding my 2cents worth here 🙂

I am relatively new to the Microsoft realm as the DBA, but saying that and the projects itve been involved with...

Hi

Ive had problems with using the command line and then trying to use EM against the instance (comes up with an error re too many administrators logged in etc). ...

Brian is correct, they are statistics collections resulting from the auto create stats DB option. If you query any column SQL Server will collect stats for it, try it out...

What ill do is eval the most frequently altered tables and use EM for these to fix pad_index. In other cases I may re-evel the fill factor anyhow and...

Hi all

Thanks for the pointers, ive considered all of these, the dbcc command was my last vain attempt and forcing a recompilation but will remember the comment re freeproccache on...

Hi there

From memory here, I didnt "title" the article so the SSC crew gave it one 🙂

Fair comment though, I have a few client sites that required 24x7, and attaching...

Found it.

The query wasnt being submitted to the remote server at all. I checked the remote box after some political hoo-harr and found that there were 3 DTS batch...

Hi there, around 2 months back i had a so-called corrupt problem, ran checkdb and the errors disappeared with the fix options. I backed up and recovered the db...

Hi there

Yep, ive had very similar problems, the key is that yes, the files are restored to their original backup size, but, ive had the same issue recently where i...

Great article and very imformative.

Cheers

Chris

Hi

I am confused with the real meaning behind fill-factor zero, a lot of MS docs state its an "internally" managed factor that will work in nearly all cases. I...