Viewing 15 posts - 2,431 through 2,445 (of 6,216 total)
I think a decent technique for passing in what is really an array of parameters - a bunch of order details would be a common example. I think you can...
March 6, 2003 at 7:04 am
In a high volume environment, wouldnt you run into issues with two users trying to use (re-use) the same key?
Andy
March 6, 2003 at 5:03 am
Not sure if compatible with SQL7, but another way to do it is with Openrowset.
Andy
March 6, 2003 at 4:55 am
Seems like there was a change in 2.6 to support named parameters, though maybe it was only that the parameters didnt have to be loaded into the collection in the...
March 6, 2003 at 4:54 am
It's early, so I'll risk foot-in-mouth and say you can't with a simple select. It's basically the same as saying 'find all the sql servers on the network'. You could...
March 6, 2003 at 4:50 am
We're interested. If it targets the community, we're always willing to look at it. We (Steve, Brian, I) have a conf call coming up to review where we stand on...
March 6, 2003 at 4:46 am
I think you could just put a deny on SP_SDIDEBUG.
Andy
March 5, 2003 at 5:46 am
Thats a good explanation and a good bit of testing.
Andy
March 5, 2003 at 5:43 am
March 5, 2003 at 5:40 am
I'll have a third (final?) article on the subject up next week, I'll include some sample code for that case.
Andy
March 5, 2003 at 5:39 am
For OS level fragmentation you can run the defrag that comes with Windows, that way your free space stays pretty much on one contiguous chunk. For the db, all you...
March 4, 2003 at 1:34 pm
I know Im in the minority again, but I do use autogrow on production servers. If you've only got one db you can check it once a week, go to...
March 4, 2003 at 1:28 pm
March 4, 2003 at 12:59 pm
March 4, 2003 at 12:59 pm
Great post! Thanks for taking the time to add good notes.
Andy
March 4, 2003 at 12:54 pm
Viewing 15 posts - 2,431 through 2,445 (of 6,216 total)