Viewing 15 posts - 44,251 through 44,265 (of 49,571 total)
Can you post the proc, the table and the index defs? Are there certain columns that will be more frequently searched than others?
September 24, 2008 at 1:08 am
What do you mean by 'clustered drive'?
September 24, 2008 at 1:07 am
Did you select the client tools during the install?
Note if you have developer on CD, that there are 2 CDs, one with the server components and one with the client...
September 24, 2008 at 12:44 am
Ah. Makes sense.
Biggest things to keep in mind is to not reference any DB other than master within the trigger, make sure that there are no permissions issues (I recommend...
September 24, 2008 at 12:41 am
matt stockham (9/23/2008)
1) why do inserts scale so much better than updates and deletes on a workstation? A page is a page,...
September 24, 2008 at 12:36 am
Jeff Moden (9/23/2008)
GilaMonster (9/23/2008)
September 24, 2008 at 12:35 am
Jeff Moden (9/23/2008)
Heh... I still want to know why the op wants to do this. :hehe:
Dunno about the OP, but I had a very similar piece of code in one...
September 24, 2008 at 12:25 am
Wilfred van Dijk (9/23/2008)
Thanks for your input. Thus: forwarding pointers can only occur on heaps, while page splits only occur on indexes?
Pretty much.
September 24, 2008 at 12:22 am
Ahmad Osama (9/23/2008)
GilaMonster (9/23/2008)
September 24, 2008 at 12:21 am
Wilfred van Dijk (5/26/2008)
Hi,AFAIK, A heap table can be fragmented because of page splits, which results in forward lookups.
Is there a way to calculate this fragmentation?
Heaps don't suffer page...
September 23, 2008 at 3:34 pm
The main problem I would see is the learning curve. MySQL can run on windows, but it will still require some time to get familiar with the admin requirements and...
September 23, 2008 at 2:34 pm
fais (9/23/2008)
September 23, 2008 at 2:27 pm
Not using the native backup tools.
You can always bcp the table out, or make a copy of it in another DB with select .. into
September 23, 2008 at 1:34 pm
YSLGuru (9/23/2008)
Is there an easy way to ask SSMS to locate any column in any able of a database that is setup with the data type unique identifier?
Why not ask...
September 23, 2008 at 12:55 pm
Viewing 15 posts - 44,251 through 44,265 (of 49,571 total)