Viewing 15 posts - 38,011 through 38,025 (of 49,571 total)
San (7/1/2009)
And of course there is section "SQL Jobs" in this site. Hope you have noted it
And a 'resumes and job hunters' forum that this should have been posted in....
July 1, 2009 at 7:05 am
The only way I know is buying something like SQLPrompt (Redgate). There's no built-in intellisense in SQL 2005 and the intellisense built into SQL 2008 only works when connected to...
July 1, 2009 at 7:03 am
Right where it is now.
Not everyone's going to rush to cloud computing and not all databases are even suitable for putting in the cloud.
July 1, 2009 at 6:59 am
ps (7/1/2009)
Am still wondering why we didnt lost any data from one of the damaged pages that belonged to the other table.
Without seeing the output of checkDB for that database,...
July 1, 2009 at 6:54 am
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
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/
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.
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])...
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
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?
July 1, 2009 at 1:03 am
SQL Noob (6/30/2009)
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.
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...
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...
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...
June 30, 2009 at 2:55 pm
Viewing 15 posts - 38,011 through 38,025 (of 49,571 total)