Viewing 15 posts - 45,121 through 45,135 (of 49,552 total)
andrew gothard (8/12/2008)
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
August 12, 2008 at 11:06 am
TheSQLGuru (8/12/2008)
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
August 12, 2008 at 11:00 am
kiran (8/12/2008)
can u provide me with download link for Data Dude (free version)
Hehe. There is no free version. Visual Studio Team Edition is the highest level edition of Visual Studio....
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
August 12, 2008 at 10:54 am
Views cannot take parameters. If you need a view-like object that takes parameters, consider using a table-values user-defined function. Be careful, sometimes they have a bad impact on performance.
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
August 12, 2008 at 3:43 am
Ok, a little more challenging, but not much so. Needs a subquery.
SELECT Log_Transactions.assetno, Log_Transactions.pcdatetime, Log_Transactions.tline
FROM Log_Transactions INNER JOIN
(SELECT asstno, MAX(pcdatetime) AS LatestDate FROM Log_Transactions) MaxValues
ON Log_Transactions.asstno = MaxValues.asstno 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
August 12, 2008 at 3:33 am
You're getting repeated rows because you're grouping by the tline as well as the asset number. If you want to see the max tline for eachn asset number (which is...
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
August 12, 2008 at 3:02 am
Adam Zacks (8/12/2008)
Ummm well yes, I suppose... Depends what mood I'm in. Getting married next week with a 3.5 week holiday, so right now dont care about anything! 😉
:hehe: Congratulations....
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
August 12, 2008 at 2:40 am
andrew gothard (8/11/2008)
http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
Think we all know how often people seem to get parachuted into 'looking after the database(s)' and over the years I've seen a pretty...
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
August 12, 2008 at 1:13 am
Are you perhaps switching to simple recovery mode to do the index rebuilds?
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
August 12, 2008 at 1:03 am
Switch traceflag 1204 or 1222 on (DBCC TRACEON (1222,-1)). That will write the deadlock graphs into the error log. With that you can see what is deadlocking and on what...
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
August 12, 2008 at 12:51 am
And another one.
http://sqlinthewild.co.za/index.php/2007/12/19/temp-tables-and-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
August 12, 2008 at 12:44 am
kiranbgiet (8/11/2008)
temporary tables are least in use as they consume the memory resource
Instead of temporary tables you can use the table variable as the table variable is just...
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
August 12, 2008 at 12:39 am
andrew gothard (8/11/2008)
Do you think of any new features which would be helpful
Personally - since 6.5, I've been waiting for the ability to write a view, and then, when I...
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
August 12, 2008 at 12:35 am
Getting back to the original question, fascinating as the discussion is...
purplebirky (8/11/2008)
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
August 11, 2008 at 3:37 pm
andrew gothard (8/11/2008)
Um - you Gail. Hope the suggestion's taken in the way it was meant ...... just thought it was nice and to the point
Wanted to be sure...
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
August 11, 2008 at 2:54 pm
Viewing 15 posts - 45,121 through 45,135 (of 49,552 total)