Viewing 15 posts - 18,166 through 18,180 (of 22,202 total)
Will they still compile? Leave 'em there. If not, clean 'em out.
February 27, 2009 at 5:43 am
Jeff Moden (2/26/2009)
February 27, 2009 at 5:41 am
Jeff Moden (2/26/2009)
Darwin knew this was possible...http://www.sqlservercentral.com/Forums/Topic665342-148-1.aspx
What? You don't know about Type II? You been living in a cave?
February 27, 2009 at 5:35 am
There's a heck of lot here to chew on, but the first thing that jumped out at me was the this little bit of RBAR (row-by-agonizing-row) processing:
while @RevStateyr < '1991'
Begin
...
February 26, 2009 at 8:42 pm
I'd have to do some experimentation with it to be sure, but according to BOL you can get the DMV sys.dm_exec_query_requests has the sql_handle and statement_start_offset combined with statement_end_offset that...
February 26, 2009 at 8:00 pm
I just got directly to the page by googling '"Are the posted questions getting worse" karate'.
Apparently I was quoting Captain Queeg. It must have been right after a Cub...
February 26, 2009 at 7:49 pm
Since I'm using SQLPrompt Pro, I can force the formatting however I want. I just saw that Apress has a formatting tool that's free. It might be worth a look-see.
February 26, 2009 at 1:23 pm
I can't say I'm crazy about it, but all the cool kids are doing it, so I do to.
February 26, 2009 at 1:10 pm
Since there are so many hard core SF readers on here, I thought I'd pass on what I just heard. Phlip Jose Farmer has died. http://reason.com/blog/show/131886.html
I read tons and tons...
February 26, 2009 at 10:47 am
You can set a database to be read_only and you can set a file group to be read_only. I don't think you do that with a table. If it's the...
February 26, 2009 at 8:55 am
Oh, you mean something that captures the execution context, that'll show the methods used to call the proc like EXEC blah, blah and include the parameter names & values?
In 2008...
February 26, 2009 at 8:14 am
Heck. I thought LISP was stacks of comma's. What am I thinking of then. I worked with some damned language back in '92 or '93 where the code looked like:
exec...
February 26, 2009 at 6:56 am
I'm sorry, I don't understand the question.
When you create a procedure, you define parameters with a certain name and a certain data type, nullability and default values. Within the procedure...
February 26, 2009 at 6:24 am
In general DBA's are considered trusted employees because they can access the data. That's one of the reasons the job pays more. If they can't trust the DBA, time to...
February 26, 2009 at 6:13 am
For those that have the trees, I can't recommend an outdoor woodburning furnace enough. We've been toasty through one of the coldest winters I've ever experienced. Of course, when we...
February 26, 2009 at 5:41 am
Viewing 15 posts - 18,166 through 18,180 (of 22,202 total)