Viewing 15 posts - 3,571 through 3,585 (of 3,635 total)
..and of course simply bunging in another processor adds to your licensing costs, never mind the cost of RAM, disk and tapes.
November 11, 2002 at 5:40 am
Great Andy,
There is an issue here of "who owns the data".
Your particular example is something that can be decided by the IT department as it is their own internal logging...
November 11, 2002 at 3:42 am
Its a bit of a "how long is a piece of string" question but on your systems how big is your TempDB?
The largest I have seen is 2Gb on a...
November 8, 2002 at 3:15 am
Given that TempDB is recreated every time SQL Server is restarted do you think there is any merit in moving it off a RAID onto a fast local disk.
I'm considering...
November 7, 2002 at 9:07 am
It just goes to show that the biggest security risk isn't some spotty onanite in a bedroom, its your own staff or recent ex-staff.
This harks back to the Windows Authentication...
November 4, 2002 at 2:58 am
The thought of having users who can update data using SQL statements scares me.
I don't mind them doing selects but I have serious issues with non-user interface updates of data.
I...
October 28, 2002 at 6:44 am
My favourite is the ommission of the
'sync with backup' option for the sp_replicationdboption stored procedure.
You need this if you are backing up and restoring replicated databases.
October 23, 2002 at 1:33 am
The MS Press book SQL Server 2000 with XML has a whole chapter on enabling your SQL Server to allow queries and updates via HTTP.
It then goes on to say,...
October 17, 2002 at 2:42 am
Great idea, providing you are using ADO.
Being a SQL Server guy it is very easy to get into the Microsoft mentality. JFDI methodology.
We use a variety of Web Content Management...
October 14, 2002 at 3:37 am
Books on line says "A parsed document is stored in the internal cache of SQL Server 2000. The MSXML parser uses one-eighth the total memory available for SQL Server. To...
October 14, 2002 at 3:14 am
I use snapshots when I need to duplicate a live environment for testing purposes.
1. Receive change request.
2. Snapshot the live to a development machine.
3. Test on the development machine.
4. Make...
October 11, 2002 at 5:40 am
Oh the embarrassment, thanks to Carsten Dauguaard for spotting it.
exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stdoc
should be
exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stXML
October 10, 2002 at 3:26 am
Oh the embarrassment!!!!
Thanks to Carsten Dauguaard for spotting it.
In the code for the stored procedure
exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stdoc
should be
exec sp_xml_preparedocument @iDocumentHandle OUTPUT, @stXML
This is what you get when you...
October 10, 2002 at 3:24 am
If these critical fixes are not part of SP3 then would you recommend holding off on SP3 and wait for SP4?
October 8, 2002 at 4:21 am
Viewing 15 posts - 3,571 through 3,585 (of 3,635 total)