Viewing 15 posts - 16,351 through 16,365 (of 39,827 total)
People like to think, so if you can make them apply knowledge without memorizing some answer, it's a good question. Hard to do well, and going off forum posts is...
April 14, 2011 at 8:28 am
Excellent advice from Jim above.
Service Packs fix things, but if you are not having issues with any of the things addressed in a service pack, then you don't need to...
April 13, 2011 at 6:21 pm
At one point we had a page peel there that opened and covered up the entire screen. I think it was from Quest, but it was definitely a $$$ thing....
April 13, 2011 at 6:19 pm
Realtime backup is going to require some work. And money.
There isn't a good way to do this in SQL 2000. you can do log shipping, where you restore your...
April 13, 2011 at 1:42 pm
Dwayne Dibley (4/13/2011)
CirquedeSQLeil (4/13/2011)
How many of you would walk out on a job without completing it (as a contractor/consultant) - if you were getting paid?
As with most SQL questions -...
April 13, 2011 at 9:56 am
Since I need to track backups occurring, getting the size is simple and doesn't involve querying anything else. Seems simpler to me.
April 13, 2011 at 8:12 am
Nice question. It seemed clear to me also that you needed to account for different language or format settings.
April 13, 2011 at 8:10 am
First, create a role for this. Don't use individual users.
second, this script can help. Grant the permissions to the role, add the users to the role.
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31186/
April 12, 2011 at 4:38 pm
I like Jason's advice here. Duplicate your work on the newer version, get some practice with things.
Be sure you look at how you can rewrite some code in 2005/208 with...
April 12, 2011 at 4:33 pm
LutzM (4/12/2011)
I'm in!@steve-2: how many active posters with GilaMonster avatars are needed before the cube icon in the SSC logo is replaced by a GilaMonster picture? 😛
6.9382384tr
April 12, 2011 at 4:31 pm
I tend to do what the ninja does. Track database full backup size history. That will tell you what the growth is and what your data size, at least close...
April 12, 2011 at 10:53 am
Eric M Russell (4/12/2011)
April 12, 2011 at 10:46 am
SanDroid (4/12/2011)
Great article and wonderful graphic.
One question I have always had about this new Policy of least privilege that M$ started pushing for in XP is this.
Are internal...
April 12, 2011 at 10:44 am
Eric M Russell (4/12/2011)
April 12, 2011 at 8:21 am
Stefan Krzywicki (4/12/2011)
WayneS (4/12/2011)
Stefan Krzywicki (4/12/2011)
I see SanDroid has started digging again...Where?
Still on your QOTD. bottom of the page and then on the next page.
I love when Gail is correcting...
April 12, 2011 at 8:20 am
Viewing 15 posts - 16,351 through 16,365 (of 39,827 total)