Viewing 15 posts - 36,436 through 36,450 (of 49,552 total)
Guru Nagabhushan (10/5/2009)
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 5, 2009 at 11:13 pm
Would you mind sharing the actual subject and context for the question?
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 5, 2009 at 2:28 pm
Homework? Test? Interview?
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 5, 2009 at 1:26 pm
SELECT
CAST([2] AS VARCHAR(50)) AS [Size],
CAST([3] AS VARCHAR(50)) AS Placement
INTO #Parse
FROM Split
PIVOT ( MAX(value) FOR idx IN ( [1], [2]) ) AS P
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 5, 2009 at 1:14 pm
repent_kog_is_near (10/5/2009)
the tempDB issue was powerful enough to knock out the cluster drives.
A disk full error shouldn't take a disk offline. What does the cluster log say?
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 5, 2009 at 1:08 pm
Guru Nagabhushan (10/5/2009)
I am hoping that SQL 2008 doesn't have these issues and has a better algorithm for managing stats.
The stats update algorithm is unchanged in SQL 2008
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
October 5, 2009 at 1:06 pm
repent_kog_is_near (10/5/2009)
GailThese are the 3 repeated errors in the logs..
Please post the contents (or partial contents) of the SQL error log. Need the end of the log, probably from...
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 5, 2009 at 1:02 pm
What does the SQL error log say? It's a file called Errorlog, just search for it, should be easy enough to find.
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 5, 2009 at 12:28 pm
Lowell (10/5/2009)
ouch that sysindexes is handy and i haven't found any view that still tracks that [rows] and [rowmodctr] yet.
Rows are in sys.partitions, though you should aggregate by object 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
October 5, 2009 at 12:28 pm
hanxue.lee (10/5/2009)
Since my access is read-only, I would imagine this is possible without affecting the operations of the database.
Nope. SQL takes exclusive 'locks' on the files. Can't be read or...
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 5, 2009 at 11:57 am
Just bear in mind that sysindexes is deprecated, will be removed in a future version of SQL server and that the rowmodcol is not longer 'accurate'. It's a calculation based...
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 5, 2009 at 11:52 am
wodom (10/5/2009)
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 5, 2009 at 11:51 am
Caching is something you need to do on the client, SQL doesn't have the capabilities of caching a query's result (unless you go and stick the result into a table)
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
October 5, 2009 at 11:12 am
Guru Nagabhushan (10/5/2009)
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 5, 2009 at 11:09 am
Why oh why oh why do you not have backups?
Do note that neither ApexSQL nor Lumigent's log readers are free.
Apex SQL Log: $999 per server
Lumigent Log Explorer: Starts at...
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 5, 2009 at 11:04 am
Viewing 15 posts - 36,436 through 36,450 (of 49,552 total)