Viewing 15 posts - 22,906 through 22,920 (of 49,552 total)
There's no need to remove replication and detach, and backup/restore (while it works) is not exactly quick.
Look in Books Online under ALTER DATABASE for the syntax for ALTER DATABASE ......
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
October 18, 2011 at 8:30 am
Did you try google? I ask because I know that particular search brings up useful results.
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
October 18, 2011 at 8:19 am
That's the files names. They have to be unique in a database only, anywhere they're used they're either used with the database name or only for the currently selected database.
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
October 18, 2011 at 8:06 am
Brandie Tarvin (10/18/2011)
Obviously, the IAM page with object ID 1275867612, index of 10 is "missing".
Nope, the IAM page is intact. The sentence reads <one IAM page> was pointed 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
October 18, 2011 at 8:00 am
Logical name of the database (which has to be unique within an instance) or logical names of the database files (which have to be unique within the database)?
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
October 18, 2011 at 7:54 am
I need a couple proof-readers for the rewrite of Managing Execution Plans. reply or PM if you're keen. Article's not that long, 7 pages.
Thanks
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
October 18, 2011 at 7:51 am
Interview questions is my bet, with no research done. Google is almost certain to have useful results for all of those.
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
October 18, 2011 at 7:47 am
ruan.keyser (10/14/2011)
Avg. Disk sec/Read - 0.005Avg. Disk sec/Write - 0.036
Avg. Disk Queue length - 0.095
% Disk Time - 3.104
When did you check those? While the system is under heavy load...
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
October 18, 2011 at 7:38 am
dfine (10/18/2011)
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
October 18, 2011 at 7:37 am
Grant Fritchey (10/16/2011)
Oh, and Gail, in case you don't see this tweet from SirSQL:
@GFritchey @SQLintheWild I used what I learned in your precon to fix an outage situation caused by...
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
October 18, 2011 at 7:32 am
ruan.keyser (10/17/2011)
I've been put in an environment that was lacking performance...
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
October 18, 2011 at 7:28 am
Let me see if I have this correctly, a job has been reporting that your database is corrupt for a long time and nothing's been done? Wow.
Got a clean 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
October 18, 2011 at 7:21 am
SQL will always detect and resolve deadlocks. You don't need to enable anything or do anything.
Are you sure it's a deadlock and not just a long blocking chain?
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
October 17, 2011 at 1:44 am
ruan.keyser (10/16/2011)
Luckily I know that the logs and data should be seperated.So, in conclusion, the issue is with the hdd's? I believe they are running at 7200rpm.
In other words, they're...
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
October 17, 2011 at 1:41 am
Steve Jones - SSC Editor (10/5/2011)
IRE v WAL = IRE
ENG v FRA = ENG
RSA v AUS = AUS...
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
October 16, 2011 at 1:40 pm
Viewing 15 posts - 22,906 through 22,920 (of 49,552 total)