Viewing 15 posts - 21,451 through 21,465 (of 49,552 total)
MasterDB (1/2/2012)
My Requirement is i want yesterdays records and todays inserted records and today updated yesterday's records.
Do you want the data as reflected in the source database? Or do 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
January 2, 2012 at 4:45 am
You can put a password on the backup, but it's incredibly weak and won't stop someone who's determined.
The only real way to prevent backups from being restored on other servers...
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 2, 2012 at 4:40 am
Sachin Nandanwar (1/2/2012)
But the amazing thing is that the overall DB size and the back up size also is much larger.
Deleting data won't reduce the size of the DB files....
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 2, 2012 at 4:38 am
Sachin Nandanwar (1/2/2012)
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 2, 2012 at 4:36 am
Right, so if you check the page count of the heap (the table) it's 1008150 pages (7.7GB) and the index is in total 138 225 pages (total across all levels), making...
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 2, 2012 at 2:54 am
Sachin Nandanwar (1/2/2012)
GilaMonster (1/2/2012)
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 2, 2012 at 2:51 am
Can you run DBCC UPDATEUSAGE please?
Forwarding pointers are only found in heaps (so there can't be any in the NC index) and they seldom make the table much larger than...
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 2, 2012 at 1:34 am
No. Without a backup you're going to have to run CheckDB with repair_allow_data_loss to fix that. As the option implies it allows data loss and a single page from the...
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 2, 2012 at 1:30 am
It's possible, but it's not easy. You'd need to mess with object ownership
The other way is dynamic SQL. That requires explicit permissions on the objects referred within (which is one...
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 1, 2012 at 3:22 pm
There's no such option.
If you want to break ownership chaining, you'll have to make sure that the various objects are owned by different database users. (not necessarily created by, 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
January 1, 2012 at 2:07 pm
A restart is unlikely to fix that. I suspect a reinit of the log shipping (from a fresh backup) will be needed.
Try a restart first, it's quick, but I doubt...
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
December 31, 2011 at 2:23 pm
Welsh Corgi (12/31/2011)
I see that you reverted to your old Avatar?:cool:
Yeah. I'm playing KOTOR again (SWTOR not available in my region) and playing in an online PBP starwars RPG, so...
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
December 31, 2011 at 11:29 am
george sibbald (12/31/2011)
you only need to run dbcc checkdb on a regular basis, as all the other check commands are a subset of this one command (checkalloc, checktable etc).
With the...
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
December 31, 2011 at 10:58 am
If the system in general is slow, I'd start here.
Btw, what business does an app have for pulling 18 000 records down? No one is ever going to read 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
December 31, 2011 at 10:57 am
pallavi.unde (12/31/2011)
before delete ON stu_table FOR EACH ROW
BEGIN
INSERT into stu_log(user_id, description)
VALUES (user(),...
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
December 31, 2011 at 4:53 am
Viewing 15 posts - 21,451 through 21,465 (of 49,552 total)