Gail Shaw

Forum Replies Created

Viewing 15 posts - 37,726 through 37,740 (of 49,566 total)

RE: The ROI for PASS 2009

Is there any way that those of us using other registration codes can come to the party?

July 13, 2009 at 3:08 am

#1023739
RE: Are the posted questions getting worse?

Lynn Pettis (7/13/2009)
GilaMonster (7/13/2009)
Lynn Pettis (7/10/2009)
On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.
For that matter, anyone heard from Grant?...

July 13, 2009 at 2:50 am

#1023728
RE: Are the posted questions getting worse?

Lynn Pettis (7/10/2009)
On a totally different subject, Anyone hear from Bob lately? Haven't seen him on SSC for a while.
For that matter, anyone heard from Grant? I think he...

July 13, 2009 at 2:11 am

#1023716
RE: The Worst Advice

dmoldovan (7/13/2009)
Besides what GilaMonster had already mentioned - directly changing data in the system tables (sql 2000).
Oh yeah, that's always fun. Often the consequences are only noticed after upgrading to...

July 13, 2009 at 2:09 am

#1023715
RE: change back the db from emergency to normal

Sourav Mukherjee (7/13/2009)
Just before running the dbcc checkdb statement I had to take it in single_user mode.
Yup. All repairs have to be run with the DB in single user mode.

July 13, 2009 at 2:08 am

#1023714
RE: SET ROWCOUNT usage with DELETE..

Jeffrey Williams (7/12/2009)
GilaMonster (7/12/2009)
If you want to delete the oldest rows, then you need something like this (because order by is not permitted in a delete statement)
DELETE FROM SomeTable WHERE...

July 12, 2009 at 11:22 am

#1023624
RE: change back the db from emergency to normal

Sourav Mukherjee (7/12/2009)
2. Then stopped the SQL Server.
3. Deleted the 2 files(mdf and ldfs).
4. Then changed the .mdf file of the old file(abc.mdf) to abc1.mdf
5. Resatrted the SQL Service
ALTER DATABASE...

July 12, 2009 at 9:08 am

#1023618
RE: SET ROWCOUNT usage with DELETE..

LeelaKrishna (7/11/2009)
In one of stored procedures written ages back which uses SET ROWCOUNT to limit rows effected by DELETE operation after that.. Rows from BOTTOM (Old rows) are getting deleted...

July 12, 2009 at 3:56 am

#1023583
RE: How to recover my user database if LDF is lost?

Sourav Mukherjee (7/12/2009)
If the .LDF is gone, what are the steps required to follow to recover the database if I am using SQL 2005 and 2008?
Restore from backup. If you...

July 12, 2009 at 3:32 am

#1023582
RE: Missing Index

There's probably a column different somewhere. Missing indexes doesn't take into account existing similar indexes. Take that DMV with a pinch of salt, it's recommendations are not always accurate and...

July 11, 2009 at 9:17 am

#1023514
RE: SQL script to Restore a DB to standard starting point for Test purposes

SQAPro (7/9/2009)
... staffed by folks who are experienced experts in this field, and yet, seem to be unble to resolve an basic issue with a website correctly accessing a datase.....

July 11, 2009 at 9:16 am

#1023512
RE: The Worst Advice

Lynn Pettis (7/11/2009)
Partly disagree here. True, you should just answer never, ever use a cursor, but ....
Is there a 'not' missing from that sentence?

July 11, 2009 at 9:08 am

#1023510
RE: Managing Transaction Logs

A full backup backups up the data in the database and then backs up just enough of the transaction log so that when the backup is restored, it can be...

July 11, 2009 at 5:14 am

#1023479
RE: SQL Server 2008 SP1 Issues

I think definitely time to give Product support a call

July 11, 2009 at 4:53 am

#1023474
RE: View is not performing well

Please post the view's definitions, table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

July 10, 2009 at 3:39 pm

#1023395

Viewing 15 posts - 37,726 through 37,740 (of 49,566 total)