Viewing 15 posts - 37,951 through 37,965 (of 49,552 total)
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?...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 2, 2009 at 3:46 am
MichaelJasson (7/2/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2009 at 2:53 pm
delete from ATable where TimeStamp = 'somedatetime';
what is the timestamp ... can we use this ....
Lynn was referring to whatever column it is that stored the date inserted. If you...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2009 at 2:48 pm
Delete from SomeTable WHERE SomeDateColumn < '2000/01/01'
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2009 at 2:10 pm
blandry (7/1/2009)
I would really love to know just how true this statement is - just out of curiosity - because in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2009 at 2:01 pm
Let me guess, this is a database upgraded from SQL 2000?
What probably happened is that someone was messing with the system tables in SQL 2000 (where it was allowed) and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 1, 2009 at 1:49 pm
Viewing 15 posts - 37,951 through 37,965 (of 49,552 total)