Viewing 15 posts - 15,541 through 15,555 (of 22,211 total)
Steve Jones - Editor (4/7/2010)
April 7, 2010 at 8:40 am
No celebrations for me until we hit 20,000.
April 7, 2010 at 6:04 am
rambilla4 (4/6/2010)
Each disk has 150 spindles in it. So what ever the value I gathered from Perfmon for Avg Disk Queue length should be divided by 150 right?
and...
April 7, 2010 at 5:31 am
YSLGuru (4/6/2010)
User_Seeks,...
April 6, 2010 at 1:09 pm
For the period you're covering, the answer is yes. That still doesn't say that the day before you started or the day after you stop, some query won't come along...
April 6, 2010 at 1:08 pm
I suspect pretty strongly you're looking at maybe 30% cross-over. Chapters 1, 4, 5, half of 6, half of 7, 9, 10, are all going to be pretty different...
April 6, 2010 at 1:04 pm
Either of those options could work. You might also look at using the model database. Create all the structures and code there and then automatically get it deployed any time...
April 6, 2010 at 1:00 pm
Pretty much any method for moving data will work. If you're trying to practice an enterprise approach, I'd suggest building a full SQL Server Integration Services (SSIS) package and do...
April 6, 2010 at 12:59 pm
As far as I know, yes it does.
April 6, 2010 at 12:54 pm
rambilla4 (4/6/2010)
On a san, assuming it's properly configured, what you're seeing as "disks" in your OS and SQL Server should be, not a single monolithic disk, but a whole bunch...
April 6, 2010 at 10:01 am
It doesn't sound like a trigger is what you're looking for, especially since you're trying to check for a negative, rows that have not been added to the table. Since...
April 6, 2010 at 6:14 am
I'm unaware of any systemic issues with Server 2008 R2. Were any other changes introduced to the system? I'd suggest drilling down at the OS level to see what might...
April 6, 2010 at 6:11 am
Yes, I definately recommend running server side traces to capture query calls for performance metrics. But be careful here. Don't run the SQL Profiler GUI against your production systems. You...
April 6, 2010 at 6:09 am
It sounds like you're just getting started working with databases. I'd suggest a few things. First, be sure that you're not doing these experiments and learning tasks with your companies...
April 6, 2010 at 6:06 am
rambilla4 (4/6/2010)
We have SQL Server 2005 EE x64 with SP3 and have the storage on SAN with RAID 10 configuration
and have the below drives:
C- OS
D- Data
E- Log
T -TempDB
Z- Backup
Total...
April 6, 2010 at 6:00 am
Viewing 15 posts - 15,541 through 15,555 (of 22,211 total)