Viewing 15 posts - 19,951 through 19,965 (of 49,552 total)
How do you recover a failed database mirroring secondary? AlwaysOn will be (mostly) the same.
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
March 2, 2012 at 1:19 pm
Ask around, make sure no one wants the database, maybe attach them and take a backup of the database (and put it somewhere safe) before you delete the files.
Don'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
March 2, 2012 at 11:54 am
benjamin.reyes (3/2/2012)
Would this allow statistics to be generated on the secondary?
Yes, temporary stats in TempDB. Search for AlwaysOn Statistics
Can the secondary have indexes that the primary does...
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
March 2, 2012 at 11:52 am
I would personally just rename it for a little while (make sure it's not used for something siily). Is there a matching mdf anywhere?
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
March 2, 2012 at 11:02 am
Screenshot?
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
March 2, 2012 at 10:37 am
If it belongs to a database that was detached, the ownership could be solely to the SQL Server process. See if you can take ownership, if you can, see 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
March 2, 2012 at 10:37 am
On 2008 what I would recommend is turning both traceflags off and looking into the system health event session instead.
http://sqlskills.com/BLOGS/PAUL/post/Getting-historical-deadlock-info-using-extended-events.aspx
If you wish to stay with traceflags, turn 1204 off. 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
March 2, 2012 at 8:34 am
Not all of that is included in the output of traceflag 1222, the initial blocking statement is not, so you have to check back through procedures (names are listed) 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
March 2, 2012 at 8:17 am
EXEC sp_helpindex 'schemaname.objectname'
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
March 2, 2012 at 8:15 am
T-SQL Fundamentals by Itzik Ben-Gan
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
March 1, 2012 at 11:11 pm
It could make use of the index, but it would be a scan not a seek.
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
March 1, 2012 at 3:43 pm
Could you post your code perhaps (or a repo that shows the same behaviour), along with table designs and maybe sample data?
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
March 1, 2012 at 3:42 pm
Please define 'not work'? Throws an error? Gives incorrect results? Converts the server into a washing machine?
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
March 1, 2012 at 3:22 pm
Just for the record, this is a form of the 'Bin Packing problem', it's a classic AI and optimisation problem and it's NP-hard in the general case.
http://en.wikipedia.org/wiki/Bin_packing
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
March 1, 2012 at 2:38 pm
You absolutely have to do consistency checks of any database, no matter how big. If you don't, you'll never know when something happens to corrupt some pages.
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
March 1, 2012 at 1:39 pm
Viewing 15 posts - 19,951 through 19,965 (of 49,552 total)