Viewing 15 posts - 37,966 through 37,980 (of 49,571 total)
Honestly, I don't trust IDW and I don't use ITW. This is one of the reasons. Some other people have mentioned much the same behaviour with the 2005 DTA. I...
July 2, 2009 at 7:08 am
Is there a question there?
If you want advice on memory settings, you're going to specify the hardware in that server. Just seeing DBCC memory status alone says very little.
July 2, 2009 at 6:23 am
Most likely it's because the index isn't covering and there's too many rows returned for an index seek + bookmark lookups to be optimal.
See - http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/
If you want more specific...
July 2, 2009 at 5:54 am
MichaelJasson (7/2/2009)
July 2, 2009 at 5:47 am
MichaelJasson (7/2/2009)
Can you give me any link which tells me that I can use them as I am going to do this on a production server.
A production server running Vista?...
July 2, 2009 at 4:55 am
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 2, 2009 at 3:46 am
MichaelJasson (7/2/2009)
July 2, 2009 at 3:40 am
John Paul (7/1/2009)
http://www.sqlteam.com/article/performing-a-cascade-delete-in-sql-server-7
That's written for SQL 7. Sure you want to use that?
I don't get why you want a specialised proc to do it. If you're got two tables Parent...
July 2, 2009 at 2:18 am
Vishal Singh (7/2/2009)
2) SQL Server VNET++ : this will be the new release of SQL server in 2011. perhaps the code name is "Project Madison".
this...
July 2, 2009 at 2:14 am
Can't see any reason why the delete would fail.
restart SQL in single user mode
Connect via the DAC
Then run sp_configure 'allow updates'
RECONFIGURE
Then find out what tables and what rows you need...
July 2, 2009 at 1:51 am
Vishal Singh (7/1/2009)
In fact, if I look on the editions of 2010 and according tohttp://www.brentozar.com/archive/2009/02/sql-server-2010-features-leaked/
You may want to read that article again. From the bottom of it.
Brent Ozar
July 2, 2009 at 1:25 am
suresh0123456789 (7/1/2009)
Is there any way to delete records without dropping FKs
Delete the child records first.
If you want to make the fk cascade, look up ALTER TABLE in Books online. That'll...
July 1, 2009 at 3:56 pm
WayneS (7/1/2009)
Lynn Pettis (7/1/2009)
I need you to give me a script that will automagically determine what records to delete from unspecified tables.I mean really, you want fries with that too?
Just...
July 1, 2009 at 3:49 pm
lmu92 (7/1/2009)
Let's assume you'd delete the first 75% ordered by primary key (hoping there is one).
and assuming it's an identity.
July 1, 2009 at 3:01 pm
Lynn Pettis (7/1/2009)
I need you to give me a script that will automagically determine what records to delete from unspecified tables.I mean really, you want fries with that too?
Yes please....
July 1, 2009 at 2:53 pm
Viewing 15 posts - 37,966 through 37,980 (of 49,571 total)