Viewing 15 posts - 45,346 through 45,360 (of 49,571 total)
Any log backups that you take on a DB that's the source of logshipping must be shipped to the secondary machine and applied. If you don't, the log backups taken...
July 31, 2008 at 2:12 am
SQL 2000 has no built in forms of encryption. (well, not ones that are decryptable)
SQL 2008 has transparency database encryption which protects the DB files on disk and the backups,...
July 31, 2008 at 2:09 am
Run them all and see which is faster.
The 1st and 2nd should be identical. The explicit joins are preferred over the joins in the where clause for readability at the...
July 31, 2008 at 2:07 am
Fourth highest record by what? Please post the table definitions and some sample data. The same comment applies to the 2nd part of your question. Without more info I can't...
July 31, 2008 at 2:06 am
That error means that the last backup that was restored to the database was restored WITH RECOVERY. With recovery means that transactions are rolled forward and back as necessary and...
July 31, 2008 at 2:03 am
Buy the self-paced training kits for the different exams. They are quite good.
Brain dumps are cheating and, if you are caught using them, all of your certifications will be revoked,...
July 31, 2008 at 2:00 am
You may want to set the max memory lower. Maybe 3 GB. SQL's been told that it may use up to 3.5 GB and it will do that, even if...
July 31, 2008 at 1:57 am
Michael Earl (7/30/2008)
NOLOCK in particular can result in missed or even duplicated data as your query reads through the pages.
And readpast can skip rows by definition, since it doesn't...
July 30, 2008 at 12:40 pm
Just be aware that in SQL 2000 decrypting encrypted stored procedures was a fairly trivial operation.
July 30, 2008 at 12:14 pm
Rather stay away from any form of hints. If you have blocking problems look at optimising the queries that are causing the blocking, rather than hiding the symptoms with locking...
July 30, 2008 at 12:11 pm
Sandy (7/30/2008)
(Still i wants to know should i create index or not on the foreign key column.....he he he..lolz....:))
As I said several times in this thread, probably but test to...
July 30, 2008 at 12:03 pm
Michael Earl (7/30/2008)
July 30, 2008 at 10:00 am
Sure, but don't consider them the official word from Microsoft, as that is not the case.
July 30, 2008 at 9:38 am
Sandy (7/30/2008)
the word "often" makes me more...
July 30, 2008 at 9:32 am
I doubt it. Openrowset is a function to pull data into SQL in a table format. The default trace runs to disk.
I've never seen this on my servers and...
July 30, 2008 at 9:30 am
Viewing 15 posts - 45,346 through 45,360 (of 49,571 total)