Viewing 15 posts - 42,406 through 42,420 (of 49,571 total)
Steve Jones - Editor (12/12/2008)
First thing I do, and used to require in dev teams, is to set tools to replace tabs with spaces. Creates all kinds of issues.
I used...
December 12, 2008 at 9:27 am
The_SQL_DBA (12/12/2008)
1.How is the process supposed to work?
That's a bit of a vague question.
How would the process of querying the table with ref to this column work after encryption?...
December 12, 2008 at 9:25 am
jcrawf02 (12/12/2008)
lol y'all are nuts.
Hehehe :hehe: You only just noticed?
December 12, 2008 at 7:12 am
In the first statement, both of those numbers are integers. When SQL does maths on two integers, the result will be an int. In this case, the result is too...
December 12, 2008 at 4:24 am
There's often more than one entry in that view. Try the following and see if there's more than one entry and, if so, if one of them has a uow
select...
December 12, 2008 at 4:22 am
shyam (12/12/2008)
I'm preparing for the same and could you please help me by suggesting the book, topics etc.
The self-paced training kit is quite good.
December 12, 2008 at 4:19 am
I'd suggest running an integrity check on the SQL 2000 database (on SQL 2000)
Run CheckDB with No_infomsgs and all_errormsgs and also run CheckCatalog with no_infomsgs and all_errormsgs
December 12, 2008 at 1:09 am
madhu.arda (12/11/2008)
2008-12-09 17:54:14.72 spid204 An inconsistency was detected during an internal operation. Please...
December 12, 2008 at 1:06 am
Locking mechanisms are very, very different between Oracle, DB2 and SQL. It's not unexpected that something that works on 1 will give problems on another. Things that work well on...
December 12, 2008 at 1:03 am
SQL_Easy_btn? (12/11/2008)
I found that I have 247 missing index on my server running this against the master database,
Don't make any changes in the master database.
3. Would it be a...
December 12, 2008 at 12:50 am
Are you reading the event log directly from the server, or are you reading it from your client machine?
December 12, 2008 at 12:42 am
It's an english colloquial term to indicate that whatever the term applies to is plain, basic, no fancy stuff.
So a vanilla install would be a straight install with no config...
December 12, 2008 at 12:38 am
Can't say much until the output of checkDB is posted. In the meantime, do you have a clean database backup?
December 12, 2008 at 12:31 am
mohd.imtiaz (12/11/2008)
Its a correlated sub query, and i have gone through may site which says corelated syb queries work very slow.is tht true??
In most cases (including this one) no. The...
December 12, 2008 at 12:27 am
Lynn Pettis (12/11/2008)
I've been driving for over 33 years, 38 if you count the 5 years of dirt bike riding prior to getting my first license.
Grant Fritchey (12/11/2008)
December 11, 2008 at 2:45 pm
Viewing 15 posts - 42,406 through 42,420 (of 49,571 total)