Viewing 15 posts - 41,641 through 41,655 (of 49,552 total)
Run sp_spaceused on the database and on each of the tables in the database. That should show you where the space is been used, or if it's free space within...
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
January 17, 2009 at 8:32 am
I hate to be blunt but that procedure's absolutely huge (560 lines) and I don't have the spare time to work through that size of proc.
Can you narrow down where...
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
January 17, 2009 at 8:30 am
kiransuram19 (1/17/2009)
NO_LOG | TRUNCATE_ONLYGilaMonster --- This above is the answer I was looking for.
No, it's not. You stated (in the post that you deleted) that you don't want to break...
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
January 17, 2009 at 4:11 am
I've got a similar one that I'm working on, that does have a legit business requirement. I don't need a solution, I did figure one out after staring at it...
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
January 17, 2009 at 2:01 am
kiransuram19 (1/17/2009)
1) How can I Truncate T log so that it can only delete the in-active transactions in the log fileand this should
Did you read the article that...
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
January 17, 2009 at 1:54 am
Not a bad question, but does this guy ever read the posts that he's answering?
http://www.sqlservercentral.com/Forums/FindPost638650.aspx
Question was "I didn't start an explicit transaction, I don't have a backup, how do I...
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
January 17, 2009 at 1:01 am
kiransuram19 (1/16/2009)
(I am confused little bit)..That means when we take a backup it only consider .mdf file size ?
The mdf and enough of the log to be able to restore...
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
January 17, 2009 at 1:01 am
Paresh Prajapati (1/16/2009)
otherwise if u take transaction log backup..then restore full bakup with norecovery and apply log with recovery..
Except that he said he doesn't have a backup.
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
January 17, 2009 at 12:51 am
Themis Tokkaris (1/16/2009)
If I create a Database Backup from a SQL Server 2008 Instance, can I restore this backup on a SQL Server 2005 Instance?
No. It is never possible to...
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
January 16, 2009 at 1:57 pm
The only way you can do that on SQL 2005 is to install a second instance, put some of the DBs on the second instance and change the CPU affinity.
2008'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
January 16, 2009 at 12:39 pm
colin Leversuch-Roberts (1/16/2009)
only if you haven't been using the san I've been testing!!!!
There are worse ways to kill a SAN's performance than RAID 6.
Share the OLTP system's fibre switch with...
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
January 16, 2009 at 12:14 pm
RAID 6?! I missed that.
That, by itself, is going to give you horrendous write times, especially for a tran log
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
January 16, 2009 at 11:36 am
TRACEY (1/16/2009)
Once i got the master working, the msdb, model i can do how?
See the link that Steve and I posted. It has sections for all of the system databases...
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
January 16, 2009 at 11:27 am
RSingh (1/16/2009)
So any thoughts about the time to dbreindex the?
It depends on the performance of the IO system, other activity in SQL, other activity on the server, etc. There's no...
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
January 16, 2009 at 9:28 am
krypto69 (1/16/2009)
I'm looking at Gails suggestion, but to be honest I don't think I have the skill to implement that correctly (that's embarrassing)
What suggestion? The query bits I posted were...
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
January 16, 2009 at 9:27 am
Viewing 15 posts - 41,641 through 41,655 (of 49,552 total)