Viewing 15 posts - 1,636 through 1,650 (of 7,429 total)
Do you mean Blob?
If you do mean Blog then it is short for WebLog (like an online journal or diary).
August 12, 2004 at 1:17 pm
As far indexes a covering index with both ID and Code is fine. You would not need to add one specifically for Code as the one with ID and Code...
August 12, 2004 at 11:52 am
I have had the opportunity to do 6 rebuilds. We did 4 offline and 2 online. No issues either time with database. We did however on the online tries lost those...
August 12, 2004 at 9:43 am
First off you may have the query wrong, because of your WHERE conditions you are actually inherently getting the results of an inner join.
Based on yours then if you wrote
SELECT...
August 12, 2004 at 8:10 am
I am just getting a chance to take a look and have to say it is a bit kludgy feeling IMHO. I of course am currently doing a dry run...
August 11, 2004 at 3:19 pm
The biggest issue to keep in mind is that if you have database roles and assign a Windows group to multiples or have permissions on the Windows Group itself the most...
August 11, 2004 at 7:31 am
I agree the question is too open ended and the fact you know the data and that there are no gaps make other options. However in any circumstance the answer...
August 10, 2004 at 7:50 am
SQLDMO is the only way I have seen it done. See http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=22&messageid=122842#bm122878
August 2, 2004 at 5:21 pm
However you can provide a parameter in the UDF to submit GETDATE() thru.
August 2, 2004 at 5:14 pm
If it is only the two items then you have four scenarios. For optimal performance consider maybe using multiple procdures for all 4 cases and have a central procedure determine...
August 2, 2004 at 5:09 pm
Or try
where len(column) > 0
August 2, 2004 at 5:02 pm
You would still need On Error Resume Next to accomplish. I prefer to wrap in functions each bit so I have the effectiveness of a GOTO by being able to...
August 2, 2004 at 6:22 am
In that situation the coder should have done a more thorough job with his error trapping and things should have caught the users attention with enough detail that when they...
July 29, 2004 at 6:51 am
I have to say this was very interesting and Mark is right. If the explicit column isn't in the output list but an identical Alias exists the query bases itself...
July 28, 2004 at 7:03 am
I do as well. As far supperior support. I tried VIrtual CDRom as well just before all the ISOs came out so I could use WinISO to create file cds...
July 16, 2004 at 5:42 am
Viewing 15 posts - 1,636 through 1,650 (of 7,429 total)