Viewing 15 posts - 29,011 through 29,025 (of 49,552 total)
zahidshah (12/6/2010)
After some changes in database, we want to restore the data,we have the trn file
What do you mean by 'after some changes'?
The error indicates that you brought 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
December 7, 2010 at 12:49 am
sqldba_icon (12/6/2010)
GilaMonster (12/6/2010)
Which events are you tracing?I have attached the script.
I'm not spending an hour or so looking up the event classes in Books online and comparing them with your...
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
December 6, 2010 at 11:01 pm
One other point.
IN (SELECT * ....
That will fail if there's more than one column in that table. Fix it to specify the exact column used for the IN.
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
December 6, 2010 at 2:39 pm
Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
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
December 6, 2010 at 2:34 pm
http://sqlinthewild.co.za/index.php/2010/10/12/a-trio-of-table-variables/
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
December 6, 2010 at 2:20 pm
allin1 (12/6/2010)
Is it not meaningful to keep DBs on a seperate partition than OS?
No it's meaningful to keep DBs on separate drive to OS. Separate physical drive. With 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
December 6, 2010 at 2:19 pm
Which events are you tracing?
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
December 6, 2010 at 2:16 pm
ken.trock (12/6/2010)
GilaMonster (12/6/2010)
Select
Distinct RCD.Variable4
FROM Route_Call_Detail RCD
WHERE RCD.[DateTime] > '12/4/10'
AND RCD.[DateTime] < '12/5/10'
AND CASE WHEN SUBSTRING(RCD.Variable4,...
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
December 6, 2010 at 1:18 pm
To get the exec plan you'll need profiler. I believe it's the statistics XML event.
http://sqlinthewild.co.za/index.php/2009/04/29/functions-io-statistics-and-the-execution-plan/
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
December 6, 2010 at 1:01 pm
Or, as an (untested) alternative.
Select
Distinct RCD.Variable4
FROM Route_Call_Detail RCD
WHERE RCD.[DateTime] > '12/4/10'
AND RCD.[DateTime] < '12/5/10'
AND CASE WHEN SUBSTRING(RCD.Variable4, 1, 6)...
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
December 6, 2010 at 12:00 pm
SQL makes no guarantee as to what order expressions will be evaluated in and, as such, one cannot assume that any form of 'short-circuiting' will always occur, especially when dealing...
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
December 6, 2010 at 11:48 am
Vardecimal was introduced in 2005 SP 1(iirc) and deprecated in SQl 2008 (replaced by compression). I cannot remember the exact syntax, but it should be an ALTER DATABASE to enable...
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
December 6, 2010 at 11:22 am
<sigh> Please go and do some reading on mirroring before you try implementing it.
IF the mirroring session becomes suspended (and please read up on what 'suspended' means for a mirroring...
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
December 6, 2010 at 9:44 am
Looks like my former ISP's support. I recall them pondering most perplexed over an IPConfig that showed no network connection when I called them to report that I had no...
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
December 6, 2010 at 9:41 am
You missed a key clause.
I said
"unless mirroring gets suspended, then log grows because log records can't be discarded."
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
December 6, 2010 at 9:37 am
Viewing 15 posts - 29,011 through 29,025 (of 49,552 total)