Viewing 15 posts - 1,276 through 1,290 (of 6,216 total)
Search for "Dynamic Filters" in BOL. A subset of that text:
"In the dynamic filter, you specify a Microsoft® SQL Server™ 2000 function or a user-defined function that is evaluated differently...
December 6, 2003 at 6:52 am
Good to have discussion, but lets keep this good natured, ok? I know this technique isnt for everyone, but used to some degree isn't going to end the world either....
December 6, 2003 at 6:43 am
Hard to tell what falls under the NDA. I've seen it in open sessions, so Im guessing the name itself isnt top secret. SQL Workbench replaces EM and QA, basically...
December 6, 2003 at 6:32 am
I dont know if its open to all yet or not. Usually you look here:
http://www.microsoft.com/sql/evaluation/betanominations.asp
Andy
December 6, 2003 at 6:30 am
Well done my friends! You've helped a reader solve a problem AND steered them into a better practice.
Andy
December 5, 2003 at 5:45 am
Easy to miss. Did you fix the data, or use an IsNull in the sum?
Andy
December 5, 2003 at 5:42 am
Depending on how often your log backups run. If you're in simple mode and you carve the delete up into 5 chunks, you need enough space for 1 chunk in...
December 5, 2003 at 5:41 am
Nothing wrong with that. Yes, its more overhead than an int, but that is just part of using a guid. Whether you should cluster it depends on whether you have...
December 5, 2003 at 5:39 am
On the search, we'll see. We had something like that back in the beginning, but had a few problems with it, so we tried solution #2, now we're on #3!
As...
December 4, 2003 at 5:31 pm
I had to go through this recently, what a headache! The tnsnames.ora file is a config file that has basically the connection string. I finally got it built by accident...
December 4, 2003 at 5:23 pm
Think maybe it has to do with how you registered the server, use the name instead of local?
Andy
December 4, 2003 at 5:22 pm
Transactional doesnt give you much help with this. Merge does it fairly well, lets you use joins to qualify what data goes where, often based on hostname.
Andy
December 4, 2003 at 5:21 pm
That works, but you have to remember to script out all the indexes, constraints, etc, then put back when you're done.
Andy
December 4, 2003 at 5:19 pm
If you hit msdn.microsoft.com you should be able to find the source for the FMStocks project, has something similar. More recently they released the source for the data access block...
December 4, 2003 at 5:15 pm
Good points. I think we'll look at moving to auto generating the topic like we do for articles. We're catching up on tasks a little, might be doable soon.
Andy
December 4, 2003 at 5:11 pm
Viewing 15 posts - 1,276 through 1,290 (of 6,216 total)