Viewing 15 posts - 37,996 through 38,010 (of 49,552 total)
So want you want outputting is
Ali, 1
Ali, 2
Ali, 3
Ali, 4
Ali, 5
Ali2, 5
Ali2, 6
Ali2, 7
... all the way up to
Ali2, 49
Ali2, 50
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
July 1, 2009 at 2:27 am
Can you give us some sample data for the Ranges table? Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
July 1, 2009 at 1:59 am
ali.m.habib (7/1/2009)
select *from RANGES CROSS APPLY dbo.fnCrossJoinRange2([Ranges.from],[Ranges.to])
but give the same error
Is the database case sensitive? If so, you'll need to fix the case in the proc's parameters.
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
July 1, 2009 at 1:31 am
To pass columns from a table as parameters to a table-valued function in the same FROM clause, you need CROSS APPLY, not CROSS JOIN
select <Column list >
from RANGES
CROSS APPLY dbo.fnCrossJoinRange2([Ranges.from],[Ranges.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
July 1, 2009 at 1:11 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic745120-150-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
July 1, 2009 at 1:06 am
Nag (6/30/2009)
Does it occur regularly? 2 times only everyday almost @ sametime
What else happens at those 2 times a day? A 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
July 1, 2009 at 1:03 am
SQL Noob (6/30/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
July 1, 2009 at 1:00 am
You can query sys.partitions and sys.data_spaces to see what filegroups objects are on. I don't have the query handy, but it's an easy one to write.
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
July 1, 2009 at 12:59 am
jvElecenter (6/30/2009)
What can be the issue ?
In all honestly, just about anything.
Is there blocking?
Are the queries waiting for a resource?
Is there IO contention?
Is there memory contention?
Are there any unusual 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
June 30, 2009 at 3:15 pm
Gianluca Sartori (6/30/2009)
Lynn Pettis (6/30/2009)
Don't know about you, but mine seems...
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 30, 2009 at 3:13 pm
Yes he is and he doesn't claim that his tests are independent. There's a doc with the reproducible tests if you wish to check for yourself.
http://chucksblog.typepad.com/ntap/NetAppProveItKit1006.doc
Other thing to note 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
June 30, 2009 at 2:55 pm
http://chucksblog.typepad.com/chucks_blog/2006/12/benchmarketing_.html
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 30, 2009 at 2:21 pm
SAT_SQL (6/29/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 30, 2009 at 2:14 pm
Lynn Pettis (6/30/2009)
Gail, you'll like this one. The OP wants us to use our crystal ball to help solve his problem.
< rubs hands together >
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 30, 2009 at 2:11 pm
Indianrock (6/30/2009)
( sql cluster with Netapp storage ).
Have you done IO stress tests on that?
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 30, 2009 at 1:59 pm
Viewing 15 posts - 37,996 through 38,010 (of 49,552 total)