Viewing 15 posts - 3,631 through 3,645 (of 7,168 total)
I am not sure if this is what you're asking, but it sounds like you would like to add a VBA Macro to each csv file that will fire when...
July 9, 2012 at 4:11 pm
That's true. It is known as a uniqueifier. Whether you provide the uniqueness or whether SQL Server must help, a clustered index entry must uniquely identify a row. So, if...
July 9, 2012 at 3:53 pm
GilaMonster (7/9/2012)
opc.three (7/9/2012)
GilaMonster (7/9/2012)
Double the files. You want to have them in proportion to the CPUs.
This is the first time I have heard this. Do you have a reference by...
July 9, 2012 at 2:46 pm
No, using sp_configure that way will change the instance-level default. That takes over when no fill factor is specified when creating the index, as you have done above. I recommend...
July 9, 2012 at 2:37 pm
techguy817 (7/9/2012)
Also, how often would the index need to be rebuilt with about 5-6K records added every day? Any other suggestions are greatly appreciated.
If you're only ever inserting into...
July 9, 2012 at 2:10 pm
I do not do much AD work these days, let alone from PowerShell, but I do know of the AD cmdlets MS published. http://technet.microsoft.com/en-us/library/ee617195
Here is what I got (using replacement)...
July 9, 2012 at 2:03 pm
GilaMonster (7/9/2012)
Double the files. You want to have them in proportion to the CPUs.
This is the first time I have heard this. Do you have a reference by chance where...
July 9, 2012 at 1:35 pm
Is it a 2-proc/8-core machine meaning 16 ways? Or 2 procs w/ 4 cores each, i.e. 8 ways?
July 9, 2012 at 12:29 pm
Fly Girl (7/9/2012)
July 9, 2012 at 12:20 pm
I just read the title of the post again. Page latch (not IO) wait on tempdb file 8...chances are adding more data files will help. Gail, please correct if I...
July 9, 2012 at 11:50 am
What are the processes waiting on? If the web app is creating lots of temp tables you may actually benefit from creating additional data files. No matter how many you...
July 9, 2012 at 11:43 am
Also note that you cannot edit SSIS 2005 packages in BIDS/VS 2008 without upgrading them first, which will make them unusable on a SQL 2005 server.
BIDS/VS 2005 is required to...
July 9, 2012 at 10:19 am
If just starting out I highly recommend getting into PowerShell. It really has no peer in the Microsoft stack in terms of a command-line scripting tool. VBScript and JavaScript are...
July 9, 2012 at 9:29 am
My bad, I neglected to consider the total memory on your system. I use the /3GB switch to solve the problem you have with proc cache size, but on a...
July 7, 2012 at 8:44 am
You can help your cause a little by adding the /3GB switch to your boot.ini, and optionally the /USERVA option to restrict the VAS split to less than 3:1.
July 7, 2012 at 7:05 am
Viewing 15 posts - 3,631 through 3,645 (of 7,168 total)