Viewing 15 posts - 30,676 through 30,690 (of 49,552 total)
Brandie Tarvin (9/15/2010)
SELECT [No biltong] = 'Absolute, total disaster'
I tried your code. It does not compute.
Msg 257, Level 16, State 3, Line 2
Implicit conversion from data type varchar to varbinary...
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
September 15, 2010 at 9:06 am
Stefan Krzywicki (9/15/2010)
Do you have a link for the recommendations for a cluster that you mentioned? I'd love to read more on it.
Is it a valid reference if I wrote...
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
September 15, 2010 at 9:05 am
Magy (9/15/2010)
Oh I see...thanks for BOL link.I tried using 101 instead of 103, and I still get a random order by.
101 orders Month/day/year, I don't think that's what you want...
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
September 15, 2010 at 9:02 am
If you look in BoL, you'll see that format code 103 formats the date dd/mm/yyyy, so it'll be sorted in that order, by day first, then month, then year. 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
September 15, 2010 at 8:39 am
PageIOLatch is a wait on physical IO, not PageLatch.
None of those waits look particularly high. Also, that DMV shows info since SQL started. If SQL's been running a long time,...
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
September 15, 2010 at 8:31 am
Chris Morris-439714 (9/15/2010)
Paul White NZ (9/15/2010)
Chad Crawford (9/14/2010)
If only you and DEAD people can read Hex, how many people can read Hex?
Don't know. But I do know 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
September 15, 2010 at 8:28 am
WayneS (9/15/2010)
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
September 15, 2010 at 8:26 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic986215-357-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
September 15, 2010 at 7:10 am
fawwad (9/15/2010)
one more thing regarding examshow many questions i have to answer correctly atleast.
No way to know. The distribution of marks is not available. There's no way to...
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
September 15, 2010 at 7:05 am
SELECT DISTINCT
ID,
CASE
WHEN EXISTS (SELECT 1 FROM @tmp sub WHERE sub.id = t.ID AND Status = 5)
AND EXISTS (SELECT 1 FROM @tmp sub WHERE sub.id = t.ID AND Status...
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
September 15, 2010 at 3:20 am
As I said
GilaMonster (9/15/2010)
Not without testing and making sure the recommendations really help. Test them out one by one, implement the ones that do help.
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
September 15, 2010 at 3:14 am
I'm not reading through 10 plans to guess which is the problem. Do some investigation on your side, run the queries in Management Studio, and work out which of them...
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
September 15, 2010 at 2:54 am
ravisamigo (9/15/2010)
Ok, So, Stored procedure is not causing this issue.
No, I didn't say that. The error you posted is not related to the latch waits, but badly written, sub-optimal queries...
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
September 15, 2010 at 2:51 am
Stefan Krzywicki (9/14/2010)
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
September 15, 2010 at 2:46 am
http://www.brentozar.com/sql/how-to-get-a-junior-dba-job/
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
September 15, 2010 at 1:55 am
Viewing 15 posts - 30,676 through 30,690 (of 49,552 total)