Viewing 15 posts - 43,921 through 43,935 (of 49,571 total)
That DB definitely has traces of transactional replication from somewhere in the past.
Ok. Try this.
Create a publication (transactional replication) in that database. Doesn't matter what's included. Pick any table.
Once it's...
October 10, 2008 at 2:27 am
They should be the same.
The cluster admin adds almost no overhead to SQL. It's IsAlive checks are very low-impact.
October 10, 2008 at 2:19 am
george sibbald (10/9/2008)
there is a column 'rowmodctr' in sysindexes which tracks the no of updates since the last update stats. Pretty sure this is what SQL uses for auto_update.
It's what...
October 10, 2008 at 2:11 am
No idea about the switch.
Why are you looking to load balance SQL Server? App servers or web servers load balance well and easily. It's not something that's generally done with...
October 10, 2008 at 2:08 am
There's a major disadvantage to doing that. If you use a query hint you are forcing the optimiser to pick a plan using that index, even if another index would...
October 9, 2008 at 2:28 pm
rajeev.suryanarayan (10/9/2008)
Gail, I have already done that. I have attached the Trace graph in my first post itself (as zip file).
No, that comes from profiler. I looked through and...
October 9, 2008 at 1:29 pm
rajeev.suryanarayan (10/9/2008)
Thanks guys..really appreciate you helping me out here but could you dig deeper into your expertise and forsee something 🙂 Pleasssee...
See my post above, enable the traceflag and get...
October 9, 2008 at 1:00 pm
SQL will cache the exec plan of all queries that it runs. How long the plan stays in cache depends on how often it gets used, how much memory pressure...
October 9, 2008 at 11:29 am
You can enable traceflag 1222 and SQL will write the deadlock graph into the error log. That will help you locate the cause of the deadlock.
The only way to get...
October 9, 2008 at 11:21 am
I'd suggest a sliding percentage based on the table size. From experience, 20% is too high a threshold on larger (+1000000 row) tables
Just bare in mind that not all columns...
October 9, 2008 at 11:13 am
Can you please post the table structure (as a create table statement) and some sample data (as insert statements).
October 9, 2008 at 11:00 am
DBADave (10/9/2008)
We have auto_update_statistics and auto_create_statistics turned off as a vendor requirement. We have to update them manually.
I love vendors like that. They make my job (performance...
October 9, 2008 at 10:45 am
Manie Verster (10/8/2008)
Hi Gail,This is wonderful. I am glad you started this and I will definitely try my best to be there.
Great! I look forward to meeting you.
October 9, 2008 at 10:34 am
williamaffandi (10/9/2008)
Can SQL 2005 actually do this ? And do...
October 9, 2008 at 10:32 am
Then you are going to have to delete the entry in sys.objects manually for that pk, and then deal (again manually) with any child records of that (references in sys.indexes...
October 9, 2008 at 10:28 am
Viewing 15 posts - 43,921 through 43,935 (of 49,571 total)