Viewing 15 posts - 23,101 through 23,115 (of 49,552 total)
parsayandan (10/3/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 3, 2011 at 3:10 pm
Steve Jones - SSC Editor (10/3/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 3, 2011 at 2:24 pm
parsayandan (10/3/2011)
Hellocodevc.com is a code collection website and he collect best and true way in programming and IT
Translation: steals it
you see source link in bottom of page (I accept this...
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 3, 2011 at 2:08 pm
No. That's something you define as part of the trace definition.
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 3, 2011 at 1:23 pm
Sapen (10/3/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 3, 2011 at 12:14 pm
Ninja's_RGR'us (10/3/2011)
Roy Ernest (10/3/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 3, 2011 at 11:57 am
SQL Kiwi (10/3/2011)
GilaMonster (10/3/2011)
Please send your PDF file for Troubleshooting SQL Server: A Guide for the Accidental DBA
in my address
Really. On a...
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 3, 2011 at 11:22 am
On a similar topic, this comment caught my eye...
Please send your PDF file for Troubleshooting SQL Server: A Guide for the Accidental DBA
in my address
Really. On a page advertising a...
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 3, 2011 at 11:07 am
It should be repairable, but you will likely lose data.
http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/
If the process gives any errors stop there and post the errors.
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 3, 2011 at 10:45 am
And we have another candidate for idiot of the week...
http://www.askdbexperts.com/2011/08/managing-growth-of-sql-server.html
http://www.sql-server-performance.com/2011/growth-distribution-database/
http://www.askdbexperts.com/2011/08/moving-sql-server-system-databases.html
http://www.sql-server-performance.com/2011/moving-sql-server-system-databases/
http://www.askdbexperts.com/2011/08/new-t-sql-features-in-sql-server-2011.html
http://www.sql-server-performance.com/2011/tsql-sql-server-2011-features/
http://sqlconsulting.wordpress.com/2011/03/29/new-t-sql-features-in-sql-server-2011/
(Double plagiarism! FTW!)
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 3, 2011 at 10:41 am
Post the SQL error log, from the time of the failure with any messages relating to that DB.
What's the exact state of the database (state_desc from sys.databases for that DB)
A...
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 3, 2011 at 10:27 am
SQLRNNR (10/3/2011)
GilaMonster (10/3/2011)
It's not the only one.http://www.sqlservercentral.com/articles/T-SQL/70809/
and
http://weblogs.asp.net/dotnetstories/archive/2011/09/24/take-an-asp-net-application-offline.aspx
Wow, this guy is a real class act. I wonder what EMC thinks about it?
From what I could see (with a few quick...
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 3, 2011 at 10:22 am
It's not the only one.
http://www.sqlservercentral.com/articles/T-SQL/70809/
and
http://weblogs.asp.net/dotnetstories/archive/2011/09/24/take-an-asp-net-application-offline.aspx
and
http://consultingblogs.emc.com/sujeethkonagalla/archive/2011/09/29/crosstabs-and-pivot-tables.aspx
http://www.simple-talk.com/sql/t-sql-programming/crosstab-pivot-table-workbench/
and
http://www.simple-talk.com/dotnet/.net-framework/using-table-valued-parameters-with-vb.net/
Maybe time for a polite call from RedGate legal dept to EMC Consulting.
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 3, 2011 at 10:18 am
Ninja's_RGR'us (10/3/2011)
GilaMonster (10/3/2011)
Ninja's_RGR'us (10/3/2011)
If I were in the ops shoes, change management procedure / code reviews would be on top of my list in the currently hapenning meeting.
And a QA...
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 3, 2011 at 10:13 am
Sapen (10/3/2011)
Thanks Guys...I have cancelled the ones I used earlier...i will be running it with switches after hours
Probably a good idea. CheckDB is not gentle on a database.
Just make...
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 3, 2011 at 10:13 am
Viewing 15 posts - 23,101 through 23,115 (of 49,552 total)