Viewing 15 posts - 721 through 735 (of 928 total)
GilaMonster (1/25/2011)
scorpianprince (1/25/2011)
Create a Job which daily shrinks your log files when the database is not in use.
No, absolutely not! Terrible practice. No file should be shrunk on a regular...
January 25, 2011 at 5:27 am
GilaMonster (1/25/2011)
The log shipping destination will be RESTORING (or STANDBY), not RECOVERING.
Thanks Gail, obvious once you point it out. A case of being almost certain but too quick (or idle)...
January 25, 2011 at 1:36 am
fawwad (1/25/2011)
1) is it posible for me to have one instance on SQL server 2008 and other one on SQL server 2005 ?
2) considering both instances on sql server 2008...
Is...
January 25, 2011 at 1:15 am
Post the definitions of all three tables. If you have some sample data with that too it would help. That is what made answering your first problem so easy.
BrainDonor
January 21, 2011 at 7:44 am
You can LEFT OUTER JOIN from #mgr_tab to #veg_tab and also LEFT OUTER JOIN from #mgr_tab to #non_veg_tab, both ON the sid for each table.
Then, within the SELECT statement use...
January 21, 2011 at 1:28 am
That makes sense, thanks for your time.
November 4, 2010 at 7:24 am
I wouldn't say that. There's still a week of voting and the down votes make changes happen quick. Someone can vote up another guy and vote me down and the...
November 3, 2010 at 2:27 am
An interesting question about commands that I was not aware of.
However, your explanation of fn_helpcollations is not entirely accurate for those of us using 2008. BOL describes it as 'Returns...
November 3, 2010 at 2:10 am
Tom.Thomson (10/18/2010)
The Dixie Flatline (10/18/2010)
I once heard two brothers argue (inconclusively) about whether or not black and white were colors. Opinions anyone?
The right way to get a...
October 19, 2010 at 1:15 am
Hugo, an excellent explanation, thank you.
Whenever I see a QOTD that looks like it's trying to trick the reader I just leave it now. Learning something new I'm all...
October 12, 2010 at 1:37 am
I suspect that this would be a more short-term solution than you were expecting:
http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=SQL+Server+2005&Filter=FilterNO - mainstream support ends April of next year. The FAQ at http://support.microsoft.com/gp/lifepolicy explains the different support...
October 8, 2010 at 4:20 am
GilaMonster (10/5/2010)
There are two aspects of this that are the most concerning.
1) There's no time to do a proper job here, and I highly doubt there will be any coming...
October 6, 2010 at 1:51 am
Alvin Ramard (10/4/2010)
WayneS (10/4/2010)
BrainDonor (10/4/2010)
Paul White NZ (10/2/2010)
October 5, 2010 at 1:34 am
Paul White NZ (10/4/2010)
BrainDonor (10/4/2010)
October 4, 2010 at 3:27 am
Paul White NZ (10/2/2010)
October 4, 2010 at 1:48 am
Viewing 15 posts - 721 through 735 (of 928 total)