Viewing 15 posts - 256 through 270 (of 465 total)
So far, it's only in my development system, and I'm trying to learn every aspect of how it works, before I send it out into the real world to fend...
February 25, 2014 at 2:32 am
So if the query gives me what I need, I should ignore whatever the design view says? I'm kind of leery about ignoring warning messages - I always wonder if...
February 25, 2014 at 1:27 am
OK, that's a good idea, I'll do it that way. The DB doesn't care whether it's a real name, or a delimiter - it'll string it all together regardless.
Not sure...
February 24, 2014 at 2:39 pm
Okay, I see. I was concentrating on the disadvantages inherent in each method, and didn't think of using both together. It would require manual maintenance of the coherence between the...
February 24, 2014 at 1:53 pm
Hm, you've lost me. Second table? Do you mean keep the table where I now store the set of records from which the author string is assembled? And another table,...
February 24, 2014 at 12:54 pm
It's crucial. That's what the ordering field is for.
February 24, 2014 at 12:32 pm
SQL!$@w$0ME (11/29/2013)
Thanks a lot guys... I forgot to mention that this dev environment is a VM. Does these drive recommendations still applies even if its in vm?
If it's a VM,...
November 30, 2013 at 2:59 am
SQL!$@w$0ME (11/28/2013)
For dev environment d: for app, e: for data, f: for log, g: for tempdb and h: for backup is it too much im asking for?
If each of...
November 29, 2013 at 12:00 pm
Biggest skill I need is how to find stuff on SQLServercentral.com
November 22, 2013 at 11:51 am
Life-long techno-nerd, started with computers in college on a Univac 9300, programming in FORTRAN on 80-column punch cards. Stayed with computers as they developed, wound up in a museum's IT...
October 23, 2013 at 11:05 am
jonysuise (10/17/2013)
Check this post. Might help.http://carlosbercero.com/post/?post=Writing_a_CLR_Stored_Procedure_on_SQL_Server
But back to the original question, actually. Do you know if any of these methods are faster? That was my interest in this, to try...
October 17, 2013 at 11:20 pm
jonysuise (10/17/2013)
Check this post. Might help.http://carlosbercero.com/post/?post=Writing_a_CLR_Stored_Procedure_on_SQL_Server
Okay, thanks, I'll try that. I use Access, not VS, but the principles should be similar.
October 17, 2013 at 2:29 pm
jonysuise (10/17/2013)
Use master..xp_cmdshell or CLR stored procedures instead.master.dbo.xp_dirtree is an undocumented and unsupported procedure.
I was trying to avoid xp_cmdshell for all the security problems. Also, dirtree provides the file...
October 17, 2013 at 12:55 pm
One DBA (me) supporting one developer (me) servicing around 30 users, running 3 servers. Yes, I'm up to *** in alligators.
October 4, 2013 at 9:21 am
I don't normally need a very large log. This size is an aberration, created only when I do the occasional large import, and combine it with a malfunction of my...
September 16, 2013 at 2:35 pm
Viewing 15 posts - 256 through 270 (of 465 total)