Viewing 15 posts - 20,356 through 20,370 (of 49,552 total)
bitbucket-25253 (2/13/2012)
Hmmm not as many unused indexes as I thought might be there.
Bear in mind those are clustered indexes, so they don't have the same 'unused' rule as nonclustered...
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
February 13, 2012 at 6:50 am
Start by only rebuilding what you need to rebuild, not everything.
Use backup compression if on Enterprise or Standard edition
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
February 13, 2012 at 5:30 am
Yes
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
February 13, 2012 at 4:16 am
I'm guessing the instance isn't running.
Are you sure that the path you set for the model DB matches the one that the files are in?
What's the contents of the error...
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
February 13, 2012 at 1:58 am
stanley wong-314201 (2/12/2012)
1. I need to add additonal space into the mdf files , please advice how much space should be added ?
You need roughly the size of the index...
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
February 13, 2012 at 1:51 am
That's a whole nother problem, and the first thing you need to do is identify the cause, not guess the cause.
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
February 13, 2012 at 1:43 am
Well it's preventing CheckDB from running, so it's a concern in that you can't do integrity checks...
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
February 12, 2012 at 2:13 pm
Changing passwords is easy, a sysadmin can change passwords without knowing the old values. ALTER LOGIN...
The hashed passwords however cannot be recovered. The hash is a one-way hash
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
February 12, 2012 at 2:11 pm
Dev (2/12/2012)
Does it mean 1 TB database will have ~1 TB backups (FULL, without compression)?
If there's 1 TB of data in there, yes. How else would 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
February 12, 2012 at 2:09 pm
Dev (2/12/2012)
GilaMonster (2/12/2012)
Dev (2/12/2012)
Why are you so surprised?
Tell me exactly how a 400 GB database will generally have a full backup of under 100GB (and note...
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
February 12, 2012 at 4:03 am
mssql.dba (2/12/2012)
i want to know how to split the database backup into multiple disks and how to restore them
If you specify multiple destinations for your backup, the data will...
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
February 12, 2012 at 3:55 am
Have you considered and investigated Query Notifications?
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
February 12, 2012 at 3:48 am
Dev (2/12/2012)
Why are you so surprised?
Tell me exactly how a 400 GB database will generally have a full backup of under 100GB (and note that backup compression wasn't...
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
February 12, 2012 at 3:43 am
Multiple updates that have different joins, different conditions must be combined into a single update?
So
Update TableA
SET <whatever>
FROM TableA inner join TableB on <someCondition>
Inner Join TableC On <someOtherCondition>
Where TableB.SomeColumn =...
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
February 12, 2012 at 3:37 am
Dev (2/12/2012)
Do you have a database of 400 GB? In general, its FULL backup won’t cross 100 GB size.
A database of 400 GB will generally 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
February 12, 2012 at 3:29 am
Viewing 15 posts - 20,356 through 20,370 (of 49,552 total)