Viewing 15 posts - 38,596 through 38,610 (of 49,552 total)
Florian Reischl (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?Deja Vu (on a German forum...?!?)
At least he went and found the wiki article himself....
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
June 8, 2009 at 10:29 am
Is that iSCSI drive network attached storage?
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
June 8, 2009 at 10:27 am
karthikeyan (6/8/2009)
Yes Gail...I have studied...But i don't remember the functionality...I have reviewed the above mentioed URL, Since there are lot of formula's are there,it is confusing...
Ok, explain what you do...
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
June 8, 2009 at 10:25 am
Tom Brown (6/8/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
June 8, 2009 at 10:17 am
Lynn Pettis (6/8/2009)
GilaMonster (6/8/2009)
Hey Barry. How about some basic Computer Science theory to start the day?Oh, great, our "PhD Candidate". Could have warned us on that one, Gail.
And spoil...
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
June 8, 2009 at 10:14 am
GURSETHI (6/8/2009)
Hi,We can also query a DMV which will tell how much %age a specific query has done.
SELECT SESSION_ID, percent_complete, estimated_completion_time FROM SYS.DM_EXEC_REUQESTS
From Books Online:
percent_complete
Percent of work completed for...
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
June 8, 2009 at 10:10 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
June 8, 2009 at 6:01 am
Hey Barry. How about some basic Computer Science theory to start the day?
http://www.sqlservercentral.com/Forums/Topic730611-8-1.aspx
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
June 8, 2009 at 6:00 am
General rule-of-thumb. It will take longer to roll a process back than it did to do the work to that point. So if you roll back a process that has...
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
June 8, 2009 at 5:57 am
karthikeyan (6/8/2009)
1) O(n) means ?2) O(n^2) means ?
3) O(n log n) means ?
Surely you covered the Big O notation for algorithmic (time) complexity at university? It's a fundamental of Comp...
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
June 8, 2009 at 5:53 am
You'll either have to fix the dependencies or move the DB files to a drive that's already a dependency.
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
June 8, 2009 at 5:48 am
Krishna Potlakayala (6/8/2009)
Yes, the server is recovering the database. Was there any sudden shut down of the SQL Server? Just wait till it comes back online again.
That's true of...
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
June 8, 2009 at 5:45 am
In SQL Server triggers fire once per statement. There is no row trigger in SQL Server. The trigger fires once and all the affected rows are present in the inserted...
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
June 8, 2009 at 5:44 am
Recovery pending means that for some reason SQL cannot run restart recovery on the database. Usually this is because the log is missing or corrupt.
"G:\Data\MSSQL\Database.mdf".
"G:\Data\MSSQL\Data\Database_log.ldf"
Do these files exist? Is 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
June 8, 2009 at 5:43 am
When the log file is grown, the VLFs in the old portion are left as they are and new ones created for the new section. If you want to 'reset'...
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
June 8, 2009 at 3:14 am
Viewing 15 posts - 38,596 through 38,610 (of 49,552 total)