Viewing 15 posts - 226 through 240 (of 514 total)
Fragmentation is caused by several factors. However, that wasn't the point of the suggestion. The point was to improve your loading performance. Was it faster? And...
November 5, 2007 at 11:10 am
Given you are new to this. Why are we talking about 5 instances? You wouldn't have an Oracle Background would you? There are good reasons for more...
November 5, 2007 at 7:30 am
MBA for sure, or at least take some courses on Project Managment. That is always a good step towards managment. Prove you can manage a project and people...
November 5, 2007 at 7:27 am
The biggest advantage of using hints is that you KNOW how it is going to execute. If consistency is more important than performance this may be the right idea....
November 5, 2007 at 7:21 am
The two most likely possible issues here are as mentioned:
Parameter sniffing, which will result in different execution plans. (can we see them, or have you at least checked them?)
Caching of...
November 5, 2007 at 7:12 am
We use backup exec, and I can't believe I am going to say this....
Oh I can't say it(how many issues we have had). I recommend it. Sorry if...
November 5, 2007 at 7:00 am
Yes.. Set Max to 5G for each of the 5 instances for a total of 25G. You can also set the Min to 5G which will LOCK all...
November 5, 2007 at 6:55 am
I forgot to add.
If you have several queries (which most people do) create an index based upon the more common set of those fields.
Example:
select where a,b,c
select...
November 2, 2007 at 6:20 am
If you have an identity field PK, then it should be your clustered index. There are many reasons why, but simple one is data is organized in the table...
November 2, 2007 at 6:11 am
I've been at both ends of the spectrum on this. I used to work for a company where any, and I mean ANY, change was required authorisation and no...
November 1, 2007 at 11:03 am
TheSQLGuru (11/1/2007)
November 1, 2007 at 10:42 am
TheSQLGuru (11/1/2007)
I think 6 should be removed from the list. Performance improvements are always welcome IMHO. Preventing user complaints should be a goal of all companies!
Actually that really...
November 1, 2007 at 9:29 am
I had an issue recently where my restores were taking excessively long. Things to check.
Obviously Virus software disabled.
Patches are up to date.
Are these disks Raid 5?
The creation...
October 31, 2007 at 1:57 pm
begin tran
update table1 set ClientID=@ClientID, Description=@Desc,ChangeDate=@ChangeDate where ID=@ID
if @@error<>0
begin
rollback tran
end
If the error occurs above, the next statement WILL execute outside of a transaction, but will error after...
October 31, 2007 at 11:09 am
You have 3 columns in the table, and 2 are FOREIGN KEY and the other is VALUE?
Put an index on your date field. For whatever reason you are doing...
October 31, 2007 at 6:55 am
Viewing 15 posts - 226 through 240 (of 514 total)