Viewing 15 posts - 826 through 840 (of 1,315 total)
I'm pretty sure I remember reading that client tools (EM and QA) must be reinstalled on all clients for SP4. I don't remember the issues, but this might be one...
May 16, 2006 at 8:12 am
You do not have to restart SQL after ALTER DATABASE.
Have you looked at replication or log shipping? Unless a large percentage of the production database has been modified from one...
May 16, 2006 at 8:06 am
You might think "there should be no problem with what to join together" because you put parentheses around the derived table, but the query optimizer has its own agenda sometimes. ...
May 15, 2006 at 2:43 pm
After some experimentation I found that
grant
VIEW DEFINITION on SCHEMA::dbo to ddladmin_user
May 15, 2006 at 1:06 pm
The use of the old-style syntax promoted the entire WHERE clause to the ON clause. You get the same results as the "wrong" query if you used "LEFT JOIN ......
May 15, 2006 at 12:45 pm
Integers will perform better than decimal because a CPU can't do arithmetic on decimal values. They have to be converted to a scaled integer representation to be used in expressions,...
May 3, 2006 at 7:22 am
Was this database (or an ancestor) ever replicated? A database that was set up for replication would exibit the same symptoms (log not truncating) if the replication agents were stopped but the...
May 2, 2006 at 11:07 am
You'll have better luck in general with linefeed (CHAR(10)) than carriage return (CHAR(13)).
As pointed out already, CONVERT(CHAR(1), 0x0A) is just a long-winded way of saying CHAR(10).
April 26, 2006 at 9:41 am
If you only needed a one-time fix, then you're in good shape.
If you have to move databases between servers more often, say between test and production, it helps if you...
April 26, 2006 at 9:33 am
You might try examining the log for clues with undocumented DBCC commands:
DBCC
LOG ( '<database>' |
April 26, 2006 at 6:34 am
I double-checked in BOL just to make sure I was correct. A CHECKPOINT in simple recovery mode truncates the logical log file (marks virtual log segments as reusable) but doesn't...
April 25, 2006 at 4:44 pm
Simple recovery mode does not cause the tran log file to shrink. You could set the autoshrink option for the database to make that happen (not a best practice in...
April 25, 2006 at 4:09 pm
That is correct, you just need to make sure the logins are recreated with the correct SID in the master database. Roles and permissions for the users will be restored with...
April 25, 2006 at 3:58 pm
The EXECUTE AS statement has a syntax error and does not execute, so the context is never changed to Bob.
The correct answer is D, but it may not be the...
April 25, 2006 at 7:13 am
Don't use the "sp_" prefix on user stored procedures, especially when giving advice to newbies. It might be years before he realizes what a cruel joke you've played on him.
April 21, 2006 at 8:46 am
Viewing 15 posts - 826 through 840 (of 1,315 total)