Viewing 15 posts - 36,856 through 36,870 (of 49,552 total)
russ (8/24/2009)
The issue I am concerned with is table changes first go to the log file then the data file.
Mostly correct. More correct would be to say that the changes...
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
August 24, 2009 at 8:06 am
Krasavita (8/24/2009)
It is 2000 edition
Then why is it posted in a sQL 2005 forum?
it locks all of the tables in the database.Reorginizes data and index pages.Change persantage to 10...
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
August 24, 2009 at 8:04 am
t-jonat (8/19/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
August 24, 2009 at 12:02 am
The best way to avoid deadlocks are optimal code and effective indexes.
If you're getting deadlocks, please can you post table structure, the two queries involved and the deadlock graph.
Switch traceflag...
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
August 23, 2009 at 11:59 pm
panwar.jt (8/23/2009)
I like to remind once again that this problem comes only in report display if i run this proc in query analyzer it run perfectly.
In that case, I'd personally...
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
August 23, 2009 at 11:56 pm
since1980 (8/23/2009)
Reconfigure with override
...
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
August 23, 2009 at 11:52 pm
RBarryYoung (8/23/2009)
I thought it important that the OP know that between Gail, Sarab and now Mike, you're getting some of the best help in existence.
Well, I know just about enough...
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
August 23, 2009 at 1:23 pm
Edit: Removed complete garbage.
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
August 23, 2009 at 9:27 am
newbie2sql (8/23/2009)
sys.data_spaces for the filegroup (for tables only) and either sp_spaceused or sys.dm_db_index_physical_stats for the size (again, only for tables)
Thanks for the info. But how do i find for indexes...
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
August 23, 2009 at 6:27 am
You'll need sys.objects for the name and type, sys.partitions and sys.data_spaces for the filegroup (for tables only) and either sp_spaceused or sys.dm_db_index_physical_stats for the size (again, only for tables).
If there's...
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
August 23, 2009 at 6:09 am
luckysql.kinda (8/23/2009)
Yes the older one I have but that is really very old.
If this is critical data, how come you only have one very old backup? Isn't this getting...
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
August 23, 2009 at 4:05 am
As far as I'm aware, without the certificate the data cannot be decrypted at all.
Do you have an older backup that still has the certificate and master key in? If...
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
August 23, 2009 at 2:57 am
No.
SQL backups are database, filegroup and file. You could, technically, put the table into a filegroup by itself and back that up, but when restoring you'd still need the primary...
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
August 23, 2009 at 2:54 am
Moved here: http://www.sqlservercentral.com/Forums/Topic775644-146-1.aspx
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
August 23, 2009 at 2:52 am
I don't have a permanent personal black list, though do have a couple people on the 'I'm not helping them until they change behaviour' list. Currently it contains the PhD...
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
August 23, 2009 at 2:45 am
Viewing 15 posts - 36,856 through 36,870 (of 49,552 total)