Viewing 15 posts - 13,141 through 13,155 (of 22,215 total)
Whoa, that's a lot of information. To reliably gather the statistics, you need to write the queries that put those statistics together carefully so that it uses indexes and...
February 24, 2011 at 6:48 am
sql_butterfly (2/23/2011)
Thanks Grant. What should be the generalized fillfactor for indexes on OLTP tables ?
I agree with Mr. Holio, or can I call you Bung? It depends. In general, I...
February 24, 2011 at 6:24 am
You'll get a lot more responses if you put up a post like this as a seperate question rather than posting it on top of a different question. Technically this...
February 24, 2011 at 6:20 am
In addition to all that excellent informatoin, don't forget that you may also have deal with resource contention, assuming this is a production system.
February 23, 2011 at 12:09 pm
If you are seeing a consistent disparity between SSMS and the app, check the connections settings to validate that the ANSI settings are the same between both. These can affect...
February 23, 2011 at 12:06 pm
glennhill (2/23/2011)
Thanks for the reply. I was using term "deadlock" loosely. There was no internal deadlock detected by SQL Server but we did indeed have a blocking chain and...
February 23, 2011 at 9:21 am
When you say deadlock situation, do you mean that you hit a deadlock error with one process chosen as a deadlock victim?
Or do you mean that you had a blocking...
February 23, 2011 at 8:27 am
When you say reindex, is that an index defrag or an index rebuild? You'll get less de-fragmentation from the defrag than you do from the rebuild. But also, as was...
February 23, 2011 at 8:14 am
You might want to take a look at this blog entry[/url]. It addresses exactly what you're talking about.
February 23, 2011 at 6:17 am
The first thing that comes to mind is merge replication. Have you looked into that? It's hard to set up and administer, but I think it does what you need.
Other...
February 23, 2011 at 6:15 am
sql_butterfly (2/22/2011)
Hello Friends, Can anyone help me with the strategy to make indexes on OLTP tables ?
That is a gigantic topic and really completely depends on the tables in questions...
February 23, 2011 at 6:12 am
praveensatya (2/22/2011)
As we know read commited is on by default and which means It prevents transactions to read data if some other transaction is doing some update operation on...
February 23, 2011 at 6:09 am
Well, it might not be crazy. The optimizer can, note the key word, eliminate tables that are not in use in an execution plan so that if you're only referring...
February 22, 2011 at 3:17 pm
How big is the varchar field? While they are not as performant as integers, if it's not large and the data inside is selective enough, you can put an index...
February 22, 2011 at 3:15 pm
I know you don't want to reengineer, although I'd consider it, but have you looked at going with Read Committed Snapshot for your isolation level? That will allow you much...
February 22, 2011 at 8:10 am
Viewing 15 posts - 13,141 through 13,155 (of 22,215 total)