Viewing 15 posts - 46 through 60 (of 285 total)
Changing the compatibility level without checking to see if something else broke could be a recipe for disaster; not really sure if this is a viable solution, I think the...
August 10, 2009 at 4:36 am
Interesting question. Shows the results may not necessarily be what you'd expect.
I've been burnt by this before, good knowlege!
August 10, 2009 at 4:31 am
GilaMonster (8/7/2009)
Mark Horninger (8/7/2009)
GilaMonster (8/7/2009)
Bill Whitman (7/14/2008)
A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Absolutely not. That's terrible advice to...
August 8, 2009 at 5:22 am
GilaMonster (8/7/2009)
Bill Whitman (7/14/2008)
A maintenance plan should be set up to truncate, shrink, and backup the transaction log -- nightly, if necessary.
Absolutely not. That's terrible advice to be giving.
Backup the...
August 7, 2009 at 4:48 am
Mike,
Could a view/indexed view help then use the simple solution against the view?
Mark
July 27, 2009 at 8:52 am
wschauweker (7/20/2009)
July 20, 2009 at 6:40 am
I think it's cool kids are getting introduced to technology at an early age. I don't see it devaluing the exam, since the exams are hard and they're not...
July 20, 2009 at 5:30 am
Andy,
Great job! This does a real good job of explaining indexed views!
Mark
June 30, 2009 at 8:04 am
Most of this looks pretty good but this could be a recipe for disaster:
"Drop obsolete objects"
It's sometimes not straightforward how and when objects are used. before dropping something you...
June 22, 2009 at 4:51 am
David,
Well done!
Thanks to you and all of the other authors who write for SQL Server Central. I think my biggest hurdle is finding time!
Mark
June 19, 2009 at 4:01 am
Andrew,
Well done!
How hard is it to add a new node to SQL Cluster? Does SQL setup happen auto-magically (like when you install SQL on a 2 node cluster) when...
June 17, 2009 at 11:05 am
Good post! Interesting concept!
May 20, 2009 at 4:06 am
Be interesting to see the SQL this generates for a table insert w/ 100 or so columns...
May 11, 2009 at 5:45 am
Steve,
I think it depends on what you're looking for - generally I use my network of contacts first, see if anyone is looking or they know someone.
I've got some intersting...
May 11, 2009 at 4:51 am
interesting article.
I worked on a banking app (25-30 concurrent users) that audited all application accesses via application code. they needed an audit trail but in the 5 years I...
May 7, 2009 at 4:38 am
Viewing 15 posts - 46 through 60 (of 285 total)