Viewing 15 posts - 1 through 15 (of 66 total)
I suppose you had a WHERE clause on that update ?
Also, you can choose between using the primary key, or "Where current of @cursor".
I think "cursors are bad for performance"...
March 13, 2005 at 11:29 pm
The first sentence in that article should have said:
A query plan that is generated to be optimal for a given parameter value, may not be optimal for a different parameter...
January 31, 2005 at 6:12 am
I would not think defrag would usually be worthwhile for SYSTEM tables. "25 GB worth of indexes" would not be the SYSTEM tables - sysobjects etc. They are...
January 31, 2005 at 5:54 am
If you create a UNIQUEID and cluster-index it purely to make all useful indexes nonclustered, then this would behave very much like having no clustered index, a 'heap'. I...
October 28, 2004 at 5:45 pm
If you ran non-orderby version first then order-by version, the data could have been buffered, making it faster. Run:
DBCC DropCleanBuffers
before each run.
Though you said physical reads were the same....
October 28, 2004 at 4:58 pm
You can setup a custom extended stored procedure to call a DLL function. I havent got the info, I googled:
extended stored procedure SQLServer DLL
and seems to be some info.
October 25, 2004 at 6:10 pm
I'm a developer rather than DBA so I might be contradicted ..
Auto Grow is OK. Ideally you should pre-allocate the database, monitoring the used space vs allocated regularly so...
October 22, 2004 at 4:40 pm
I'm pretty sure the fact that the pseudotables are called deleted and inserted is just a fiction, they are really preimage and postimage.
Physically, an updated row will be replaced within...
October 12, 2004 at 9:57 pm
Basically, your requirement is for Replication, so you should look at SQLServer's Replication features in detail. Sometimes log shipping (that is, copying transaction log backups) is used to achieve...
October 12, 2004 at 9:26 pm
'2004-09-01' - the separators were removed in the 'dummy function' example, that could be the difference ?
Maybe the REMOTE server '2004-09-01' has to convert it to a date (to return...
October 3, 2004 at 5:04 pm
I have two ideas (neither perfect)
1. Would it be adequate to have a local table and a SQLAgent job refreshing the local table every hour ? (There are lots...
October 1, 2004 at 1:40 am
A Limitation of querying syscomments:
Larger procedures can have multiple rows in syscomments, basically the text is split into blocks of fixed size. The text you are searching for could...
September 23, 2004 at 5:59 pm
You are detecting indexes where the column list of one is a subset of the other (and same sequence).
Will you drop the longer one or the shorter one ?
What about...
September 2, 2004 at 10:22 pm
You probably wont get much faster overall (I mean the time the last users' data is completed) without dropping indexes or constraints, but you say the data must remain available....
September 2, 2004 at 10:04 pm
"make all necessary changes to the target database to ensure that it matches the scripts"
Without the tool, this statement is the whole "ball game".
You might as well mention the tool...
August 16, 2004 at 2:17 am
Viewing 15 posts - 1 through 15 (of 66 total)