Viewing 15 posts - 16 through 30 (of 93 total)
what's the service pack level of of the SQL Server?? Later OS versions (w2k3 especially!) actually dont support SQL Server below a certain Service Pack level!!
November 24, 2005 at 11:12 am
Another thing that you want to look at is the indexing in general and not necessarily the maintenance plans (although they're useful!) ! We're going through this process at the...
November 24, 2005 at 10:29 am
Nope ... no formula i'm afraid ... so your best guestimate would probably be from the aproach you've already suggested and add up the memory used by the individual instances!...
November 24, 2005 at 9:36 am
it used to work fine ... but then MS started hard Coding stuff into the OS's (Win2k3 especially!) where it said it wouldn't support SQL Server Pre SP2 and deliberately blocked...
November 22, 2005 at 9:25 am
I'd usually setup the system so that the web app user (IWAM_ComputerName) / COM+ / Application Pool user is the only one with access to the DB, then do as mentioned...
November 22, 2005 at 9:19 am
Not gonna add much to this discussion .... just a comment about ur supplier .... GET A NEW ONE!? If their first comment is "It's YOUR Network" when the new...
November 22, 2005 at 9:11 am
u obviously haven't played with clusters enough sushi!
November 18, 2005 at 7:22 am
so ... that wud be "Learn Everything", huh guys!??
November 18, 2005 at 3:00 am
we had a similar problem the other day with an MSDE engine ... in our case (for whatever bizarre reason! ), the server didn't...
November 14, 2005 at 10:38 am
In BOL under "files and filegroups", it goes into this quite alot .... but i think one important point that it mentions is that the effect is seen more in...
November 14, 2005 at 10:03 am
If you're an application developer as well, i've always found the SQL-DMO very useful for doing this kinda thing! The "Table" object has a "Keys" collection, which can then be...
November 11, 2005 at 4:42 am
it doesn't make sense to use and ORDER BY in a view, period! It's supposed to be a subset of the data ... but i suspect that it's being used insead...
November 11, 2005 at 4:34 am
IN THEORY (and i really do mean that!), your systems group is correct ... but arranging your cluster groups to achieve this would be an appauling configuration and i'm sure...
November 11, 2005 at 4:11 am
Hi Kevin
Along with adding the disk to your SQL Server Group, you also have to make SQL dependant on the disk for it to appear in the drive listings in...
November 11, 2005 at 3:34 am
Am assuming here that ur wanting all the records for job 50 AND 51 AND 52 ... etc??
The syntax i'd use is
INSERT INTO myNewTable (field1, Field2, Field3 )
SELECT aField, bField,...
November 10, 2005 at 3:15 am
Viewing 15 posts - 16 through 30 (of 93 total)