Viewing 15 posts - 1,996 through 2,010 (of 2,640 total)
As Noel says it's all a matter of cost vs complexity. When most people state 100% availability what they actually mean is always available during working hours - or something....
July 22, 2006 at 8:04 am
select
serverproperty('ComputerNamePhysicalNetBIOS')
will give you the name of the current node, for a non clustered server it returns...
July 21, 2006 at 5:11 am
as I say , more spindles and raid 10 will improve things. Changing to 15k scssi disks would work wonders mind, a 15k disk will support maybe twice the i/o...
July 21, 2006 at 2:40 am
right click on table in MS and script to create as new query.
There are some good books available on sql 2005 !!
July 21, 2006 at 2:37 am
From my view this was one of the not so good features of sql server 2005 as it allows for "woolly" data definitions.
My preference would always be to allocate the size...
July 21, 2006 at 2:30 am
How do you mean performaing badly, what metrics are you using to make this assumption?
I would only ever expect a scan on deleted, if the table is small ( a...
July 20, 2006 at 9:59 am
well .. indexes on join columns and sargs may help, depends upon the size of the tables. You might want to try a few compound indexes to cover the sargs.
July 20, 2006 at 9:49 am
well yes and no - you can select them all through EM I believe, or just write a loop in T SQL. You have to apply each log in turn...
July 20, 2006 at 9:34 am
If the optimiser doesn't consider the query needs a parallel execution then it will not use one no matter how hard you try!!
July 20, 2006 at 9:32 am
You'll have hyperthreading which is why sql server sees 4 procs - this is normal and good ( don't let anyone tell you to turn off hyperthreading it works fine...
July 20, 2006 at 9:29 am
yup easy, create a clustered index ( on the desired column of the table ) then remove the clustered index.
I'd seriously advise about tables without integrity constraints - but that's...
July 20, 2006 at 9:12 am
porting your problems to 2005 is quite good. The tuning advisor is very good I understand.
I normally use Teratrax or Diagnostic Manager to collect worst performing then use a test...
July 20, 2006 at 9:11 am
please don't multiple post.
July 20, 2006 at 9:03 am
Well, having been down this route a number of times I can make one essential suggestion - keep it simple!
I always go for table partitioning as first point. If...
July 20, 2006 at 9:02 am
Hmmm, that's very harsh! Tuning is an art which takes some time to learn as is very obvious from the postings in the various forums. It's all so much easier...
July 20, 2006 at 8:53 am
Viewing 15 posts - 1,996 through 2,010 (of 2,640 total)