Viewing 15 posts - 796 through 810 (of 1,271 total)
Thanks for the reply, DCPeterson!!
We have a datawarehousing/reporting project on the horizon. I may make that my first test run of this.
Right now, I don't think it would work for...
January 25, 2007 at 3:11 pm
Great posting, but I think you left out one key piece of data. You may get better results by telling where the job is located.
I see that BancVue is located...
January 24, 2007 at 10:28 pm
Just wondering if anyone has used the new SNAPSHOT isolation level in SQL 2005 yet, and if anyone has any comments on it's potential as a replacement for nolock/READ UNCOMMITTED.
From...
January 24, 2007 at 3:28 pm
I have to take issue with the following statement:
When the NOLOCK hint is included in a SELECT statement, no locks are taken when data is read. The result is...
January 24, 2007 at 11:46 am
January 14, 2007 at 11:07 am
A steady dosage of caffeine!!! I get espresso at the drive-thru in the morning and then supplement that throughout the day with the single cup coffee maker on my desk....
January 12, 2007 at 9:23 am
I completely agree. The only reason I can think to even consider a partitioned view is if the data was stored in multiple databases or servers ... which I would not...
January 10, 2007 at 5:16 pm
>> There's probably no need to analyze I/O impact, the data pages are in the same place either way.
Only if you do it that way. If you put them in...
January 10, 2007 at 2:03 pm
You shouldn't even consider partitioned views since SQL 2005 has excellent support for real partitioned tables!!
Can the disk be reconfigured as RAID 10? RAID 10 is much better.
January 10, 2007 at 12:22 pm
The only way I ever use output parameters as input is when specifying a default for the parameter so that if the user does not want to use the output...
January 10, 2007 at 11:43 am
If each partition is many GB's, then not having to back up the previous 10 years inactive data of 500 GB in order to backup the active 2 GB data...
January 10, 2007 at 10:03 am
Have you tried dropping and adding back Procedure tr_B773565B-6AB6-4448-9941-9FC44B2ADC0E?
The name makes me think it is a trigger though.
January 10, 2007 at 9:40 am
Partitioned tables will result in much better performance than a single table. With a single table performance will degrade more and more as years go by, and then everyone will...
January 9, 2007 at 11:05 pm
I'm surprised this hasn't been asked already, but why are you setting all open invoices to closed and then resetting many of them back to open? Just set the ones...
January 9, 2007 at 10:47 pm
Try using sp_delete_job in Query Analyzer:
Exec
sp_delete_job @job_name = 'Name of Job'
January 9, 2007 at 10:21 pm
Viewing 15 posts - 796 through 810 (of 1,271 total)