Viewing 15 posts - 3,541 through 3,555 (of 3,613 total)
I had a friend who said he would sooner see a bad idea implemented well than a good idea implemented badly.
He was refering to Mercedes windscreen wipers at...
December 5, 2002 at 7:42 am
Versions of MDAC after 2.5 loose the ADSI and LDAP features
December 5, 2002 at 2:41 am
One of our developers complains that a lot of stuff got taken out of MDAC 2.6. Unfortunately he is on leave so I can't elaborate.
If you are running MS...
December 5, 2002 at 2:14 am
I think this also illustrates why it is important to keep scripts of your database objects.
OK you can go in and add then remove a space from your view/stored proc...
November 28, 2002 at 2:30 am
I've had the same problem. As far as I can see sp_recompile does absolutely nothing.
I've tried
November 26, 2002 at 3:04 am
As a cynic I would say that tech support for SQL Server is
in order of preference.
I showed an ORACLE developer...
November 20, 2002 at 2:56 am
Read Dale Carnegie's "How to win friends and influence people". It may be 70 years old but he said virtually all this back in the 1930's.
November 19, 2002 at 8:30 am
Interesting
I've always insisted that stored procedures were prefixed with usp (user stored procedure) so that I can spot the ones for which I should expect documentation.
As there are an ever...
November 14, 2002 at 2:56 am
..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
Viewing 15 posts - 3,541 through 3,555 (of 3,613 total)