Geeks With Blogs

News

The Wrecking Bawl Destructuring query language, one keyword at a time. April 2007 Entries
SQL job command - max chars
If you like to paste scripts into the command window when creating SQL Server 2000 jobs in Enterprise Manager, you should be aware of the 3200-character limit.  You won't get a warning unless your script does not parse correctly because of the spot where it was cut off.  You will get a warning if you choose Open to open a script file.

Posted On Friday, April 20, 2007 5:20 AM

SqlBulkCopy
I just discovered the SqlBulkCopy class in .Net 2.0, and it seems awesome!  Now I don't have to shell out to BCP anymore!  We'll see though, I haven't done any performance testing yet...

Posted On Tuesday, April 10, 2007 10:06 PM

T-SQL and GROUP BY ALL

How is it possible that I'm just learning about the "GROUP BY ALL" option?  It sounds like it would save a lot of time.  It worries me though that Microsoft says not to use it anymore because it will be removed from a future version.  Is there a good alternative?

 

Posted On Monday, April 9, 2007 6:37 PM

multi-million dollar idea...
For any telephone/cellular service provider who cares, you should be implementing the option of caller-specific voicemail greetings on your system. The scenario happens quite often: I know somebody specific is going to call me during a period in which I'll be unavailable, and I have a specific message just for them, e.g. "I'm mowing the lawn but I'll be ready when you get here" or something like that. Also, having a web page to administer the whole voicemail system and contacts would be great. Feel ......

Posted On Saturday, April 7, 2007 9:18 PM

settings transfer from designer to code in composite control in asp.net

If you want to build your own composite control for ASP.Net and you want to create in such a way that when you set a property in the designer window, the setting is reflected in the aspx code, placing this attribute on each public property is the key:

[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]

Posted On Tuesday, April 3, 2007 7:05 PM

Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net