Viewing 15 posts - 2,431 through 2,445 (of 3,655 total)
I would steer well clear of depending on sp double-underscore as a determiner for bespoke stored procedures.
Firstly, a double-underscore isn't obviously different from a single underscore.
Secondly, I feel it...
February 28, 2006 at 9:37 am
Take a step backwards.
What is the business problem that you are trying to solve
February 28, 2006 at 1:22 am
The way that I do it is to create a standard batch file that contains a bunch of OSQL scripts.
All my objects are generated in scripts which I break down...
February 24, 2006 at 12:50 pm
In hindsight, no.
With foresight:
Do the update with a begin transaction but commit transaction commented out. If you get an unexpected number of records updated then run the commit.
My...
February 18, 2006 at 1:31 pm
Look at their book list
The professional Sql server DTS by Wrox is OK but I wouldn't pay full wack for it as it is a little dated now.
If...
February 18, 2006 at 1:28 pm
If you look in sysindexes and look at any clustered indexes there is a rowcnt field that contains the approximate count for the number of rows in the tables to...
February 17, 2006 at 1:16 pm
Firstly add the path of the WZZIP.EXE files to the PATH environment variable. Having done so restart MSSQLSERVER and SQLSERVERAGENT. You should now be able to call WZZIP...
February 17, 2006 at 7:33 am
This suggests to me that if you have a SQL Server with 4GB RAM then there is little benefit in allowing it to look beyond the 2GB threshold?
The...
February 17, 2006 at 3:35 am
Count(Field) will produce a count of the non-null values so you have to use count(*) or count(1) in any case.
Try running DBCC UPDATEUSAGE(0) then running sp_spaceused
February 17, 2006 at 1:37 am
I would like a tool that predict the overall benefit to a system of an improvement of a constituent part.
I've read a piece on queue theory which used the example...
February 17, 2006 at 1:35 am
I have a huge parent/child schema which has to be partially flushed out every night so deletes for me are a major issue hence why I don't use DRI.
On a...
February 15, 2006 at 8:57 am
See BOL for sp_addlogin example E.
Basically create you Informix login on your new box so that it is identical to the Informix login on your old box.
February 15, 2006 at 4:56 am
I believe that there is a "Lock Pages In Memory" policy setting that needs to be applied to the service account. This is not enabled by default even for...
February 15, 2006 at 4:53 am
Tulasoft SQL Examiner is a pretty good tool and it is relatively cheap.
What I have seen of Apex tools impresses me, but be warned they are like drugs. ...
February 15, 2006 at 3:31 am
Cascading deletes are an absolute nightmare!
Let us suppose you accidentally attempt to delete a parent object (shouldn't happen but we are talking about the real world here). DRI will...
February 15, 2006 at 1:58 am
Viewing 15 posts - 2,431 through 2,445 (of 3,655 total)