Viewing 15 posts - 136 through 150 (of 224 total)
Yeah, the query is awful. I've gone over it, and I can't improve it without changing the business requirements or getting more sanity in the (imported) data itself, both of...
January 28, 2011 at 12:39 pm
I'm still trying to solve this problem. I'm getting closer to figuring out what's wrong, but I still can't solve it.
I suspect that the updater is trying to connect to...
July 28, 2008 at 10:22 am
Val Byref (7/23/2008) unless you count Mr. Bean, which is way funnier than the CUSA "Family Circus" syndicated cartoon by Bill Keane..
Ugh, Family Circus. It's in nearly every newspaper comics...
July 23, 2008 at 9:03 am
Michal Mokros (7/22/2008)
Maybe when you have special one-row table (for example with some application parameters), then primary-key is useless 🙂
A one-row table usually means that columns are being used in...
July 22, 2008 at 9:09 am
I'm a bit behind on reading and replying to this article. There are already nine pages of comments! So why on Earth should I add mine? I just can't help...
July 10, 2008 at 4:27 pm
It looks like Microsoft recommends that a domain user account be used for the SQL Server service.
http://msdn.microsoft.com/en-us/library/ms144228.aspx
These are listed among security best practices:
Run SQL Server services...
July 7, 2008 at 8:24 am
I've been looking into the origins of the transaction log. This is a link to the site of the creator of the ARIES algorithm that seems to define the fundamental...
July 2, 2008 at 3:13 pm
Charles Kincaid (7/2/2008)It is possible to turn it off, however. Set recovery mode to simple and nothing gets logged. In that sense it is optional.
Um... no, sorry,...
July 2, 2008 at 12:26 pm
I see someone already mentioned that the transaction log is a write-ahead log, which, IMO, is its most important distinguishing feature. The transaction log is a core operational strategy employed...
July 2, 2008 at 10:33 am
Yes, ASP.NET does that. I had to invent my own wheel, though, because I was writing a Windows service app, there was no ASP nor IIS involved. I forgot about...
July 2, 2008 at 10:02 am
Matt Miller (7/1/2008)
But that flame of an article really ought to stay buried in the garbage bin where it belongs.
Yes, I can see your point. Totally subjective, no proof--I agree....
July 2, 2008 at 9:57 am
I've handled this problem before. I encrypted the passwords in the config file and then the application decrypted them before sending the result to SQL Server.
I also had no...
July 1, 2008 at 10:08 am
Yes, it is personal preference. I started my career with C++ and PowerScript. So when I picked up .NET I gravitated to C#, which has a similar syntactical feel.
I...
July 1, 2008 at 9:17 am
fisher08 (6/27/2008)
Stephanie Giovannini (6/23/2008)
fisher08 (6/23/2008)
June 27, 2008 at 1:00 pm
Viewing 15 posts - 136 through 150 (of 224 total)