Viewing 15 posts - 47,866 through 47,880 (of 49,571 total)
What error are you getting?
Edit: Why not just exec the proc? There's no point to a temp table in the code you posted.
January 2, 2008 at 12:42 pm
Michael Valentine Jones (1/2/2008)
January 2, 2008 at 12:32 pm
EdVassie (1/2/2008)
Aye, but you can use OPTION (MAXRECURSION 0) to allow unlimited recursion, and get billions of rows in the result set if you need them.
Cool. Didn't notice that. Thanks
January 2, 2008 at 11:58 am
For the beginning and end of the day, week, month, quarter, year...
http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/%5B/url%5D
I've done the end of the intervals at 3ms before the beginning of the next (ie, end of today...
January 2, 2008 at 11:46 am
Kenneth Fisher (1/2/2008)
January 2, 2008 at 11:43 am
Good point. Thanks.
January 2, 2008 at 11:20 am
Use the sys.object view, rather than sysobjects. sys.objects has both a type and a type_description column, so you can see exactly what's what.
January 2, 2008 at 6:00 am
CTEs are nice for generating smallish amounts of data, but the max number of rows a recursive CTE can return (without using cross joins, union or while loop) is 32767....
January 2, 2008 at 5:14 am
MarkusB (1/2/2008)
which according to BOL means "Cumulative count of leaf-level page allocations in the index or heap. For an index, a page allocation corresponds to...
January 2, 2008 at 4:23 am
Thanks Markus. Will check that out.
Chirag: I'm not looking for the umber of pages in the index. That's easy. What I'm trying to get an idea of is how often...
January 2, 2008 at 4:04 am
You can read the contents of the system tables if you connect using the DAC. They're not that interesting and are quite hard to understand, since there's no documentation anywhere....
January 2, 2008 at 1:11 am
Joins done in the from are easier to read and reduce the chances of getting an unwanted cross join.
In addition, the old-style outer join syntax (Table1.Col1 *= Table2.Col1) is...
January 2, 2008 at 1:05 am
Add a column of type int (that's 1.4 million records you have. Int goes up to 2.1 billion) and set identity on.
Edit: And if you do expect more than 2.1...
January 2, 2008 at 1:02 am
Ziljan4 (1/2/2008)
What would be your first instinct when you see log file growing, and how do you usually handle it?
Check my tran log backups, make sure they are running....
January 2, 2008 at 12:59 am
Viewing 15 posts - 47,866 through 47,880 (of 49,571 total)