Viewing 15 posts - 4,546 through 4,560 (of 7,429 total)
Can you give us an example of what you are doing and have you tried it with 1 record. Also, depending on the format you were sent the data in...
November 1, 2002 at 4:27 am
Not sure what you are doing with the cursor. May be logical in the procedure, but if it is to iterate thru a recordset for scrolling purposes it is better...
November 1, 2002 at 4:24 am
Is this for the creation of a table or maintainence of a table? If you are doing for instance DBCC REINDEX the table will grow to physically twice it size...
November 1, 2002 at 3:59 am
Note however you may want to do ISNULL(A,'') + ISNULL(B,'') since if either columns is NULL then end results is NULL.
October 31, 2002 at 10:52 am
quote:
quote:
I continuously see lists of 10 to even 20 skills "REQUIRED" for a position....
October 31, 2002 at 4:50 am
Not sure which if any can be safely deleted and not sure I would go that route. I previously saw a thread here somewhere with a discussion thou of how...
October 31, 2002 at 4:44 am
Which another all-purpose way to check for existance of an object in a database is to use
object_id('objectnamehere')
which will return a number if exists or NULL if does not, works...
October 31, 2002 at 4:38 am
Have you verified wih POrofiler on the Subscriber that the trigger is not firing but not meeting the qualifications you need to see or that you aren't reaching the maximum...
October 31, 2002 at 4:25 am
You cannot send only the items that changed to A3 thru replication and not the othrs. Your best bet is to use a TRIGGER and build a staging table to...
October 31, 2002 at 4:09 am
Not really a fail safe but you can fix the trigger to check for the person making changes and do a RAISERROR. I do this to prevent deletes on a...
October 31, 2002 at 4:05 am
I would never use the word specialist in regards to computer skills. To survive the market you really should have multiple skills and be adept at a few.
Of the...
October 30, 2002 at 4:23 am
Initial setup must be done thru the console. There are known issues with Terminal services trying to do an Install, Upgrade or Service Pack/Hotfixes with SQL Server and this is...
October 30, 2002 at 4:11 am
My understanding on the last thing I read wahs that the tempdb should size itself just fine. But the idea is to make sure it is able to handle the...
October 28, 2002 at 1:57 pm
I have not seen this as a problem, however there is a log file generated that should give details as to why or at least a good idea. Also, there...
October 28, 2002 at 1:51 pm
I have used SQLCheck once before. The database allocation which I remember is the percentage of data in the file and log. If you want the space to be 75-85%...
October 28, 2002 at 1:43 pm
Viewing 15 posts - 4,546 through 4,560 (of 7,429 total)