While that advice is a decent starting point; i.e. first look to foreign key fields used frequently in joins to place indexes on. However, beware putting indexes on any field (foreign key or otherwise) that is not particularly selective (a low rate of repetitive data). Having an index on any field that has very few […]
2003-05-06
1 reads
Thanks for replying...when I join by store ID and by busines date, all I get is the one store (7704) that has the (Fuelman) sales...I need all the stores, plus whichever stores that have sales in Fuelman...
2003-05-06
Thanks for your reply. While using SQLNS for creatng new stored procedure, the window that comes up is the same window what you see when you create a new SP using Enterpise Manager. What I am trying to say here, I have no control on the contents of the Editor.. so a find/replace is not […]
2003-05-06
1 reads
For production system, I agree, just say no. Manage space usage based on the business needs (slow time) and don't rely on Auto Shrink. I've found some "production" systems such as Crystal Reports that use MSDE with auto close enabled. so review every install, and do an inventory of all your production system if you […]
2003-05-06
As I have not played with this myself I can only suggest what I would try. Since you are getting some of this from SQL NS in VB do a find and replace on the section in question and make that uneditable by the user. The have them fill in a parameter for the name. […]
2003-05-06
1 reads
Hi there Experience tells me to manage it yourself in terms of shrinking (when it happens, what is going on and sync it with other jobs that may be going on). The trick to watch a little more carefully I believe is your growth settings and not chewing space that perhaps wont be used for […]
2003-05-05
1 reads
Just to answer the questions posed... I'm not compressing the snapshot. I'm using concurrent snapshot generation because I can't lock the production DB during business hours. The BCP files are okay, because I've been able to complete the snapshot successfully one time in the past (painfully long though). Indexes...good point, I didn't make any special […]
2003-05-05
1 reads
The database should be attached back as long as you properly shut down the services. Can you post statement/commands here to show how did you try to get the database back?
2003-05-05
2003-05-05
there are couple of ways you can do that: 1. Restart sql server (ruled out i guess) 2. U can run sp_cycle_errorlog, but the number of versions will be 6 only. to change the number of versions you need to edit the registry to have more versions. U can read more about it in books […]
2003-05-05
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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