Good question. The advice I've always understood to be correct and which I've found has been born out in practice is that if there's been significant changes in the values of the indexed columns, then it's a good idea to update the statistics. However, if you do this in business hours, it would put extra […]
2003-07-22
1 reads
I have come across this problem many times. I have never been able to determine the cause (probably a bug in the way security information are passed to the package through SQL Server Agent??) but a work around is to create your scheduled job manually and use the dtsrun command in your job step. Hope […]
2003-07-11
What service account do you use to start SQL Server and Agent services? Is it in local administrator group?
2003-07-09
Hi Ryan, Can you add a catch-all level in your dimension table with a value of something like "N/A"? Then you could default all nulls to this level's key value...just a thought... hth, Michael Michael Weiss
2003-07-07
quote: that's what the tables are. 2, maybe 3 columns. the data inserted hardly never changes. From year to year I guess. If the table is only a couple of columns wide and the average row length is, say, 100 bytes (assuming you have an integer field and a varchar() field of an average 96 […]
2003-06-25
views are mainly there for security reasons. I prefer to use views for frequently (to be) used joins, so join-predicates are predefined. Stored procedures on the other hand can provide more functionality and should be prefered for db-access.
2003-06-12
1 reads
I'm sorry, I re-typed the command and left out the database name. I got the file names by looking at the properties of the database before I detatched it using the sp_detatch command
2003-06-11
2 reads
One (additional) way to avoid trigger recursion is using an INSTEAD OF trigger. You probably will have to rewrite your trigger since the original update will not be executed...
2003-06-10
Thanks SQLBill. The default scale was set to 0. I modified it and amazingly SQL keeps the decimal point. Stupid user error...gets you all the time.
2003-06-04
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-26
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers