Viewing 15 posts - 3,466 through 3,480 (of 7,164 total)
If by 'databases' you just mean the Database Engine then I can say I have not run into any issues connecting and managing 2000, 2005 or 2008 R2. Then again...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 1, 2012 at 12:27 am
New day (at least in this time zone, Mountain) so new word:
Worth
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 1, 2012 at 12:10 am
The DEFAULT option works as you described, but you'll need to set @path this way if you want to pickup all default trace files:
SELECT @path = REVERSE(SUBSTRING(REVERSE([path]), CHARINDEX('\', REVERSE([path])),...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 31, 2012 at 6:48 am
SGT_squeequal (7/10/2012)
looks like i stand corrected and you cant use SET CONCAT_NULL_YIELDS_NULL { ON | OFF } for calculations of int field so use isnull function 🙂
I know the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 31, 2012 at 6:23 am
I installed a named instance of SQL 2000 Developer Edition after already having 2005 and 2008 R2 installed and have had no issues.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 31, 2012 at 6:14 am
Open the xdl in Notepad to see the two statements involved.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 10:16 pm
You can. I just tried it. You'll just need to install the 2012 Native Client to get the provider.
Code to create a Linked Server that uses the logged in user...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 9:53 pm
marek_polko (7/26/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 8:03 pm
GilaMonster (7/30/2012)
opc.three (7/30/2012)
OP says they had 'max degree of par' set to 2. Does that change the split you mentioned?
Yes, but the specifics, not the general rule. Maxdop is per...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 5:00 pm
GilaMonster (7/30/2012)
opc.three (7/30/2012)
I am puzzled as to how you could have seen 10 threads for SPID 100.
Two operators running with 4 threads, 2 co-ordinator threads. They won't all be running,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 4:53 pm
htt (7/30/2012)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 4:16 pm
It sounds like you're approaching a situation that may become critical in a hurry, if it has not already.
How many cores per CPU? Must be at least 8 each given...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 3:23 pm
No, not the picture again. The XML. That picture is rendered off an XML document which contains important troubleshooting information.
Right click the row in Profiler and click Extract Event Data...,...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 1:24 pm
DMV data is not guaranteed to be accurate at the time of retrieval. They are updated asynchronously.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 12:49 pm
robbase9 (7/25/2012)
runas /netonly /user:domain\username “C:\Program Files (x86)\Microsoft...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 30, 2012 at 11:18 am
Viewing 15 posts - 3,466 through 3,480 (of 7,164 total)